Importing lead lists should not take all day. This build turns a CSV upload in Airtable into clean lead records in minutes. It suits marketing and sales teams that collect contacts from events, partners, or vendors.

When a new upload appears in your Airtable upload table, the flow starts at the Airtable event trigger. It fetches the record, marks the status as Processing, downloads the attached CSV, and reads it with the header row. An If node checks if a Campaign value exists and formats it so each new lead links to that campaign. The system then creates all lead records in the target table using the Airtable API, and updates the upload status to Uploaded or Failed so the team can track outcomes.

Setup is simple. Add your Airtable Base ID, the Upload table ID, and the Lead table ID, then supply an Airtable Personal Access Token with the right scopes. Expect a fast turn from CSV to leads, less manual cleanup, and reliable status tracking for each import. This is a great fit for teams that need to load large lists often and want clear progress signals without spreadsheets and copy paste.

• Airtable event trigger starts the run when a new upload record appears.
• Dynamic Base and Table IDs stored in a single Set node for easy reuse.
• Status updates to Processing Uploaded and Failed via Airtable API calls.
• CSV file download from the upload record and parsing with header row support.
• Conditional mapping for Campaign so leads link to a campaign only when provided.
• Bulk record creation in the lead table using the Airtable REST API.
• Clear run visibility so you can confirm row counts and outcomes in n8n executions.

• Reduce manual imports from 2 hours to 5 minutes per list
• Eliminate up to 80% of copy paste errors by reading headers
• Handle 10 times more contacts per day without extra staff
• Connect Airtable Interface uploads to the lead table automatically
• Track each upload with clear Processing Uploaded Failed status

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. In your Airtable account, create a Personal Access Token with scopes data.record:read, data.record:write, and schema.bases:read. Copy the token and store it safely.
4. In n8n Cloud, go to Credentials > Create new > search for Airtable. Choose Personal Access Token, paste your token, give the credential a clear name, and save.
5. Open the Airtable Trigger node and select your Airtable credential. Choose the base and the upload table that stores the CSV attachment. Save the node.
6. Find your Airtable Base ID, Upload Table ID, and Lead Table ID. You can copy them from the Airtable URL or from the Airtable API docs for your base.
7. Open the Set node named Airtable Base IDs and paste your Base ID, Upload Table ID, and Lead Table ID into the fields provided. Save the node.
8. Double click each Airtable and HTTP Request node that calls the Airtable API and select your Airtable credential. If needed, click Create new credential in the dropdown and follow the on screen steps.
9. Open the Create Records node and map CSV column names from the Read File node to the fields in your lead table. Make sure text numbers and dates match the Airtable field types.
10. Confirm the Read File node uses headerRow set to true and the binary property name matches the download step. This ensures columns line up with Airtable fields.
11. Test the flow: In your Airtable Interface or grid, add a new upload record and attach a CSV. Watch n8n for a new execution. The upload record should move to Processing and then to Uploaded.
12. Troubleshoot common issues: 401 errors mean the token or scopes are wrong. 422 errors usually mean a field name or type does not match. If Campaign is empty, confirm the If node path handles that case. Check that the CSV header names match the lead table exactly.