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

by Dinakar Selvakumar ✓ · 123 views · created 2026-01-25 · Lead Generation, Multimodal AI

What this workflow does

This AI workflow has 62 nodes and runs on a schedule (every 15 minutes) (plus 4 other triggers). Along the way it connects Google Sheets, Google Gemini and Gmail. It also calls places.googleapis.com over HTTP.

How it runs

Trigger: On a schedule (every 15 minutes) (plus 4 other triggers).

1. Settings (Edit Fields (Set)): sets 3 fields: gs_url, catSheet, sheet
2. Get row(s) in sheet (Google Sheets): uses Google Sheets
3. Get row(s) in sheet (Google Sheets): uses Google Sheets
4. Get row(s) in sheet (Google Sheets): uses Google Sheets
5. Get row(s) in sheet (Google Sheets): uses Google Sheets
6. Get Zip Codes (Google Sheets): uses Google Sheets
7. Check: Intro Ready & Not Sent (If): checks a condition and branches into true / false
8. Check: Follow Up 1 Due (If): checks a condition and branches into true / false
9. Check: Intro Mail Empty (If): checks a condition and branches into true / false
10. Check: Follow Up 2 Due (If): checks a condition and branches into true / false

…plus 47 more steps. See the full node list below.

Services it uses

Google SheetsGoogle GeminiGmail

HTTP calls to: places.googleapis.com

Before you upgrade to n8n 3.0

Nodes used (15)

• Stop and Errorn8n-nodes-base.stopAndError
• Google Sheetsn8n-nodes-base.googleSheets
• Edit Fields (Set)n8n-nodes-base.set
• Filtern8n-nodes-base.filter
• Split Outn8n-nodes-base.splitOut
• Loop Over Items (Split in Batches)n8n-nodes-base.splitInBatches
• HTTP Requestn8n-nodes-base.httpRequest
• Google Gemini@n8n/n8n-nodes-langchain.googleGemini
• Gmailn8n-nodes-base.gmail
• Schedule Triggern8n-nodes-base.scheduleTrigger
• Ifn8n-nodes-base.if
• Waitn8n-nodes-base.wait
• Coden8n-nodes-base.code
• Limitn8n-nodes-base.limit
• Mergen8n-nodes-base.merge

From the author

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…

View the original on n8n.io → Check your own copy