Sync Recent Airtable Records to Google Sheets

How it works

1. 1.Execution starts from the Manual Trigger node.
2. 2.The Airtable node searches for records updated in the last day using filterByFormula.
3. 3.Results flow directly to the Google Sheets node.
4. 4.The Upsert operation inserts or updates rows in range A1:E1000 matching on the Email column.

Use cases

• Daily sync of recently updated customers or records between Airtable and Google Sheets.
• Keeping an automatically refreshed spreadsheet copy for review or sharing.

Requirements

• Airtable and Google Sheets credentials configured in n8n with read and write access.
• Replace YOUR_AIRTABLE_BASE_ID and YOUR_GOOGLE_SHEET_ID with real values; the source must have LastUpdated and Email fields.
• The target sheet must contain an Email column to match the compareColumn option.

Setup and testing in n8n

1. Run the workflow manually and verify the Airtable node returns only recently updated records.
2. Open the Google Sheet and confirm rows are inserted or updated based on matching email addresses.

Service Value

Ideal as a smart automation service combining integrations and AI to produce ready-to-use results.