Batching Airtable Upserts?

Hi @Adam_Shand, most n8n nodes would run once for every item they receive and this is also true for the Airtable node.

In order to create batches you’d have to use the HTTP Request node instead. This requires first splitting your existing items into suitable batches (this can be done using the Loop Over Items node), then building a custom payload for all items in the current batch (using for example the Code node) before makign the actual HTTP Request for each batch.

If you need a performant solution, perhaps you want to consider using something like Supabase instead of Airtable? This would be considerably faster than Airtable even without implementing batches and custom HTTP requests. I’ve recently tested this here.