This n8n workflow automates the entire lead generation pipeline from discovery to outreach:
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. An n8n automation workflow template by Gilbert Onyebuchi.
Gilbert Onyebuchi
web
paid
Others in the same category, ranked by how often they are opened.
