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
| When this happens in Airtable | This runs in Google Sheets | How fast | Starter |
|---|---|---|---|
| A record is added | Add a row | Within 15 minutes | Install the starter |
| A record is added | Update a row | Within 15 minutes | Two steps on the canvas |
| A record is changed | Add a row | Within 15 minutes | Install the starter |
| A record is changed | Update a row | Within 15 minutes | Two steps on the canvas |
From Google Sheets to Airtable
| When this happens in Google Sheets | This runs in Airtable | How fast | Starter |
|---|---|---|---|
| A row is added | Create a record | Within 15 minutes | Install the starter |
| A row is added | Find records | Within 15 minutes | Two steps on the canvas |
| A row is added | Update a record | Within 15 minutes | Two steps on the canvas |
| A row is changed | Create a record | Within 15 minutes | Install the starter |
| A row is changed | Find records | Within 15 minutes | Two steps on the canvas |
| A row is changed | Update a record | Within 15 minutes | Two steps on the canvas |
Set up the starter
Add a row in Google Sheets when a record is added in Airtable
- 1Install the starter into the client from Templates → Library. It lands switched off.
- 2Connect the client’s Airtable, for “A record is added”
- 3Connect the client’s Google Sheets, for “Add a row”
- 4Fill in Airtable: Base ID (For example
appXXXXXXXXXXXXXX) - 5Fill in Airtable: Table (For example Leads)
- 6Fill in Google Sheets: Spreadsheet ID (For example from the URL: docs.google.com/spreadsheets/d/<this>
/edit) - 7Fill in Google Sheets: Sheet (tab) (For example Sheet1)
- 8Check the order of Google Sheets’s values, column by column against the client’s columns
- 9Switch it on. Within 15 minutes: Airtable is checked every 15 minutes.

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
| Google Sheets value | Filled 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
| Google Sheets value | Filled 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
| Airtable value | Filled 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
| Airtable value | Filled 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.