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

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

Ready for 3.0

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

Ready 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)

DebugHelper

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)

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

Get the weekly “what broke” email

New templates, newly broken ones, and n8n release changes. One short email a week.

Form not loading? Subscribe here.