Airtable + Google Sheets Integrations

How to connect Airtable + Google Sheets

Zapier lets you send info between Airtable and Google Sheets automatically—no code required.

When this happens...

New Record

Triggers when a new record is available.

automatically do this!

Copy Worksheet

Create a new worksheet by copying an existing worksheet.

Popular Airtable + Google Sheets workflows

Our most popular Zap! arrow pointing down

Add new Airtable records in a view to Google Sheets
Airtable + Google Sheets
More details
When this happens
Step 1: New Record in View
Then do this
Step 2: Create Spreadsheet Row
See Zap details Try it
Add new Airtable records in a view to Google Sheets
Add new Airtable records in a view to Google Sheets
Airtable + Google Sheets
Save new Google Sheets rows to Airtable
Google Sheets + Airtable
More details
When this happens
Step 1: New Spreadsheet Row
Then do this
Step 2: Create Record
See Zap details Try it
Save new Google Sheets rows to Airtable
Save new Google Sheets rows to Airtable
Google Sheets + Airtable
Update Airtable records with newly-updated rows in Google Sheets spreadsheets
Google Sheets + Airtable
More details
When this happens
Step 1: New or Updated Spreadsheet Row
Then do this
Step 2: Update Record
See Zap details Try it
Update Airtable records with newly-updated rows in Google Sheets spreadsheets
Update Airtable records with newly-updated rows in Google Sheets spreadsheets
Google Sheets + Airtable
Track new Airtable records in Google Sheets rows
Airtable + Google Sheets
More details
When this happens
Step 1: New Record
Then do this
Step 2: Create Spreadsheet Row
See Zap details Try it
Track new Airtable records in Google Sheets rows
Track new Airtable records in Google Sheets rows
Airtable + Google Sheets
Track new survey responses and alert a team via email
Google Sheets + Airtable + Gmail
More details
When this happens
Step 1: New Spreadsheet Row
Then do this
Step 2: Create Record
Then do this
Step 3: Send Email
See Zap details Try it
Track new survey responses and alert a team via email
Track new survey responses and alert a team via email
Google Sheets + Airtable + Gmail

Do Even More with Airtable + Google Sheets

With Zapier, you can do more than just connect 2 apps—you can automate entire processes from beginning to end! Here are some popular ways users make their Airtable + Google Sheets workflows do more for them.

Zapier users love adding Gmail to their workflows
Track new survey responses and alert a team via email
Track new survey responses and alert a team via email
Try it
Airtable + Gmail + Google Sheets

Supported triggers and actions

What does this mean?

New Record
Triggers when a new record is available.
Trigger
Scheduled
New Record in View
Triggers when a new record is available in a view.
Trigger
Scheduled
New or Updated Record
Triggers when a record is created or updated.
Trigger
Scheduled
Create Record
Creates a new record with auto-populating fields.
Action
Write
Update Record
Update the values of specific cells in an Airtable record.
Action
Write

Find Record
Use simple field search or Airtable's powerful formula syntax to find a matching Airtable record. Learn more at
Action
Search
Find or Create Record
Find or Create Record
Action
Search or write

New Spreadsheet Row (Team Drive)
Triggered when a new row is added to the bottom of a spreadsheet - works best with Team Drives.
Trigger
Scheduled

Google Sheets
Triggered when a new row is added to the bottom of a spreadsheet.
Instant
Trigger
Google Sheets
Triggered when you create a new spreadsheet.
Scheduled
Trigger
Google Sheets
Triggered when a new row is added or modified in a spreadsheet - works best with Team Drives.
Scheduled
Trigger
Google Sheets
Triggered when a new row is added or modified in a spreadsheet.
Instant
Trigger
Google Sheets
Triggered when you create a new worksheet in a spreadsheet.
Scheduled
Trigger
Google Sheets
Create a new column in a specific spreadsheet.
Scheduled
Action
Google Sheets
Create a new row in a specific spreadsheet.
Scheduled
Action
Google Sheets
Create one or more new rows in a specific spreadsheet (with line item support).
Scheduled
Action
Google Sheets
Create a new worksheet by copying an existing worksheet.
Scheduled
Action
Google Sheets
Create a blank spreadsheet or duplicate an existing spreadsheet. Optionally, provide headers.
Scheduled
Action
Google Sheets
Create a blank worksheet with a title. Optionally, provide headers.
Scheduled
Action
Google Sheets
Deletes the content of a row in a specific spreadsheet. Deleted rows will appear as blank rows in your spreadsheet. Please use with caution.
Scheduled
Action
Google Sheets
Update a row in a specific spreadsheet.
Scheduled
Action
Google Sheets
Finds many matched rows (10 max.) by a column and value.
Scheduled
Action
Google Sheets
Returns many rows (20 max.) as a single JSON value and flat rows (line items).
Scheduled
Action
Google Sheets
Finds a row by a column and value. Returns the entire row if one is found.
Scheduled
Action
Google Sheets
Finds or creates a specific lookup row.
Scheduled
Action

How Airtable + Google Sheets Integrations Work

Step 1: Authenticate Airtable + Google Sheets.
30 seconds
Step 2: Pick one of the apps as a trigger, which will kick off your automation.
15 seconds
Step 3: Choose a resulting action from the other app.
15 seconds
Step 4: Select the data you want to send from one app to the other.
2 minutes
That’s it! More time to work on other things.

Connect apps

Connect Airtable + Google Sheets

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