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