Discover local business leads and run automated cold email sequences with Google Maps and Gmail
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 dinakars2003@gmail.com. An n8n automation workflow template by Dinakar Selvakumar.
Dinakar Selvakumar
web
paid
Others in the same category, ranked by how often they are opened.
