Airtable Batch Update / Insert rows (send faster + save API call requests)

Description

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

Copy the 3 Nodes
Copy the three nodes inside the red note box into your workflow.

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.

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)