Infinite AI Leads Agent (Google Maps → CSV Automation) n8n

Powered by Google Maps scraping, AI reasoning, and Google Drive CSV export, this automation eliminates the need for expensive tools like Apollo, Clay, or DataAxle and builds a fresh lead list every time you ask for one.

This isn’t just a scraper. It is a full AI lead-generation assistant with:

Google Maps data extraction

AI-powered lead scoring

AI-written templated outreach email

Automatic CSV creation + cloud storage

Fully autonomous pipeline

All built into one powerful Make/n8n agent.

⭐ WHAT THIS AUTOMATION DOES (FULL BREAKDOWN)

1. AI Agent With 20+ Years Lead Gen Expertise The workflow begins with an AI Agent node programmed with an advanced system prompt:

Acts as a lead-generation specialist

Understands how to interpret Google Maps data

Applies strict lead-scoring logic

Writes personalized outreach emails

Automatically triggers CSV creation after every search

This ensures business-quality, high-value outputs every time.

2. Chat Trigger – User Sends a Search Query The automation activates whenever a user sends a chat message, such as:

“Find 20 cafés in Dubai” “Show me dentists in Toronto” “Give me 5 gyms in Sydney”

This message is fed directly into the AI Agent for processing.

3. Google Maps Search via MCP Tool The AI agent converts the user message into a structured JSON request for Google Maps:

locationQuery

searchStringsArray

maxCrawledPlacesPerSearch

skipClosedPlaces: true

The Maps tool returns detailed business data including:

Place ID

Business name

Category

Price

Full address

Website

Phone number

Google reviews + rating breakdown

Image count

Profile status

Social media links

This gives you real local business leads, not outdated databases.

4. AI Lead Enrichment: Scoring + Reasoning + Outreach Email After extracting data, the AI agent enriches each lead by applying a strict scoring algorithm based on the workflow rules:

Lead score factors include:

✔ Website quality Companies without websites = high sales potential

✔ Review reputation 1–2 star reviews = urgent service opportunity

✔ Image count Few photos = need for branding / photography services

✔ Social presence Missing IG/FB/TikTok = opportunity for social media services

✔ Google Business Profile status Unclaimed profiles = high-value lead

For every lead, the system generates:

Lead score (1–10)

Reasoning explaining weaknesses, opportunities, and recommended services

Personalized outreach email (under 500 characters)

Introduces your name & agency

Avoids commas (per instructions)

Pitch tailored to lead weaknesses

This instantly prepares you for outreach without needing a VA or SDR.

5. Automatic CSV Creation & Upload to Google Drive Every time a Maps search is completed, the workflow must generate a CSV file and store it inside your Google Drive. This is a non-negotiable rule enforced in the system itself.

CSV columns include:

placeId

title

price

category

address (converted to CSV-safe format)

website

phone

claimThisBusiness

totalScore

reviewsCount 11–15. 1→5-star distribution

imagesCount

maps URL 18–24. social links

leadScore

leadScoreReasoning

draftEmail

Missing values are replaced with “NA” to avoid broken spreadsheets.

This creates a clean, ready-to-use lead file every time.

6. Google Drive File Creation The completed CSV is saved automatically into your selected Google Drive folder.

Filename example:

2025-01-12__restaurants_in_dubai.csv

Everything is stored safely in the cloud without requiring manual exports.

🎯 WHAT THIS SYSTEM GIVES YOU From a single request, you instantly get: ✔ A full Google Maps lead list ✔ Contact details + website ✔ Review & rating analysis ✔ Social media presence audit ✔ Lead score (1–10) ✔ Personalized outreach email for each lead ✔ CSV exported and saved to Google Drive

This is an infinite lead-generation engine that scales with your niche, location, and service type.

🚀 PERFECT FOR:

Lead generation agencies

Marketing agencies

Local business outreach

SMMA / SEO / Web design agencies

SaaS founders

Real estate prospecting

B2B cold email teams

If your business relies on outbound prospecting, this automation becomes your most valuable asset.

🔥 WHY THIS TEMPLATE IS EXTREMELY POWERFUL 1. Zero manual prospecting AI handles the search, scoring, and outreach.

2. Unlimited niches, unlimited cities Restaurants today. Law firms tomorrow. Gyms next week.

3. CSV stored automatically Perfect for Instantly, Clay, Smartlead, GoHighLevel, HubSpot, or Apollo import.

4. AI outreach personalization Every email is tailored to the business’s weaknesses.

5. Scales your agency instantly Close more clients with faster, more accurate lead targeting.

📦 WHAT’S INCLUDED You receive:

Full n8n automation workflow

AI Agent lead-scoring logic

Google Maps scraping tool integration

Google Drive CSV export system

OpenRouter GPT-4o reasoning module

Chat interface for interactive lead searching

Pre-configured prompt logic for consistent results

Everything is production-ready and mirrors the exact JSON you provided.