Back to Templates
This workflow scrapes Google Maps via Decodo API, analyzes each business using Google Gemini 2.5 Flash, scores lead quality, and generates ready to send outreach emails.
Why Use This Workflow?
-
Time Savings: Reduces manual lead research from 20 minutes per lead to 30 seconds processing 100 leads in under an hour
-
Cost Reduction: Eliminates $300-500/month spent on lead databases and enrichment tools like Apollo or ZoomInfo
-
Scalability: Process 500+ leads daily without additional staff or subscription costs
Ideal For
- Sales Teams & BDRs: Building targeted prospect lists for local businesses (restaurants, retail, service providers) with verified contact data and personalized outreach hooks
- Digital Marketing Agencies: Identifying high-value clients in specific niches (e.g., "restaurants without websites in Chicago") and automating first-touch campaigns
- B2B SaaS Companies: Finding businesses matching ideal customer profiles based on ratings, reviews, and digital maturity indicators
- Local Service Providers: Generating qualified leads for web design, SEO, POS systems, or booking software tailored to underserved markets
How It Works
- Trigger: Manually start the workflow or schedule it to run on specific intervals (e.g., daily/weekly)
- Data Collection: Scrapes Google Maps search results using Decodo API based on your query (e.g., "coffee shops in Austin"), country, and language settings
- Processing: Parses raw HTML responses into structured lead objects with business name, address, phone, website, ratings, reviews, and coordinates
- Intelligence Layer: Google Gemini 2.5 Flash analyzes each lead to generate value propositions, identify pain points, create outreach hooks, and assign a 1-10 quality score
- Output & Delivery: Filters leads scoring ≥7, generates personalized email templates, and saves all data to Google Sheets with enrichment timestamps
- Storage & Logging: Maintains complete lead database with outreach status tracking; error handler sends Telegram notifications for failed executions
Setup Guide
Prerequisites
| Requirement | Type | Purpose |
|---|---|---|
| n8n instance | Essential | Workflow execution platform |
| Decodo Scraper 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
-
Import the JSON file to your n8n instance
-
Configure credentials:
- Decodo API: Create HTTP Header Auth credential with header name
Authorizationand valueBasic [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-IDin "Send Error Notification" node
- Decodo API: Create HTTP Header Auth credential with header name
-
Update environment-specific values:
- In "Set Search Parameters" node: Update
searchQuery(e.g., "Italian restaurants in Miami"),country,targetLanguage, andresultsLimit - In both Google Sheets nodes: Select your destination spreadsheet and sheet name
- In "Set Search Parameters" node: Update
-
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
-
Test execution:
- Start with
resultsLimit: 5to verify all connections work - Check Google Sheets for properly formatted data
- Verify AI enrichment produces actionable insights
- Start with
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,targetLanguagein "Set Search Parameters" to target different markets (supports all Google Maps locales) - Lead Scoring Threshold: Change filter condition from
≥7to≥6for broader lead pool or≥8for 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
Credits & Links
Created by: Khaisa Studio
Category: Sales & CRM | Tags: lead-generation, google-maps, ai-enrichment, sales-automation, prospecting
Need custom workflows? Contact us
Connect with the creator: