Building lead lists by hand took days. I built an n8n workflow that finds businesses by niche and location, pulls their emails from their websites and stores clean, validated leads in Airtable.
Client
Sales teams and agencies
What I did
n8n automation build
Stack
n8n, Google Places API, Web scraping, Airtable
The problem
Targeted lead lists were built by hand: searching for businesses, visiting each website for contact details and copying everything into a spreadsheet. It took days for every new list.
What I built
Google Places API search by niche and location
Automatic website scraping to find email addresses
Data validation, cleanup and deduplication
Airtable storage for organised lead management
Scheduled or on demand runs with error handling
The n8n workflow from Google Places search to Airtable
A successful run: 52 businesses found, 40 validated leads saved
Clean, validated leads stored in Airtable
What changed
40+ real leads with validated contact data in about 60 seconds