Collect fresh contacts from web pages and save them into Airtable in one run. It helps marketing and sales teams build a clean lead list fast and keep all prospect data in one place. Start it whenever you want new prospects added to your database.

Here is how it works. You click Test in n8n to begin. A HTTP Request node calls your lead scraping API with options to get personal and work emails and up to 500 records from a chosen URL. An If step removes entries that do not have an email so you do not store useless rows. A Set step standardizes fields like first_name and last_name so the schema stays clean. The Airtable node then creates new rows in your Leads table with the mapped fields.

To set it up, connect Airtable with a personal access token and point the HTTP Request node to your scraping endpoint. Map the fields you care about and test with a small batch before running 500 records. Expect faster research, fewer copy and paste mistakes, and one source of truth for outreach. This is useful for teams pulling contacts from directories, event lists, or company pages where emails are available.

• Manual trigger to run controlled lead capture on demand
• HTTP Request step calls your scraping API with options for personal and work emails and a 500 record limit
• If filter keeps only records that contain an email address
• Set step maps and standardizes fields like first_name, last_name, city, and country
• Airtable integration creates new rows in your Leads table with clean field mappings
• Simple field hygiene to keep a tidy and reliable lead database

• Reduce manual copy and paste from 3 hours to 10 minutes per list
• Automate about 90 percent of lead data entry into Airtable
• Improve data quality by filtering out 100 percent of records without emails
• Handle up to 500 contacts per run without extra effort
• Connect your scraping API directly to Airtable for a single source of truth

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 Airtable, create or open a base and add a table named Leads. Add fields you plan to store, such as first_name, last_name, email, city, country, headline, and any other fields you need.
4. In the n8n credentials manager, create a new Airtable credential using a Personal Access Token. Name the credential clearly, then paste your token from the Airtable API page. Save it.
5. Open the Airtable node in the workflow, choose your new credential, then select your base and the Leads table. Confirm the operation is set to Create.
6. Open the HTTP Request node. Paste your scraping API endpoint into the URL field. In the JSON body, set totalRecords to a safe test value like 10, set getPersonalEmails and getWorkEmails to true, and add the source page URL in the url field.
7. Check the If node and confirm it filters for a non empty email field. Adjust the field name if your API uses a different key for email.
8. Open the Set node and map fields from the incoming data to the names used in Airtable. Remove or add fields to match your table exactly.
9. Click Execute on the manual trigger to run a test. Review the execution data in n8n to confirm emails are present and fields look correct.
10. Open Airtable and confirm new rows appear with correct values. Fix any mismatched field names before increasing the batch size.
11. Increase totalRecords in the HTTP Request body up to 500 once the test looks good. Run again and verify results.
12. If no records appear in Airtable, check the HTTP Request response for errors, confirm your Airtable token permissions, and make sure the Airtable field names match your mappings exactly.