Skip to content
AirtableGoogle Sheets

Connect Airtable and Google Sheets

Start a client’s workflow in Airtable and act in Google Sheets, or the other way round, on the client’s own accounts.

Each app by itself: Airtable integration and Google Sheets integration, with how to connect it, its scopes and its limits.

What the pair is used for

  • A Google Sheet the office fills in by hand can feed an Airtable base. Each new row becomes a record with the sheet’s first four columns.
  • A changed row, matched by the ID in column A, adds another record the same way, which keeps a history of edits in Airtable.
  • In reverse, each new Airtable record can add a row to a sheet, for a client who reports from Sheets.

Every way Airtable and Google Sheets join

A workflow starts from a trigger in one app and runs a step in the other, on the client’s accounts. Where the library has a starter for it, it installs that pairing into a client switched off; any other pairing is two steps on the canvas.

From Airtable to Google Sheets

Triggers in Airtable with steps in Google Sheets
When this happens in AirtableThis runs in Google SheetsHow fastStarter
A record is addedAdd a rowWithin 15 minutesInstall the starter
A record is addedUpdate a rowWithin 15 minutesTwo steps on the canvas
A record is changedAdd a rowWithin 15 minutesInstall the starter
A record is changedUpdate a rowWithin 15 minutesTwo steps on the canvas

From Google Sheets to Airtable

Triggers in Google Sheets with steps in Airtable
When this happens in Google SheetsThis runs in AirtableHow fastStarter
A row is addedCreate a recordWithin 15 minutesInstall the starter
A row is addedFind recordsWithin 15 minutesTwo steps on the canvas
A row is addedUpdate a recordWithin 15 minutesTwo steps on the canvas
A row is changedCreate a recordWithin 15 minutesInstall the starter
A row is changedFind recordsWithin 15 minutesTwo steps on the canvas
A row is changedUpdate a recordWithin 15 minutesTwo steps on the canvas

Set up the starter

Add a row in Google Sheets when a record is added in Airtable

  1. 1Install the starter into the client from Templates → Library. It lands switched off.
  2. 2Connect the client’s Airtable, for “A record is added”
  3. 3Connect the client’s Google Sheets, for “Add a row”
  4. 4Fill in Airtable: Base ID (For example appXXXXXXXXXXXXXX)
  5. 5Fill in Airtable: Table (For example Leads)
  6. 6Fill in Google Sheets: Spreadsheet ID (For example from the URL: docs.google.com/spreadsheets/d/<this>/edit)
  7. 7Fill in Google Sheets: Sheet (tab) (For example Sheet1)
  8. 8Check the order of Google Sheets’s values, column by column against the client’s columns
  9. 9Switch it on. Within 15 minutes: Airtable is checked every 15 minutes.
The installed workflow on the canvas: Airtable’s “A record is added” trigger leading to Google Sheets’s “Add a row” step.

What it produces

The Google Sheets step as it runs for an example client, Lakeview Consulting, when Emma Collins asks for a consultation: each value the starter fills in.

Sheet
Lakeview leads
Spreadsheet ID
Lakeview leads
Values
2026-10-21T09:05:00Z

Setup notes for this pair

  • The Airtable-to-Sheets starters write the record’s creation time and nothing else. Add the record’s fields to the row’s values, which Sheets fills left to right.
  • The Sheets-to-Airtable starters write to fields called Column A to Column D. Create those columns in the table or rename the keys to the table’s own column names.
  • The record-changed starter needs a “Last modified time” field in the table, named in “Airtable: Last modified time field”.

Field mapping, starter by starter

Each value a starter’s step is given, and where it comes from. Words in brackets are filled in when it runs; change any of it after installing.

Add a row for new records

Add a row in Google Sheets when a record is added in Airtable

The values Add a row in Google Sheets when a record is added in Airtable sends
Google Sheets valueFilled from
Sheet[Google Sheets: Sheet (tab)]
Spreadsheet ID[Google Sheets: Spreadsheet ID]
Values[the created time, from Airtable]

Add a row for changed records

Add a row in Google Sheets when a record is changed in Airtable

The values Add a row in Google Sheets when a record is changed in Airtable sends
Google Sheets valueFilled from
Sheet[Google Sheets: Sheet (tab)]
Spreadsheet ID[Google Sheets: Spreadsheet ID]
Values[the created time, from Airtable]

Create a record for new rows

Create a record in Airtable when a row is added in Google Sheets

The values Create a record in Airtable when a row is added in Google Sheets sends
Airtable valueFilled from
Base ID[Airtable: Base ID]
Fields{"Column A":"[the 0, from Google Sheets]","Column B":"[the 1, from Google Sheets]","Column C":"[the 2, from Google Sheets]","Column D":"[the 3, from Google Sheets]"}
Table[Airtable: Table]

Create a record for changed rows

Create a record in Airtable when a row is changed in Google Sheets

The values Create a record in Airtable when a row is changed in Google Sheets sends
Airtable valueFilled from
Base ID[Airtable: Base ID]
Fields{"Column A":"[the 0, from Google Sheets]","Column B":"[the 1, from Google Sheets]","Column C":"[the 2, from Google Sheets]","Column D":"[the 3, from Google Sheets]"}
Table[Airtable: Table]

Airtable and Google Sheets and their logos are trademarks of their owners, used here only to say what Thrum works with; no endorsement is implied.

Thrum is cooking.

Get early access and you’ll be among the first in. Early members get a launch perk.