Airtable + Google Sheets
Find specific Airtable records and update them from a Google Sheet
This Zap automates the synchronization of data between Google Sheets and Airtable, streamlining your workflow and ensuring accuracy. Whenever a new row is added to your specified Google Sheet, this Zap will search for a corresponding record in Airtable based on your defined criteria. If a matching record is found, it will update that record with the new information from Google Sheets.
This Zap automates the synchronization of data between Google Sheets and Airtable, streamlining your workflow and ensuring accuracy. Whenever a new row is added to your specified Google Sheet, this Zap will search for a corresponding record in Airtable based on your defined criteria. If a matching record is found, it will update that record with the new information from Google Sheets.
- When this happens...
New Spreadsheet RowTriggers when a new row is added to the bottom of a spreadsheet.
TriggerInstantThis event starts a Zap instantly. - automatically do this...
Find RecordFind a record in a table.
ActionSearchFind existing data in your app - then do this!Update Record
Update a record in a specific table.
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 ZapPollingZapier 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.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.Info
Drive
SpreadsheetRequired
WorksheetRequired
Row(s)Required
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.Stop on errorRequired
HTTP MethodRequired
URLRequired
Query string parameters
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 foundHelp Text
BaseRequired
TableRequired
Last modified time columnRequired
Limit to view
Include file contents?
Try ItTriggerThis is the start of your ZapPollingZapier 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.Stop on errorRequired
HTTP MethodRequired
URLRequired
Query string parameters
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 type
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 type
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 ZapPollingZapier checks for new data every 15 min on the Free planDrive
SpreadsheetRequired
WorksheetRequired
Use Timezone set up on the spreadsheet to format date values?
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.Info
Drive
SpreadsheetRequired
WorksheetRequired
Row(s)Required
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
Output format
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 attachment content
Try ItTriggerThis is the start of your ZapPollingZapier 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
Help Text
Primary 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
Field to search
Search value
Search type
Search formula (advanced)
Limit to view
Include attachment content
Max records
ActionThis is an event a Zap performs.SearchFind existing data in your appBaseRequired
TableRequired
Field to search
Search value
Search type
Search formula (advanced)
Limit to view
Include attachment content
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 Airtable records for new Google Sheets rows
- Track new survey responses and alert a team via email
- Create Google Sheet row(s) for new Airtable records
- Create or update Airtable records from new or updated rows in Google Sheets
- Create rows in Google Sheets with new or updated Airtable records
- Create new Google Sheets worksheets for each new Airtable record
- Create Airtable records from new or updated Google Sheets spreadsheet rows
- Create Airtable records for new or updated rows in a Google Sheet (Team Drive)
- Create Google Sheet rows for new Airtable records in a view
- Create Google Sheets rows for new updates to Airtable records
- 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
- 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
- Update Airtable records when new rows are added in Google Sheets
- Update or create Airtable records from new or updated rows in Google Sheets team drive
- Track new or updated Airtable records by creating rows in Google Sheets
- Manage new or updated Google Sheets rows by creating or updating records in Airtable
- Create or update Airtable records from new or updated rows in your Google Sheets team drive
- Create Airtable records from new Google Sheets rows in team drive
- Create top rows in Google Sheets for new Airtable records
- Create Google Sheets rows at top for new or updated Airtable records
Related Zap Templates
- Add new Airtable records in views to Google Sheets
- Track new Airtable records in Google Sheets rows
- Create Airtable records for new Google Sheets rows
- Create or update Airtable records from new or updated rows in Google Sheets
- Create Airtable records from new or updated Google Sheets spreadsheet rows
- Create Google Sheets rows for new updates to Airtable records
- 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
- Create new Airtable records with line items for each new row in Google Sheets
- Create records in Airtable from new rows in Google Sheets
- Track new or updated Airtable records by creating rows in Google Sheets
- Create Airtable records from new Google Sheets rows in team drive
- 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 rows in Google Sheets with new or updated Airtable records
- Create Airtable records for new or updated rows in a Google Sheet (Team Drive)
- 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 or update Airtable records when new spreadsheets are added in Google Sheets
- Update Airtable records when new rows are added in Google Sheets
- Manage new or updated Google Sheets rows by creating or updating records in Airtable
- Create top rows in Google Sheets for new Airtable records
- Update Airtable records with newly-updated rows in Google Sheets spreadsheets
- Update Airtable records with new or updated Google Sheets rows
- Create Google Sheet row(s) for new Airtable records
- Create new Google Sheets worksheets for each new Airtable record
- Create Google Sheet rows for new Airtable records in a view
- 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
- Update Airtable records with new or updated rows from Google Sheets team drive
- Update or create Airtable records from new or updated rows in Google Sheets team drive
- Create or update Airtable records from new or updated rows in your Google Sheets team drive
- Create Google Sheets rows at top for new or updated Airtable records