Find leads on Google Maps and reach out automatically (GPT-4 + Airtable + Gmail)
Ready for 3.0Ready for 3.0. This template uses no nodes that n8n 3.0 removes. No removed nodes, versions or helpers found. Static check, last run 2026-10-19.
What this workflow does
This AI workflow has 9 nodes and runs manually, when you click “Execute workflow”. Along the way it connects OpenAI, Airtable and Gmail. It also calls api.apify.com over HTTP.
How it runs
Trigger: Manually, when you click “Execute workflow”.
- Fetch Business Data from Google Maps (Apify) (HTTP Request): calls api.apify.com (POST)
- Clean Google Maps Data (Edit Fields (Set)): sets 10 fields: Nom du centre de formation, Catégorie, Adresse…
- Iterate Through Each Business Contact (Loop Over Items (Split in Batches)): loops over the items in batches
- Extract Only Website URLs (Edit Fields (Set)): sets 1 field: Site internet
- Fetch Raw HTML Content from Business Website (HTTP Request): calls an HTTP API
- Extract Business Email from Website HTML (GPT-4) (OpenAI): uses OpenAI
- Save Cleaned Lead Data into Airtable (Airtable): create
- Send a message (Gmail): uses Gmail
Services it uses
HTTP calls to: api.apify.com
Before you upgrade to n8n 3.0
Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.
Nodes used (7)
- HTTP Request
n8n-nodes-base.httpRequest - Edit Fields (Set)
n8n-nodes-base.set - Manual Trigger
n8n-nodes-base.manualTrigger - Loop Over Items (Split in Batches)
n8n-nodes-base.splitInBatches - OpenAI
@n8n/n8n-nodes-langchain.openAi - Airtable
n8n-nodes-base.airtable - Gmail
n8n-nodes-base.gmail
From the author
Who is it for? This workflow is perfect for marketers, sales teams, agencies, and local businesses who want to save time by automating lead generation from Google Maps. It’s ideal for real estate agencies, restaurants, service providers, and any local niche…