n8n

How to Automate Airtable LinkedIn Lead Capture?

Build targeted company lists from LinkedIn and store clean records in Airtable. It finds companies that match your search and keeps only the ones that meet your quality rules. Best for sales teams that need fresh B2B accounts without manual copy and paste.

Run it on demand, set your keywords, size, industry, and location, then the search call returns up to 1000 results. The flow splits the list, pulls full company details for each item, waits two seconds between calls to respect limits, and drops any company that lacks a website or has fewer than your set follower count. It checks Airtable by LinkedIn ID to avoid duplicates, then creates new records with name, LinkedIn URL, website, summary, description, category, tag, and country. Batch control loops through every company until all results are processed.

You need accounts for Ghost Genius and Airtable, an API key, and an Airtable base with the listed fields. Start with a small page limit to test, then raise it once the filters return the right volume. Use it for agency prospecting, regional lists, or size based targeting while saving hours and keeping data clean.

What are the key features?

  • Manual run with a test friendly page limit to preview volume
  • Search companies by keywords, size, industry, and location through an API
  • Split the search results and process one company at a time
  • Two second delay between requests to respect API rate limits
  • Pull full company details using the LinkedIn company URL
  • Filter out companies without a website or with low follower count
  • Check Airtable by LinkedIn ID to prevent duplicate records
  • Create Airtable records with mapped fields plus default tags and country
  • Loop control moves through all companies until the batch is complete

What are the benefits?

  • Reduce manual research from 4 hours to 30 minutes per 500 companies
  • Automate about 90% of copy and paste work for list building
  • Improve data quality by 25% with website and follower checks
  • Handle up to 1000 results per search and scale by running multiple filtered batches
  • Eliminate most duplicates by matching LinkedIn ID before creating records
  • Connect your data source and CRM so records stay consistent

How do you set it up?

  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 Ghost Genius and Airtable. See the Tools Required section above for links to create accounts with these services.
  3. In the n8n credentials manager, create an HTTP Header Auth credential for Ghost Genius. Set Name to Authorization and Value to Bearer YOUR_API_KEY. You can create the API key from your Ghost Genius account dashboard.
  4. Open the Search Companies and Get Company Info nodes and select the Ghost Genius credential you just created in the Credential to connect with dropdown.
  5. In Airtable, create a base named CRM with fields such as Name, Website, LinkedIn, id, Summary, Category, Tag, and Country. Ensure id is numeric.
  6. Create an Airtable Personal Access Token with read and write access to the CRM base. In n8n, create an Airtable credential using this token and assign it to the Airtable nodes.
  7. Open the Set Variables node and enter your search filters. Include keywords, company size, industry, and location IDs. If you need help with location IDs, check the links in the Tools Required section.
  8. In the Search Companies node, set a low Max Pages value first to test. Run the workflow manually and confirm the response shows the total result count and expected fields.
  9. Confirm that Extract Company Data outputs items with a url field. If not, adjust the mapping to ensure the LinkedIn URL is available for the detail call.
  10. Review the Filter Valid Companies node and set your follower threshold and website check. Keep the default of 200 followers to start, then tune as needed.
  11. Run a small batch and observe the two second delay between requests. Verify that Airtable Search finds existing records by LinkedIn ID and that only new companies are created.
  12. If you hit rate limits or timeouts, increase the batch interval in the Get Company Info options or reduce Max Pages. If Airtable search fails, check the filterByFormula and make sure id is saved as a number.

Tools Required

$24 / mo or $20 / mo billed annually to use n8n in the cloud. However, the local or self-hosted n8n Community Edition is free.

Airtable

Sign up

Free (1,000 API calls / mo)

Ghost Genius

Sign up

Free API: €0 / mo, 100 credits / mo

Credits:
Created by Matthieu Belin. Contact on LinkedIn.

Similar Templates

Join Futurise to access 1,200+ automation templates

Get instant access to ready-made automation workflows for n8n, Make.com, AI agents, and more. Download, customise, and deploy in minutes.