Airtable logo
Google Sheets logo

Workflow template

Log new Airtable records in Google Sheets

Keep a Google Sheets log of newly created Airtable records. The first event creates a spreadsheet with five headers; later events add rows to the same file.

How it works

From a new Airtable record to an activity-log row

1 Trigger · 2 Actions
Airtable1 · Trigger

Record Created

Watch record-creation events in a selected Airtable base, with optional Table ID and change-source filters.

Google Sheets2 · Action

Create the Airtable activity log once

Create the activity-log spreadsheet and its five column headers on the first run. Reuse that file for subsequent events in this workflow copy.

Google Sheets3 · Action

Log the new Airtable record

Append the record, base and table IDs, creation-event timestamp and Airtable link as a new row of plain text.

The result

An ongoing register of new record references

Five columns are created automatically. The log identifies each new record without copying its cell values, attachments or private notes.

Fictional record data showing the five columns created by this workflow.
Record IDBase IDTable IDCreated at (UTC)Airtable link
recExampleRequest381appExampleBase381tblExampleRequests3812026-09-20T09:00:00Zhttps://airtable.com/appExampleBase381/tblExampleRequests381/recExampleRequest381

Illustrative data. Opening the record still requires Airtable access; review who can access the generated spreadsheet.

Before activation

Set up your workflow

  1. Choose the base and tables

    Connect Airtable and select a base where you have Creator access. Enter a Table ID to limit the source, or leave Table IDs empty to watch every table in the selected base.

  2. Connect Google Sheets

    Choose the Google account that will own the activity log. There is no existing file to select and no header row to prepare.

  3. Activate and create a record

    Wait for the Airtable trigger to show Instant before adding a new test record. Open the generated spreadsheet, then create a second record to check that the next row uses the same file.

Details and limitations
  • New records only. Existing records, later edits and deletions are not imported. Selected change-source filters also apply. This is a one-way creation log, not a two-way synchronization of Airtable and Sheets.

  • References rather than cell contents. Each row contains only the five prepared metadata fields. Spreadsheet readers need their own Airtable access to open the record. Values use RAW input, so text is not evaluated as a formula.

  • One file per workflow copy. Testing the creation step also creates the spreadsheet. Changing creation settings after its first run requires a new creation step, and a deleted file is not silently replaced. Manual reruns can append duplicate rows.

Questions about this template

Do I need to create the spreadsheet or headers myself?

No. The first event creates a spreadsheet with Record ID, Base ID, Table ID, Created at (UTC) and Airtable link columns. Later events reuse it in the same workflow copy.

Will edits to an Airtable record update its spreadsheet row?

No. Only new record-creation events received after connection append rows. Existing records, edits and deletions are excluded.

Can I log records from just one table?

Yes. Enter its Table ID in the Airtable trigger. Leaving Table IDs empty watches every table in the selected base, subject to the selected change-source filters.

What happens if I delete the generated spreadsheet?

The workflow does not silently replace it. Review the failing step and configure a new creation step if you want a new file. The original step’s creation settings are not reapplied after its first successful creation.