Move large sets of records into Airtable without manual uploads. Ideal for teams that load data in bulk and need clean updates with no duplicates.

The flow accepts base ID, table ID, mode, merge fields, and a records array. It splits records into batches of 10 and routes by mode to insert, update, or upsert using Airtable API calls. Upserts use chosen fields to match and update or create new rows. Built in checks look for rate limits, pause for 0.2 seconds between calls, and retry with a 5 second wait when needed. Results from all batches are combined and returned so you can see what succeeded.

Setup is simple. Add an Airtable API token, copy the base and table IDs from the Airtable URL, pick the mode, and make sure field names match your table. Expect faster loads, fewer mistakes, and smoother scaling to thousands of rows. Useful for nightly data loads, product updates, event signups, or any regular sync into Airtable.

• Three modes supported: upsert, insert, and update routed by a Switch node.
• Batch processing of 10 records at a time to control API load.
• Upsert uses fieldsToMergeOn so updates match the right rows or create new ones.
• HTTP Request nodes call the Airtable REST API with POST and PATCH methods.
• Rate limit guard adds a 0.2 second delay and retries with a 5 second wait on errors.
• Retry branches and Merge nodes requeue failed requests for another attempt.
• Aggregate nodes rebuild record arrays and collect API responses per batch.
• Manual test path with Set Fields and Random Data for safe dry runs.
• Final merged output returns a single, combined result for all batches.

• Reduce manual CSV imports from hours to minutes
• Prevent duplicate records by merging on chosen fields
• Avoid Airtable 429 errors with smart waits and retries
• Scale to thousands of rows with batch size 10
• Unify data loading across teams through one reusable subprocess

1. Import the template into n8n: Create a new workflow in n8n > Click the three dots menu > Select 'Import from File' > Choose the downloaded JSON file.
2. You'll need accounts with Airtable. See the Tools Required section above for links to create accounts with these services.
3. Create an Airtable API token: In your Airtable account, open the API or Developer Hub, create a personal access token with read and write access to the target base, and copy the token.
4. In n8n, open Credentials > New > search for Airtable Token API. Name it clearly, paste the token, save, and test the connection.
5. Find your baseId and tableIdOrName in Airtable: open the base and table in your browser and copy the app... and tbl... parts from the URL.
6. Open the node called Airtable Subprocess inputs and set baseId, tableIdOrName, mode, fieldsToMergeOn, and records if you plan to call this as a subprocess.
7. For quick testing, use the Set Fields node to add sample rows. Make sure field names exactly match your Airtable column names.
8. Check the Split In Batches node and confirm the batch size is set to 10. Adjust only if your plan limits and data volume require changes.
9. Open the HTTP Request nodes for insert, update, and upsert. Confirm they use your Airtable credentials and the correct base and table expressions.
10. Run a test with the Manual Trigger. Watch the execution to see batches, API responses, and the final merged output.
11. If you get a 422 or field error, verify column names and data types. If you see 429 rate limits, keep the 0.2 second wait and 5 second retry as configured or reduce the batch size.
12. Once validated, call this subprocess from other n8n workflows to reuse the same safe batch load into Airtable.