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

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)