Automate B2B Lead Generation using Google Places API & SendGrid with Dashboard

Description

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