Scrape & enrich Google Maps leads with Decodo API and Gemini 2.5 Flash

Turn Google Maps into a lead machine. This workflow scrapes listings with the Decodo API, scores each business with Google Gemini, and writes ready-to-send outreach emails. Research that took 20 minutes per lead now runs 100 leads in under an hour.

Last updated: September 2026.

Why Use This Workflow?

• Time Savings: Manual lead research drops from 20 minutes per lead to 30 seconds. 100 leads in under an hour.
• Cost Reduction: Skip $300-500/month lead databases and enrichment tools like Apollo or ZoomInfo.
• Scalability: Process 500+ leads daily without extra staff or subscriptions.

Ideal For

• Sales Teams & BDRs: Targeted prospect lists for local businesses (restaurants, retail, service providers) with verified contacts and outreach hooks.
• Digital Marketing Agencies: High-value clients in specific niches (e.g., "restaurants without websites in Chicago") with automated first-touch campaigns.
• B2B SaaS Companies: Businesses matching ideal customer profiles based on ratings, reviews, and digital maturity.
• Local Service Providers: Qualified leads for web design, SEO, POS systems, or booking software in underserved markets.

How It Works

1. Trigger: Start manually or schedule it (e.g., daily/weekly).
2. Data Collection: Scrapes Google Maps results with the Decodo API using your query (e.g., "coffee shops in Austin"), country, and language.
3. Processing: Parses raw HTML into structured leads: business name, address, phone, website, ratings, reviews, coordinates.
4. Intelligence Layer: Google Gemini analyzes each lead for value propositions, pain points, outreach hooks, and a 1-10 quality score.
5. Output & Delivery: Leads scoring 7+ get personalized email templates. Everything saves to Google Sheets with enrichment timestamps.
6. Storage & Logging: Complete lead database with outreach status tracking. Telegram alerts on failed runs.

Setup Guide

Prerequisites

Requirement	Type	Purpose
n8n instance	Essential	Workflow execution platform
Decodo Scrapper API	Essential	Google Maps data extraction (get key at dashboard.decodo.com)
Google Gemini API	Essential	AI-powered lead analysis and scoring
Google Sheets	Essential	Lead database and outreach tracking
Telegram Bot (optional)	Optional	Real-time error notifications

Installation Steps

1. Import the JSON file to your n8n instance

2. Configure credentials:

   • Decodo API: Create HTTP Header Auth credential with header name Authorization and value Basic [YOUR_API_KEY] get from Decodo dashboard
   • Google Gemini API: Add your Google AI API key in the "2.5 Flash" node credentials
   • Google Sheets OAuth2: Authenticate with your Google account (both "Save to Google Sheets" and "Save Outreach To Sheets" nodes)
   • Telegram (optional): Add bot token and replace YOUR-CHAT-ID in "Send Error Notification" node

3. Update environment-specific values:

   • In "Set Search Parameters" node: Update searchQuery (e.g., "Italian restaurants in Miami"), country, targetLanguage, and resultsLimit
   • In both Google Sheets nodes: Select your destination spreadsheet and sheet name

4. Customize settings:

   • Adjust lead score threshold in "Filter Hot Leads" (default: ≥7)
   • Modify AI prompt in "Lead Enrichment" node to match your value proposition
   • Customize outreach email template in "Prepare Outreach Message" node

5. Test execution:

   • Start with resultsLimit: 5 to verify all connections work
   • Check Google Sheets for properly formatted data
   • Verify AI enrichment produces actionable insights

Technical Details

Core Nodes

Node	Purpose	Key Configuration
Decodo Maps Scraper	Fetches Google Maps listings via API	Set target: google_maps, adjust page_to based on resultsLimit
Parse & Normalize Data	Extracts business data from HTML	Custom JavaScript handles multiple response formats
Lead Enrichment (AI Chain)	Analyzes leads with Gemini 2.5 Flash	Structured output parser ensures JSON compliance
Filter Hot Leads	Isolates high-quality prospects	Combines lead score ≥7 + contact info validation
Save to Google Sheets	Stores all enriched leads	Uses appendOrUpdate with id as matching column
Save Outreach To Sheets	Updates hot leads with messages	Marks leads as "HOT" category for prioritization

Customization Options

Basic Adjustments

• Search Parameters: Modify searchQuery, country, targetLanguage in "Set Search Parameters" to target different markets (supports all Google Maps locales)
• Lead Scoring Threshold: Change filter condition from ≥7 to ≥6 for broader lead pool or ≥8 for ultra-qualified prospects
• Batch Size: Adjust "Split Into Batches" to process 10-50 items per cycle (lower = more reliable, higher = faster execution)

Advanced Enhancements

• Email Automation: Connect "Prepare Outreach Message" to Gmail/SendGrid nodes for automatic campaign sends (medium complexity)
• CRM Integration: Add HubSpot/Salesforce nodes after enrichment to sync leads directly (requires CRM API credentials)
• Multi-Channel Outreach: Branch hot leads to LinkedIn automation tools or SMS providers (high complexity, needs additional services)
• Custom Scoring Models: Modify AI prompt to prioritize industry-specific signals (e.g., verified badges for healthcare, delivery options for restaurants)

Troubleshooting

Common Issues

Problem	Cause	Solution
"No valid leads extracted" error	Decodo response format changed or empty results	Check Decodo API response in "Parse & Normalize Data" execution logs; verify search query returns results in Google Maps manually
AI enrichment produces invalid JSON	Gemini output doesn't match schema	Review "Result Parser" schema; add retry logic or simplify AI prompt to reduce complexity
Google Sheets "matching column not found"	Spreadsheet missing "id" column header	Ensure Sheet1 has headers: id, businessName, category, address, phone, website, rating, reviewCount, valueProposition, painPoints, outreachHook, leadScore, engagementStrategy, googleMapsUrl, scrapedAt, enrichedAt, outreachMessage, status
Timeout on large batches	Processing 100+ leads exceeds execution limits	Reduce resultsLimit to 25-50; run workflow multiple times with different queries

Use Case Examples

Scenario 1: Digital Marketing Agency Prospecting

Challenge: Agency needs 200 qualified restaurant leads monthly for web design services, spending 40 hours on manual research

Solution: Configure workflow with query "restaurants in [city]" filtered by ratings ≥4.0 and missing professional websites (AI scoring detects this)

Result: Generated 312 leads in 8 hours across 3 cities; 89 scored ≥8 (hot prospects); closed 14 clients in first month at $2,500 average contract value

Scenario 2: SaaS Company Market Entry

Challenge: Booking software startup targeting salons/spas in new geographic market with zero existing contacts

Solution: Ran workflow with "beauty salons in Denver" + "day spas in Denver"; AI identified pain points like "manual appointment booking" and "no online presence"

Result: 156 leads enriched in 2 days; personalized outreach hooks increased demo booking rate from 2% (cold template) to 11%; secured 8 pilot customers in 3 weeks

Scenario 3: Local Service Provider Lead Generation

Challenge: POS system reseller needs to identify retail stores still using cash registers, wasting days driving to scout locations

Solution: Configured workflow for "retail stores in [neighborhood]" with AI analyzing reviews for mentions of "cash only" or payment friction

Result: Identified 47 high-probability prospects in 90 minutes; field sales team prioritized top 15 leads (score ≥9), closed 6 deals worth $32K total revenue

---

Quick Answers

How do I start small?
Set resultsLimit: 5 first to verify connections, Sheets formatting, and AI output quality.
What counts as a hot lead?
Score ≥7 plus validated contact info. Adjust the threshold in "Filter Hot Leads".
Where does everything land?
Google Sheets: all enriched leads in one tab, hot leads with messages in another.

Credits & Links

Made by: khmuhtadin

Category: Sales & CRM | Tags: lead-generation, google-maps, ai-enrichment, sales-automation, prospecting

Need custom workflows? Contact me

Connect with the creator:

Portfolio • Workflows • LinkedIn • Medium • Threads

Additional info

Built with n8n. Need an assessment on your business? Feel free to reach out at https://khmuhtadin.com/consultation/