Record Created
Watch record-creation events in a selected Airtable base, with optional Table ID and change-source filters.
Workflow template
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
Watch record-creation events in a selected Airtable base, with optional Table ID and change-source filters.
Create the activity-log spreadsheet and its five column headers on the first run. Reuse that file for subsequent events in this workflow copy.
Append the record, base and table IDs, creation-event timestamp and Airtable link as a new row of plain text.
The result
Five columns are created automatically. The log identifies each new record without copying its cell values, attachments or private notes.
| Record ID | Base ID | Table ID | Created at (UTC) | Airtable link |
|---|---|---|---|---|
| recExampleRequest381 | appExampleBase381 | tblExampleRequests381 | 2026-09-20T09:00:00Z | https://airtable.com/appExampleBase381/tblExampleRequests381/recExampleRequest381 |
Illustrative data. Opening the record still requires Airtable access; review who can access the generated spreadsheet.
Before activation
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.
Choose the Google account that will own the activity log. There is no existing file to select and no header row to prepare.
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.
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.
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.
No. Only new record-creation events received after connection append rows. Existing records, edits and deletions are excluded.
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.
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.