Airtable + Google Sheets
Create Airtable records for new or updated rows in a Google Sheet (Team Drive)
When you are adding data into a spreadsheet, you may want it organized in your database. This integration helps by automatically creating a record in Airtable with info from a new or updated row in a specified Google Sheet (team Drive). You won't have to copy and paste to update your database anymore.
When you are adding data into a spreadsheet, you may want it organized in your database. This integration helps by automatically creating a record in Airtable with info from a new or updated row in a specified Google Sheet (team Drive). You won't have to copy and paste to update your database anymore.
- When this happens...
New or Updated Spreadsheet Row (Team Drive)Triggers when a new row is added or modified in a spreadsheet - works best with Team Drives.
TriggerScheduledZapier checks for new data every 15 min on the Free plan - automatically do this!
Create RecordCreates a new record with auto-populating fields.
ActionWriteCreate a new record or update an existing record in your app.
- Free forever for core features
- 14 day trial for premium features & apps
Drive
SpreadsheetRequired
WorksheetRequired
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planNo Team Drive
SpreadsheetRequired
WorksheetRequired
Trigger Column
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Drive
SpreadsheetRequired
WorksheetRequired
Column NameRequired
Index
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.TitleRequired
Spreadsheet to Copy
Headers
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
RowRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
RowRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.HTTP MethodRequired
URLRequired
Query String Parameters
Headers
Additional Request Headers
Body
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
TitleRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appDrive
SpreadsheetRequired
WorksheetRequired
Lookup ColumnRequired
Lookup ValueRequired
Supporting Lookup Column
Supporting Lookup Value
Search from last row
ActionThis is an event a Zap performs.SearchFind existing data in your appDrive
SpreadsheetRequired
WorksheetRequired
Lookup ColumnRequired
Lookup ValueRequired
Supporting Lookup Column
Supporting Lookup Value
Search from last row
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is foundBaseRequired
TableRequired
Help Text
Which timestamp field should this Zap use to check for updates?Required
Limit to View
Include file contents?
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planCache Copy
BaseRequired
TableRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.BaseRequired
TableRequired
RecordRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.HTTP MethodRequired
URLRequired
Query String Parameters
Headers
Additional Request Headers
Body
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.BaseRequired
TableRequired
Search by Field
Search Value
Search for Exact Match?
Search Formula
Limit to View
ActionThis is an event a Zap performs.SearchFind existing data in your appBaseRequired
TableRequired
Search by Field
Search Value
Search for Exact Match?
Search Formula
Limit to View
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is found
No Team Drive
SpreadsheetRequired
WorksheetRequired
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Drive
SpreadsheetRequired
WorksheetRequired
Trigger Column
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planDrive
SpreadsheetRequired
WorksheetRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
Spreadsheet Containing the Worksheet to CopyRequired
Worksheet to CopyRequired
Copy Worksheet Destination
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
TitleRequired
Overwrite existing worksheet with the same title
Headers
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
RowRequired
Background Color
Text Color
Bold
Italic
Strikethrough
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
Lookup ColumnRequired
Lookup ValueRequired
Supporting Lookup Column
Supporting Lookup Value
Search from last row
Row Count
ActionThis is an event a Zap performs.SearchFind existing data in your appDrive
SpreadsheetRequired
WorksheetRequired
ColumnsRequired
Row CountRequired
First Row
ActionThis is an event a Zap performs.SearchFind existing data in your appDrive
SpreadsheetRequired
TitleRequired
Overwrite existing worksheet with the same title
Headers
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is foundBaseRequired
TableRequired
Limit to View
Include file contents?
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planBaseRequired
TableRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.BaseRequired
TableRequired
Lookup FieldRequired
Secondary Lookup Field
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.BaseRequired
TableRequired
RecordRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.BaseRequired
TableRequired
Search by Field
Search Value
Search for Exact Match?
Search Formula
Limit to View
Include file contents?
Max Records
ActionThis is an event a Zap performs.SearchFind existing data in your appBaseRequired
TableRequired
Search by Field
Search Value
Search for Exact Match?
Search Formula
Limit to View
Include file contents?
Max Records
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is found
About Airtable
Related categories
About Google Sheets
Related categories
Related Zap Templates
- Add new Airtable records in views to Google Sheets
- Save new Google Sheets rows to Airtable
- Update Airtable records with newly-updated rows in Google Sheets spreadsheets
- Track new Airtable records in Google Sheets rows
- Update Google Sheets rows with new or updated Airtable records.
- Update Airtable records with new or updated Google Sheets rows
- Create or update Airtable records from new or updated rows in Google Sheets
- Track new survey responses and alert a team via email
- Create rows in Google Sheets with new or updated Airtable records
- Create Google Sheet row(s) for new Airtable records
- Create Airtable records from new or updated Google Sheets spreadsheet rows
- Create Google Sheets rows for new updates to Airtable records
- Create new Google Sheets worksheets for each new Airtable record
- Create Airtable records for new Google Sheets rows
- Create Google Sheet rows for new Airtable records in a view
- Create Airtable records from new or updated Google Sheets rows.
- Create Airtable records for new Google Sheets rows.
- Create Airtable records with line items from new or updated Google Sheets rows
- Update Google Sheets rows with new or updated Airtable records
- Create Airtable records from new Google Sheets rows with line items
- Create multiple Google Sheets rows for new or updated Airtable records
- Update Airtable records when new or updated Google Sheets team drive spreadsheet rows are detected
- Create Airtable records with line item support from new or updated Google Sheets rows in team drive
- Create or update Google Sheets worksheets when new or updated Airtable records appear
- Copy new or updated Airtable records to Google Sheets worksheets
- Create new Google Sheets worksheets for every record added to Airtable
- Add new Airtable records to Google Sheets as rows
- Update Google Sheets rows with new Airtable records
- Create multiple Google Sheets rows from new Airtable records in view
- Create Google Sheets rows for new or updated Airtable records
- Add new Airtable records to Google Sheets as multiple rows
- Update Google Sheets rows with new or updated Airtable records
- Add new Airtable records to Google Sheets as rows
- Create spreadsheets in Google Sheets for new Airtable records
- How to Connect Apps to Webhooks Demo #1
- Create new records in Airtable from new worksheets in Google Sheets
- Create or update Airtable records with new or updated Google Sheets rows on team drive
- Create or update Airtable records from new Google Sheets rows
- Create Google Sheets columns for new or updated Airtable records
- Update Google Sheets rows with new Airtable records
- Maintain and update Airtable extensions with every new or updated row in Google Sheets
- Create or update Airtable records from new rows in Google Sheets team drive
- Create and update Google Sheets spreadsheets with new or updated Airtable records
- Create new actions in Google Sheets when new records appear in Airtable
- Create records in Airtable from new spreadsheets in Google Sheets
- Update Airtable records when new rows are added to Google Sheets in team drive
- Create Google Sheets columns for new Airtable records
- Find specific Airtable records and update them from a Google Sheet
- Create new Airtable records with line items for each new row in Google Sheets
- Create or update Airtable records when new spreadsheets are added in Google Sheets
- Update Airtable records with new or updated rows from Google Sheets team drive
- Create records in Airtable from new rows in Google Sheets
Related Zap Templates
- Add new Airtable records in views to Google Sheets
- Track new Airtable records in Google Sheets rows
- Create or update Airtable records from new or updated rows in Google Sheets
- Create Google Sheet row(s) for new Airtable records
- Create new Google Sheets worksheets for each new Airtable record
- Create Airtable records from new or updated Google Sheets rows.
- Update Google Sheets rows with new or updated Airtable records
- Update Airtable records when new or updated Google Sheets team drive spreadsheet rows are detected
- Copy new or updated Airtable records to Google Sheets worksheets
- Update Google Sheets rows with new Airtable records
- Add new Airtable records to Google Sheets as multiple rows
- Create spreadsheets in Google Sheets for new Airtable records
- Create or update Airtable records with new or updated Google Sheets rows on team drive
- Update Google Sheets rows with new Airtable records
- Create and update Google Sheets spreadsheets with new or updated Airtable records
- Update Airtable records when new rows are added to Google Sheets in team drive
- Create new Airtable records with line items for each new row in Google Sheets
- Create records in Airtable from new rows in Google Sheets
- Save new Google Sheets rows to Airtable
- Update Google Sheets rows with new or updated Airtable records.
- Track new survey responses and alert a team via email
- Create Airtable records from new or updated Google Sheets spreadsheet rows
- Create Airtable records for new Google Sheets rows
- Create Airtable records for new Google Sheets rows.
- Create Airtable records from new Google Sheets rows with line items
- Create Airtable records with line item support from new or updated Google Sheets rows in team drive
- Create new Google Sheets worksheets for every record added to Airtable
- Create multiple Google Sheets rows from new Airtable records in view
- Update Google Sheets rows with new or updated Airtable records
- How to Connect Apps to Webhooks Demo #1
- Create or update Airtable records from new Google Sheets rows
- Maintain and update Airtable extensions with every new or updated row in Google Sheets
- Create new actions in Google Sheets when new records appear in Airtable
- Create Google Sheets columns for new Airtable records
- Create or update Airtable records when new spreadsheets are added in Google Sheets
- Update Airtable records with newly-updated rows in Google Sheets spreadsheets
- Update Airtable records with new or updated Google Sheets rows
- Create rows in Google Sheets with new or updated Airtable records
- Create Google Sheets rows for new updates to Airtable records
- Create Google Sheet rows for new Airtable records in a view
- Create Airtable records with line items from new or updated Google Sheets rows
- Create multiple Google Sheets rows for new or updated Airtable records
- Create or update Google Sheets worksheets when new or updated Airtable records appear
- Add new Airtable records to Google Sheets as rows
- Create Google Sheets rows for new or updated Airtable records
- Add new Airtable records to Google Sheets as rows
- Create new records in Airtable from new worksheets in Google Sheets
- Create Google Sheets columns for new or updated Airtable records
- Create or update Airtable records from new rows in Google Sheets team drive
- Create records in Airtable from new spreadsheets in Google Sheets
- Find specific Airtable records and update them from a Google Sheet
- Update Airtable records with new or updated rows from Google Sheets team drive