Airtable and Google Sheets automations

Set up an automation: when record created or updated in Airtable, update spreadsheet row in Google Sheets

Build it

50agents builds it as an automation, and asks before anything goes outside.

Airtable and Google Sheets in practice

Used for

Each new Airtable record is added as a row in Google Sheets.

Best template

“New Records Appear” in Airtable, then “Add New Row to Sheet” in Google Sheets. It adds one row per new record and nothing more.

Watch out

Send edits to “Update Spreadsheet Row”, since “Record Created Or Updated” would add a second row.

Airtable and Google Sheets templates

Pick one and Captain builds it with you.

  • When record created or updated in Airtable, update spreadsheet row in Google Sheets

    Build this
  • When new records appear in Airtable, add new row to sheet in Google Sheets

    Build this
  • When record created or updated in Airtable, add new row to sheet in Google Sheets

    Build this

Airtable and Google Sheets triggers and actions

Every one of both apps. A trigger starts the work; actions are the steps.

Triggers

2
  • Record created or updatedRuns when record changes
  • New records appearRuns when new records appear

Actions

8
  • List all recordsList all records in a table
  • Delete recordRemove a record from a table
  • Update recordUpdate the fields of an existing record in the chosen base and table. If no matching record is found, create one when enabled.
  • List a record by record IDList a record by Record ID
  • Find or create recordFind a record or create it.

Questions about Airtable and Google Sheets

What can start a Airtable and Google Sheets automation?

“Record created or updated” and “New records appear”.

Which other apps work with both Airtable and Google Sheets?

Quora Lead Gen Forms, Justdial, SurveyMars, Webinargeek and Outscraper. Each one has templates with Airtable and with Google Sheets, so a third app can join the same job.

All Airtable integrations · All Google Sheets integrations · Every app, A to Z

Connect Airtable and Google Sheets

Or pick another template above. Free to start.

Build it with Captain
Airtable and Google SheetsBuild it