Discover local business leads and run AI-powered cold email sequences with Google Maps and Gmail

Description

Discover local business leads and run automated cold email sequences with Google Maps and Gmail

This workflow is a complete outbound automation system that discovers local businesses, extracts contact emails, generates personalized cold emails using AI, and runs a multi-step follow-up sequence — fully automated.

It is designed for founders, agencies, and consultants who want to generate leads at scale without manual scraping or repetitive email work.

Use cases

Local service lead generation (marketing agencies, SaaS, consultants)
B2B prospecting by location and category
Automated cold outreach campaigns
Market research and business discovery
Sales pipeline bootstrapping

How it works

Reads ZIP codes and business categories from Google Sheets
Queries Google Maps API for matching businesses
Visits each website and extracts public emails
Stores leads in Google Sheets
Uses AI to generate intro + 2 follow-up emails
Sends emails via Gmail
Automatically schedules follow-ups
Tracks status and prevents duplicates

Everything runs on schedules and updates itself.

How to use

Create a Google Sheet with:
Zips tab (ZIP codes)
Google Maps Categories tab
Results tab

Add:
Google Maps API key
Gmail account
Google Sheets credentials

Replace placeholders:
Company name
Logo URL
CTA text

Enable schedule triggers.

That’s it. The system runs continuously.

Requirements

Google Maps API key
Google account (Sheets + Gmail)
Gemini / OpenAI API key
Public company logo URL

No paid scraping tools required.

Good to know

Uses exponential backoff to handle API limits safely
Prevents duplicate leads using place_id
Tracks email status and send dates
Follow-ups only send if intro was delivered
All data stays in your Google Sheets

Customising this workflow

You can easily:

Change email copy style in the AI prompt
Adjust follow-up delays
Add more follow-up steps
Replace Gmail with Outlook or SMTP
Push leads into CRM instead of Sheets

This workflow is modular and extensible.

What this n8n template demonstrates

Real-world lead generation automation
Web scraping with fallback logic
AI-powered copy generation
Stateful workflow design
Multi-trigger scheduling
Error handling and retries
Production-grade outbound system

This is not a demo — it’s a deployable business workflow.

Need a custom setup?

If you want a similar system built for your business (custom data sources, CRM integration, WhatsApp bots, booking systems, dashboards, or private deployments), feel free to reach out at [email protected]