Scrape Google Maps leads (email, phone, website) using Apify + GPT + Airtable
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 8 nodes and runs manually, when you click “Execute workflow”. Along the way it connects OpenAI and Airtable.
How it runs
Trigger: Manually, when you click “Execute workflow”.
- Fetch Business Data from Google Maps (Apify) (HTTP Request): calls an HTTP API (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
Services it uses
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 (6)
- 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
From the author
Who is it for? This workflow is for marketers, sales teams, and local businesses who want to quickly collect leads (business name, phone, website, and email) from Google Maps and store them in Airtable. You can use it for real estate agents, restaurants,…