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.

When this happens...
New Spreadsheet Row
Triggers when a new row is added to the bottom of a spreadsheet.
TriggerInstant
automatically do this...
Find Record
Find a record in a table.
ActionSearch
then do this!
Update Record
Update a record in a specific table.
ActionWrite

Start free with email

Start free with Google

Start free with email

Start free with Google

Free forever for core features
14 day trial for premium features & apps

Supported triggers and actions

- Drive
- SpreadsheetRequired
- WorksheetRequired
Trigger
Polling
Try It
- Drive
Trigger
Polling
Try It
- No Team Drive
- SpreadsheetRequired
- WorksheetRequired
- Trigger column
Trigger
Instant
Try It
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Column NameRequired
- Index
Action
Write
- Drive
- SpreadsheetRequired
- WorksheetRequired
Action
Write
- Drive
- Spreadsheet Containing the Worksheet to CopyRequired
- Worksheet to CopyRequired
- Copy Worksheet Destination
Action
Write
- Drive
- SpreadsheetRequired
- TitleRequired
- Overwrite existing worksheet with the same title
- Headers
Action
Write
- Info
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Row(s)Required
Action
Write
- Drive
- SpreadsheetRequired
- WorksheetRequired
- RowRequired
- Background Color
- Text Color
- Bold
- Italic
- Strikethrough
Action
Write
- Stop on errorRequired
- HTTP MethodRequired
- URLRequired
- Query string parameters
- Additional request headers
- Body
Action
Write
- Drive
- SpreadsheetRequired
- WorksheetRequired
- ColumnsRequired
- Row countRequired
- Output format
- First row
Action
Search
- Drive
- SpreadsheetRequired
- TitleRequired
- Overwrite existing worksheet with the same title
- Headers
Action
Search or write
- BaseRequired
- TableRequired
- Limit to View
- Include attachment content
Trigger
Polling
Try It
- BaseRequired
- TableRequired
Action
Write
- BaseRequired
- TableRequired
- Help Text
- Primary lookup fieldRequired
- Secondary lookup field
Action
Write
- BaseRequired
- TableRequired
- RecordRequired
Action
Write
- BaseRequired
- TableRequired
- Search by Field
- Search Value
- Search type
- Search Formula
- Limit to View
Action
Search

- No Team Drive
- SpreadsheetRequired
- WorksheetRequired
Trigger
Instant
Try It
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Trigger column
Trigger
Polling
Try It
- Drive
- SpreadsheetRequired
Trigger
Polling
Try It
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Use Timezone set up on the spreadsheet to format date values?
Action
Write
- Drive
- SpreadsheetRequired
- WorksheetRequired
Action
Write
- TitleRequired
- Spreadsheet to Copy
- Headers
Action
Write
- Info
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Row(s)Required
Action
Write
- Drive
- SpreadsheetRequired
- WorksheetRequired
- RowRequired
- Background Color
- Text Color
- Bold
- Italic
- Strikethrough
Action
Write
- Drive
- SpreadsheetRequired
- WorksheetRequired
Action
Write
- Drive
- SpreadsheetRequired
- TitleRequired
Action
Search
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Lookup columnRequired
- Lookup valueRequired
- Supporting lookup column
- Supporting lookup value
- Search from last row
Action
Search
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Lookup columnRequired
- Lookup valueRequired
- Supporting lookup column
- Supporting lookup value
- Search from last row
Action
Search or write
- Help Text
- BaseRequired
- TableRequired
- Last modified time columnRequired
- Limit to view
- Include file contents?
Trigger
Polling
Try It
- Cache Copy
- BaseRequired
- TableRequired
Action
Write
- BaseRequired
- TableRequired
- RecordRequired
Action
Write
- Stop on errorRequired
- HTTP MethodRequired
- URLRequired
- Query string parameters
- Additional request headers
- Body
Action
Write
- BaseRequired
- TableRequired
- Search by Field
- Search Value
- Search type
- Search Formula
- Limit to View
Action
Search or write

About Airtable

Organize anything with Airtable, a modern database created for everyone. Airtable is a fast and flexible way to create tables to keep track of anything, from sales leads to vacation planning to inventory management.

Learn more

Related categories

Databases

Similar apps

About Google Sheets

Create, edit, and share spreadsheets wherever you are with Google Sheets, and get automated insights from your data.

Learn more

Airtable + Google Sheets

Find specific Airtable records and update them from a Google Sheet

Supported triggers and actions

New Spreadsheet Row (Team Drive)

New Spreadsheet

New or Updated Spreadsheet Row

Create Spreadsheet Column

Create Multiple Spreadsheet Rows

Copy Worksheet

Create Worksheet

Delete Spreadsheet Row(s)

Update Spreadsheet Row

API Request (Beta)

Get Many Spreadsheet Rows (Advanced)

Find or Create Worksheet

New Record

Create Record

Create or Update Record

Update Record

Find Record

New Spreadsheet Row

New or Updated Spreadsheet Row (Team Drive)

New Worksheet

Create Spreadsheet Row

Create Spreadsheet Row at Top

Create Spreadsheet

Clear Spreadsheet Row(s)

Format Spreadsheet Row

Update Spreadsheet Row(s)

Find Worksheet

Lookup Spreadsheet Row

Find or Create Row

New or Updated Record

Create Records (Advanced)

Delete Record

API Request (Beta)

Find or Create Record

About Airtable

Related categories

Similar apps

Quickbase

Zoho Creator

Smartsheet

About Google Sheets

Related categories

Similar apps

Zapier Tables

Zoho Creator

Smartsheet

Related Zap Templates

Related Zap Templates