Generate and enrich local business leads with Decodo, OpenAI and Gmail
Needs changesNeeds changes. This template uses 1 thing(s) that n8n 3.0 removes: OpenAI (legacy). 1 breaking item(s) found. Static check, last run 2026-10-19.
What this workflow does
This workflow has 27 nodes and runs on a schedule (cron 0 10 * * *). Along the way it connects Google Sheets, Gmail and Decodo (community).
How it runs
Trigger: On a schedule (cron 0 10 * * *).
- Search Config (Edit Fields (Set)): sets 9 fields: niche, city, geo…
- Decodo: uses Decodo
- Parse Leads from Markdown (Code): runs custom JavaScript code
- Is Valid Lead? (If): checks a condition and branches into true / false
- Save Lead to Google Sheets (Google Sheets): append or update
- Split In Batches (Loop Over Items (Split in Batches)): loops over the items in batches
- Get Enriched Leads (Google Sheets): uses Google Sheets
- Has Website? (If): checks a condition and branches into true / false
- Filter by Score Threshold (Code): runs custom JavaScript code
- Decodo: uses Decodo
…plus 16 more steps. See the full node list below.
Services it uses
Before you upgrade to n8n 3.0
1 thing in this workflow is removed in n8n 3.0. Fix it before you upgrade:
- OpenAI (legacy) in AI: Score & Enrich Lead, AI: Write Cold Email: replace with OpenAI node (AI section).
Rather not rewrite it? Many of these flows can be rebuilt in Make (free plan).
| Removed in 3.0 | Replace with |
|---|---|
| OpenAI (legacy) AI: Score & Enrich Lead, AI: Write Cold Email | OpenAI node (AI section) |
Nodes used (9)
- Schedule Trigger
n8n-nodes-base.scheduleTrigger - Edit Fields (Set)
n8n-nodes-base.set - Decodo
@decodo/n8n-nodes-decodo.decodo - Code
n8n-nodes-base.code - If
n8n-nodes-base.if - Google Sheets
n8n-nodes-base.googleSheets - Loop Over Items (Split in Batches)
n8n-nodes-base.splitInBatches - OpenAI
n8n-nodes-base.openAi - Gmail
n8n-nodes-base.gmail
From the author
Quick overview This workflow finds local business leads on Google Maps, enriches them with website and AI analysis, and sends personalized cold emails to qualified prospects automatically. How it works 1. The workflow starts on a schedule and loads the…