Back to Templates
This n8n workflow automates the entire lead generation pipeline from discovery to outreach:
1. Location Grid Generation and Management
- Generates precise lat/lng grid points covering major US cities (New York, Texas, New Jersey, Atlanta, Miami)
- Uses 1.5km radius searches for optimal coverage
- Tracks searched locations to prevent duplicates
- Processes 50 points per day (customizable based on API quota)
2. Automated Lead Discovery
- Daily scheduled searches using Google Places Nearby API
- Extracts business details: name, address, rating, status, place ID
- Fetches additional data via Google Places Details API (phone, website, hours)
- Smart filtering to focus only on businesses with websites
3. Contact Information Extraction
- Scrapes business websites to find email addresses
- Advanced email filtering removes fake/placeholder emails
- Deduplicates by domain to ensure quality leads
- Tracks all discovered emails per business
4. Intelligent Cold Email Outreach
- Two alternating email templates for variety and testing
- Personalized with business name, industry, and first name
- Rate-limited sending (30-second delays) to avoid spam flags
- Automated via SendGrid integration
- Marks sent emails in the database
5. Real-Time Lead Dashboard
- Webhook-powered reporting endpoint
- Displays all discovered leads with full details
- Filters out fake/invalid emails automatically
- Clean, accessible data format for analysis
What You Get:
- Automated daily lead collection from Google Places
- Email extraction from business websites
- Personalized cold email campaigns with A/B testing
- Lead tracking database in Google Sheets
- Real-time reporting dashboard via webhook
- Complete deduplication to maintain data quality
Setup Requirements:
- Google Cloud Platform account (for Places API key)
- SendGrid account (for email sending)
- Google Sheets (2 templates provided)
- Basic n8n knowledge for configuration
Included Templates:
- Location Grid Google Sheet - Tracks searched coordinates
- Leads Database Google Sheet - Stores all discovered leads
- Dashboard Webpage - Real-time lead reporting interface
Customizable Features:
- Target locations (currently covers 5 major US cities)
- Daily batch size (default: 50 searches/day)
- Email templates and personalization
- Search radius (default: 1.5km)
- Industry filters and targeting
Perfect For:
- Marketing agencies building client lead lists
- B2B sales teams prospecting locally
- Service providers finding new customers
- Anyone needing automated local business outreach
Need help setting this up or want custom modifications?
📧 Connect with me on LinkedIn: Gilbert Onyebuchi
🌐 View live dashboard demo: Click here