Automate B2B lead generation using Google Places API & SendGrid with dashboard

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:

1. Automated daily lead collection from Google Places
2. Email extraction from business websites
3. Personalized cold email campaigns with A/B testing
4. Lead tracking database in Google Sheets
5. Real-time reporting dashboard via webhook
6. 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