Lead Generation
AI Enrichment
Social Discovery
Google Maps
n8n Workflow
Google Maps Lead Gen
with AI Enrichment
& Social Discovery
Type a search query like "bakery in Manila" — and this workflow does the rest. It scrapes Google Maps, finds emails, discovers social profiles across 6 platforms, validates contacts, scores every lead with AI, writes a personalized outreach message, and exports a clean sheet ready for your campaign.
Workflow Architecture
Inside the Automation
Start → Split Queries → Fetch Maps (13 pages) → Scrape Websites → Email Validation → Social Discovery (Serper) → AI Enrichment → Lead Scoring → Outreach Message → Google Sheets
8-Stage Pipeline
Stage 1
📍 Maps Scraping
Fetches Page 1 + Pages 2–12 of Google Maps results with rate limit protection and delay between requests.
Stage 2
🌐 Website Scraping
Visits each business website, extracts emails, social links, and contact data using HTTP scraping.
Stage 3
✉️ Email Validation
Checks if emails exist, validates deliverability, merges valid/invalid results, and cleans lead data.
Stage 4
🔍 Social Discovery
Builds social search queries, hits Serper API, parses & resolves profiles across 6 platforms.
Stage 5
📊 Lead Scoring
Calculates a 0–10 digital presence score per lead based on website, email, and social completeness.
Stage 6
🤖 AI Enrichment
AI analyzes each business and generates a summary, services list, and business profile using Ollama or any LLM.
Stage 7
✍️ Outreach Message
AI writes a personalized outreach message per lead — cleaned, formatted, and ready to copy-paste or automate.
Stage 8
📊 Google Sheets Export
All enriched leads saved to Google Sheets — clean, structured, and ready for outreach campaigns.
What You Get Per Lead
Every row in your Google Sheet contains
Complete Lead Profile — exported to Google Sheets
Business name & address
Phone number
Website URL
Validated email address
Google Maps rating & review count
Lead score (0–10)
AI business summary
AI-generated services list
Personalized outreach message
All social media profile links
Example Search Queries
Works for any niche, any city, any country
Local Services
"bakery in Manila"
"gyms in Cebu"
"dental clinic in QC"
Great for agencies targeting local service businesses for web design, SEO, or social media services.
B2B Outreach
"law firms in BGC"
"accounting firms Ohio"
"real estate agency Dubai"
Ideal for B2B sales teams prospecting professional services companies in any market.
eCommerce & Retail
"restaurants in Delhi"
"clothing store London"
"coffee shop Singapore"
Perfect for outreach agencies offering digital marketing, chatbot, or automation services to retail businesses.
Who Is This For?
Built for teams that sell to local businesses
Lead Generation Agencies
Run this workflow for any niche or city your clients target. Deliver hundreds of enriched, scored leads per run — complete with validated emails and personalized outreach messages ready to send.
Freelancers Offering Outreach as a Service
Turn this into a productized service. Charge clients per lead list — and deliver more value than any manual researcher could, in a fraction of the time.
B2B Sales & Marketing Teams
Stop wasting time on manual prospecting. Run a query, get a scored lead list, and focus your team's energy on the highest-scoring prospects — the ones most ready to buy.
Automation Consultants
Add this to your service stack. Offer lead generation automation as a standalone deliverable — or bundle it with outreach sequences and CRM integrations for premium clients.
How It Works
Step-by-step breakdown
1
You define your search queries
Enter one or more search queries — like "bakery in Manila" or "gyms in Delhi". The Split Search Queries node breaks them into individual jobs, and the workflow processes each one in parallel with rate limit protection so it doesn't get blocked.
Start Lead Generation → Split Search Queries → Process Each Query
2
Google Maps scraped across 13 pages
The workflow fetches Page 1 first, then loops through Pages 2–12 with a delay between requests to avoid rate limiting. Every business listing — name, address, phone, website, rating, and review count — is extracted and passed downstream.
Fetch Maps Results (Page 1) + Fetch Maps Results (Pages 2–12) + Rate Limit Protection
3
Business websites scraped for contact data
Each business website is visited and scraped using HTTP requests. The workflow extracts email addresses, social media links embedded in the site, and any additional contact information — building a richer profile than Maps alone can provide.
Extract Businesses from Maps → Process Businesses in Batches → Scrape Business Website
4
Emails validated and bad contacts removed
Every discovered email address is sent to an email validation API. The Check Email Exists node verifies deliverability — filtering out invalid, disposable, or risky addresses. Valid and invalid results are merged and cleaned, ensuring your final list only contains contactable leads.
Extract Socials & Email → Check Email Exists → Validate Email Address → Merge Lead Results → Clean Lead Data
5
Social profiles discovered across 6 platforms
For each business, the workflow builds a targeted social search query and sends it to the Serper API. Results are parsed, resolved, and normalized — discovering Instagram, Facebook, LinkedIn, Twitter/X, TikTok, and YouTube profiles automatically, even if they weren't on the website.
Build Social Search Query → Search Social Profiles (Serper) → Parse → Resolve & Score → Normalize Social Data
6
Lead score calculated based on digital presence
The Calculate Lead Score node assigns every lead a score from 0 to 10 based on how complete their digital presence is — website, email, social profiles, Google rating, and review count all factor in. Duplicate leads are removed before scoring to keep the list clean.
Combine Website + Serper Results → Calculate Lead Score → Remove Duplicate Leads
7
AI enriches every lead with business intelligence
Each lead is sent to an AI model (Ollama or any LLM endpoint) via the Analyze Business node. The AI generates a business summary describing what the company does, a services list, and categorizes the business by industry — adding rich context that makes your outreach far more targeted and relevant.
Process Leads for AI Enrichment → AI Rate Limit Buffer → Analyze Business (AI) → Extract AI Insights → AI Processing Buffer
8
AI writes a personalized outreach message per lead
Using the AI-generated business profile, the workflow creates a personalized outreach message for each lead — referencing their specific business, services, and digital presence gaps. The message is cleaned, formatted, and stored alongside the lead data. A Message Rate Limit Buffer ensures stable processing at scale.
Process Outreach Message → Clean Outreach Message → Message Rate Limit Buffer → Create Outreach Message
9
Everything exported to Google Sheets instantly
All enriched, scored, and messaged leads are saved to Google Sheets in a clean, structured format — one row per lead, with all columns populated. Your sheet fills up automatically while the workflow runs. Open it and your outreach-ready lead list is already waiting.
Save Leads to Google Sheets
How to Set Up
4 steps to your first lead list
1
Connect your credentials in n8n
Add your Serper API key for social discovery, your email validation API credentials, your Google Sheets OAuth connection, and your Ollama or LLM endpoint for AI enrichment — all managed securely in n8n's credentials store.
2
Add your Google Sheet ID to the Sheets node
Create a new Google Sheet, copy the Sheet ID from the URL, and paste it into the Save Leads to Google Sheets node. The workflow will create and populate columns automatically on first run.
docs.google.com/spreadsheets/d/[YOUR_SHEET_ID]/edit
3
Add your search queries
Enter your target search queries in the Start Lead Generation node. You can add multiple queries at once — the workflow processes them all in one run with built-in rate limit protection.
"bakery in Ohio"
"gyms in Delhi"
"dental clinic in Manila"
4
Hit run — leads start filling your sheet automatically
Execute the workflow and watch your Google Sheet populate in real time. Each lead arrives fully enriched — with validated email, social profiles, AI summary, lead score, and a personalized outreach message ready to use.
How It Will Improve Your Business Workflow
Real impact, measurable results
100s
Leads Per Run
Each query scrapes up to 13 pages of Google Maps results — delivering hundreds of leads per run with zero manual research.
6
Social Platforms Searched
Instagram, Facebook, LinkedIn, Twitter, TikTok, YouTube — discovered automatically for every lead via Serper API.
0
Manual Research Hours
From query to enriched, scored, outreach-ready lead list — fully automated. No copy-pasting, no manual lookups, no spreadsheet formatting.
Replace days of research with one workflow run
A skilled researcher might manually gather 20–30 leads per day — with basic contact info and no enrichment. This workflow generates hundreds of fully enriched leads in a single run, including emails, socials, AI summaries, scores, and personalized messages. What used to take a week now takes minutes.
Lead scores help you prioritize the right prospects
Not all leads are equal. The 0–10 digital presence score instantly separates high-value prospects (strong web presence, multiple socials, verified email) from weak ones. Your team focuses on the best leads first — maximizing conversion rates without wasting effort on poor fits.
Personalized outreach that actually converts
Generic cold emails get ignored. AI-generated outreach messages reference each business by name, mention their specific services, and speak to their digital gaps — making every message feel hand-written. Higher open rates, higher reply rates, more booked calls.
Reusable for any niche, city, or campaign
Change the search query and hit run. The same workflow works for restaurants in Singapore, law firms in New York, gyms in Manila, or any other combination. Build a lead generation machine that scales across markets without any additional setup.
Offer lead gen as a premium service
This workflow is the backbone of a productized lead generation service. Charge clients per lead list — ₱5,000 to ₱20,000+ per run depending on niche and volume — and deliver more value, faster, and more reliably than any manual freelancer can.
Requirements & Tech Stack
What you need to run this workflow
Serper API key (social discovery)
Google Sheets OAuth connection
Email validation API credentials
Ollama or any LLM API endpoint
n8n instance (cloud or self-hosted)
Google Maps (scraped via HTTP — no API key needed)
Available for projects
Want leads generated
on autopilot?
I'll set up and customize this lead generation pipeline for your niche and target market — delivering enriched, scored, outreach-ready leads directly to your Google Sheet. One setup, unlimited runs.