Log Every Google Sheets Row to Airtable Automatically
This n8n workflow watches Google Sheets for a new row and automatically create a new record in Airtable. Set it once and it runs 24/7.
- 1
Add the Google Sheets Trigger node
Start with a
Google Sheets Triggernode — connect your Google account, choose theSpreadsheetandSheet, and setTrigger OntoRow Added. This fires the workflow the moment a new row arrives. - 2
Map the fields with a Set node
Add a
Setnode after the trigger to shape the data cleanly. Create fields: each column you care about, e.g.nameto{{ $json.Name }}andemailto{{ $json.Email }}— the column headers become the field keys. This turns the raw payload into tidy values your destination can use. - 3
Send it to Airtable
Add an
Airtablenode set to operationCreate. Connect your Airtable token, pick theBaseandTable, and map the fields from the Set node to your Airtable columns. Field names must match your table exactly. - 4
Activate and test
Click
Activatein the top-right of the canvas. Trigger a test row in Google Sheets, then confirm it appears in Airtable. Once it works, you're done — every new row now flows through automatically.
Frequently asked questions
Do I need any coding skills to set this up?
No. n8n is a visual, drag-and-drop tool. You connect your Google Sheets and Airtable accounts, point the nodes at the right form/sheet/channel, map the fields, and activate. No code required.
Can I filter which rows get sent to Airtable?
Yes. Add an `IF` node between the Set node and the Airtable node with a condition (for example, only send when an amount is above a threshold or a field equals a value). Wire the TRUE branch to Airtable and leave FALSE empty to skip the rest.
Can I send each row to more than one place at once?
Absolutely. Branch the workflow after the Set node: connect it to multiple destination nodes so the same row lands in Airtable and, say, Slack or a spreadsheet simultaneously.
Stripe to Google Sheets: Auto-Sync Every Payment with n8n (No Code)
Every time a new Stripe payment comes in, n8n instantly captures the details and append it as a new row to a spreadsheet — no manual exports, no missed data, no code.
n8nStripeGoogle Sheets
Stripe to Notion: Auto-Sync Every Payment with n8n (No Code)
Every time a new Stripe payment comes in, n8n instantly captures the details and add it as a new page in a Notion database — no manual exports, no missed data, no code.
n8nStripeNotion
Shopify to Airtable: Auto-Sync Every Order with n8n (No Code)
Connect Shopify and Airtable in n8n: each new order is captured and sent straight to Airtable, in real time and completely hands-off.
n8nShopifyAirtableKeep every recipe free
FlowRecipesHub is free and always will be. If a workflow saved you time, chip in what you like — it helps us keep the lights on and build the next batch of automations for everyone.
One-tap support is being set up — check back soon. 💚
Secure checkout via Paddle · one-time, no account needed