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

What each client fills in

Google Sheets: Spreadsheet ID

For example from the URL: docs.google.com/spreadsheets/d/<this>/edit

Google Sheets: Sheet (tab)

For example Sheet1

Airtable: Base ID

For example appXXXXXXXXXXXXXX

Airtable: Table

For example Leads

Airtable: Last modified time field

A field of type “Last modified time” in this table.

The accounts it needs

Each is the client’s own, stored encrypted and never copied between clients. Until one is added the client’s checklist shows it, and nothing runs.

• Airtable

  airtable.com/create/tokens → Create token → scopes data.records:write and data.records:read (lookups and the triggers) → add the client’s base → copy the token.

• Google Sheets

  In your own Google Cloud project: enable the Google Sheets API, then IAM & Admin → Service accounts → Create → Keys → Add key → JSON, and paste the file here. Then share each client sheet with the service account’s email (…@….iam.gserviceaccount.com) as an Editor. The account is yours; no Google review is needed.

After you install it

It lands switched off. The client’s checklist holds exactly this:

1. Connect the client’s Airtable, for “A record is changed”
2. Connect the client’s Google Sheets, for “Add a row”
3. Fill in Airtable: Base ID (For example appXXXXXXXXXXXXXX)
4. Fill in Airtable: Table (For example Leads)
5. Fill in Airtable: Last modified time field (A field of type “Last modified time” in this table)
6. Fill in Google Sheets: Spreadsheet ID (For example from the URL: docs.google.com/spreadsheets/d/<this>/edit)
7. Fill in Google Sheets: Sheet (tab) (For example Sheet1)
8. Check the order of Google Sheets’s values, column by column against the client’s columns