Send New Airtable Records to Google Sheets

2 min setup
No coding required
Runs automatically

Teams that keep data in Airtable often still need it in Google Sheets for reports, sharing or formulas, and copying it over by hand falls behind fast. This workflow adds a Google Sheets row every time a record is created in an Airtable table, so the sheet stays in sync without exports.

airtable logo icon
When a record is created in your Airtable table
google sheets logo icon
Add the record as a new row in Google Sheets

How it works

2 steps to keep a Google Sheet in sync with your Airtable base, no exports

airtable logo icon

When a record is created in your Airtable table

App connector: Airtable • Time to complete: 1 minute

Runs when a new record is created in the chosen Airtable base and table.

google sheets logo icon

Add the record as a new row in Google Sheets

App connector: Google Sheets • Time to complete: 1 minute

Add a row to the chosen spreadsheet and sheet, mapping each Airtable field to its column. Include the Airtable record ID in its own column so rows can be matched later.

Trusted by 1,000+ merchants
Logo: Rothy's Logo: Adidas Logo: Allure Logo: GQ Logo: DraftKings Logo: Chubbies Logo: Made In Cookware Logo: MUD/WTR

Ready to keep a Google Sheet in sync with your Airtable base, no exports

Get setup in 2 minutes.

Use this template →

FAQs

Does this copy records that already exist in Airtable?

No. It copies records created after the workflow is turned on. Export existing records to CSV once and paste them into the sheet to start.

What happens when an Airtable record is edited?

This workflow only adds new records. To keep edits in sync too, add a second workflow on Airtable's Record Updated trigger that updates the matching row by record ID.

Can I send data from Google Sheets to Airtable instead?

Yes. Reverse it: start from Google Sheets' Row Created trigger and finish with Airtable's Add Record action.

Personalize this template

Customize this workflow even further:

Sync edits as well
Use the Record Updated trigger with Google Sheets Query Rows and Update Row to change the matching row whenever an Airtable record changes.
Only copy some records
Add a Filter step after the trigger so only records with a certain status or view make it to the sheet.

You're in good company

"MESA has been a game changer for us. And, if you ever get stuck, their support team is always super helpful."

  • Ico star
  • Ico star
  • Ico star
  • Ico star
  • Ico star
PetFriendly

"It's like Zapier but exactly designed for Shopify. I have been able to complete all the workflows that I've needed."

  • Ico star
  • Ico star
  • Ico star
  • Ico star
  • Ico star
Zailys

"The MESA team has been amazing at helping us set up our automations. We would highly recommend this app!"

  • Ico star
  • Ico star
  • Ico star
  • Ico star
  • Ico star
Rothy's

keep a Google Sheet in sync with your Airtable base, no exports

2 min setup • Fully supported if you need help