Hey community! I built a fully automated lead generation workflow and wanted to share it here.
What it does:
- Scrapes business listings from Google Maps via Apify
- Visits each website to extract email addresses
- Filters out leads with no email
- Saves to Airtable CRM with deduplication
- Sends personalized Gmail outreach automatically
- Marks leads as Emailed so they’re never contacted twice
The deduplication was the tricky part — I used an Airtable Checkbox field + a final If node to block already-contacted leads on every future run.
Here’s a screenshot of the workflow:
I packaged this up with a full setup guide (PDF with screenshots) for anyone who wants the ready-to-use version:
n8n Lead Generation & Deduplication Pipeline — Automated Outreach System
Happy to answer questions or help anyone adapt it for their use case!