Airtable batch update / insert rows (send faster + save API call requests)
Ready for 3.0Ready for 3.0. This template uses no nodes that n8n 3.0 removes. No removed nodes, versions or helpers found. Static check, last run 2026-10-19.
Nodes used (14)
- HTTP Request
n8n-nodes-base.httpRequest - DebugHelper
n8n-nodes-base.debugHelper - Manual Trigger
n8n-nodes-base.manualTrigger - Split Out
n8n-nodes-base.splitOut - Loop Over Items (Split in Batches)
n8n-nodes-base.splitInBatches - Execute Workflow Trigger
n8n-nodes-base.executeWorkflowTrigger - Switch
n8n-nodes-base.switch - If
n8n-nodes-base.if - Wait
n8n-nodes-base.wait - Merge
n8n-nodes-base.merge - Aggregate
n8n-nodes-base.aggregate - Edit Fields (Set)
n8n-nodes-base.set - Execute Sub-workflow
n8n-nodes-base.executeWorkflow - Code
n8n-nodes-base.code
What it does
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. Set Your Fields In the Set Fields node, define the fields you want to update. ➤ Only include fields that match column names in your Airtable table. ➤ Make sure the field names are spelled exactly as they appear in Airtable. ➤ Make sure the field type are correctly set. So numbers columns in Airtable need numbers type set as the field. 3. Configure the Airtable Batch Node - Enter your Airtable Base ID The part with app... in the URL: airtable\.com / app8pqOLeka1Cglwg / tblnXZOdy8VtkAAJD/... - Enter your Airtable Table ID The part with tbl... in the URL: airtable\.com / app8pqOLeka1Cglwg / tblXXZOdy8VtkAAJD /... - Set Matching Fields (fieldsToMergeOn) Provide a string array that tells Airtable how to match existing rows. Examples: - Match by one field (e.g. TaskID): {{"TaskID"}} - Match by multiple fields (e.g. firstname and lastname): {{"firstname", "lastname"}} - Choose the Mode (mode field) Available options: - upsert: Update if a record exists, otherwise insert a new one - insert: Always insert as new records - update: Only update existing records (you must provide a field named id)