Airtable batch update / insert rows (send faster + save API call requests)

by Simon Mayerhofer · 552 views · created 2025-04-01 · Engineering

What this workflow does

This workflow has 29 nodes and runs manually, when you click “Execute workflow” (plus 1 other trigger). Along the way it connects DebugHelper.

How it runs

Trigger: Manually, when you click “Execute workflow” (plus 1 other trigger).

1. random data (DebugHelper): uses DebugHelper
2. Split Out: splits a list into separate items
3. batch (Loop Over Items (Split in Batches)): loops over the items in batches
4. return merged output (Code): runs custom JavaScript code
5. Switch: routes items into 3 branches
6. Edit Fields (Edit Fields (Set)): sets 2 fields: records.fields, records.id
7. Edit Fields (Edit Fields (Set)): sets 1 field: records.fields
8. Edit Fields (Edit Fields (Set)): sets 1 field: records.fields
9. Aggregate: combines items into one
10. Aggregate: combines items into one

…plus 17 more steps. See the full node list below.

Services it uses

DebugHelper

Before you upgrade to n8n 3.0

Nodes used (14)

• HTTP Requestn8n-nodes-base.httpRequest
• DebugHelpern8n-nodes-base.debugHelper
• Manual Triggern8n-nodes-base.manualTrigger
• Split Outn8n-nodes-base.splitOut
• Loop Over Items (Split in Batches)n8n-nodes-base.splitInBatches
• Execute Workflow Triggern8n-nodes-base.executeWorkflowTrigger
• Switchn8n-nodes-base.switch
• Ifn8n-nodes-base.if
• Waitn8n-nodes-base.wait
• Mergen8n-nodes-base.merge
• Aggregaten8n-nodes-base.aggregate
• Edit Fields (Set)n8n-nodes-base.set
• Execute Sub-workflown8n-nodes-base.executeWorkflow
• Coden8n-nodes-base.code

From the author

This workflow allows you to batch update/insert Airtable rows in groups of 10, significantly reducing the number of API calls and increasing performance. 🚀 How It Works 1. Copy the 3 Nodes Copy the three nodes inside the red note box into your workflow. 2.…

View the original on n8n.io → Check your own copy