Templates / Automate Apollo lead scraping & email enrichment to Airtable CRM with Apify

Automate Apollo lead scraping & email enrichment to Airtable CRM with Apify

Ready for 3.0

by Daniel Nkencho ✓ · 906 views · created 2025-09-28 · Lead Generation

Ready for 3.0. This template uses no nodes that n8n 3.0 removes. No removed nodes, versions or helpers found. Static check, last run 2026-10-19.

What this workflow does

This workflow has 11 nodes and runs manually, when you click “Execute workflow”. Along the way it connects Airtable.

How it runs

Trigger: Manually, when you click “Execute workflow”.

  1. Get URL (Airtable): search
  2. Apollo Scraper (HTTP Request): calls an HTTP API (POST)
  3. Edit Fields (Edit Fields (Set)): sets 12 fields: first_name, last_name, name…
  4. Remove Duplicates: removes duplicate items
  5. Filter: keeps only the items that match a condition
  6. If: checks a condition and branches into true / false
  7. Email Present (Airtable): create
  8. If: checks a condition and branches into true / false
  9. Personal email present (Airtable): create
  10. Email Absent (Airtable): create

Services it uses

Airtable

Before you upgrade to n8n 3.0

Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.

Nodes used (7)

From the author

Apollo Lead Scraper to Airtable CRM Automate your lead generation by scraping targeted prospects from Apollo.io, enriching with contact details, and seamlessly syncing to Airtable for organized outreach—all without manual data entry. What It Does This…

Excerpt from Daniel Nkencho's description on n8n.io.

View the original on n8n.io → Check your own copy

Get the weekly “what broke” email

New templates, newly broken ones, and n8n release changes. One short email a week.

Form not loading? Subscribe here.