Scrape Google Maps business leads with Apify & GPT-4 email extraction
UnknownWhat this workflow does
This AI workflow has 14 nodes and runs on Telegram events (message). Along the way it connects Google Sheets, Telegram, OpenAI and Apify (community).
How it runs
Trigger: On Telegram events (message).
- Extract Input Data (Code): runs custom JavaScript code
- Run Google Maps Scraper (Apify): uses Apify
- Get dataset items (Apify): work with datasets
- Remove Duplicates: removes duplicate items
- Loop Over Items (Loop Over Items (Split in Batches)): loops over the items in batches
- Notification message (Telegram): uses Telegram
- AI Company Description Generator (OpenAI): uses OpenAI
- Google maps database (Google Sheets): append
- 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
…plus 3 more steps. See the full node list below.
Services it uses
Before you upgrade to n8n 3.0
We can't fully verify this one: it relies on 1 community package, and n8n 3.0 turns unverified community packages off by default (N8N_UNVERIFIED_PACKAGES_ENABLED=false).
- Check that @apify/n8n-nodes-apify is verified or supports 3.0 (used in Get dataset items, Run Google Maps Scraper).
Nodes used (11)
- Apify
@apify/n8n-nodes-apify.apify - Remove Duplicates
n8n-nodes-base.removeDuplicates - Loop Over Items (Split in Batches)
n8n-nodes-base.splitInBatches - Google Sheets
n8n-nodes-base.googleSheets - Wait
n8n-nodes-base.wait - Telegram Trigger
n8n-nodes-base.telegramTrigger - Code
n8n-nodes-base.code - Telegram
n8n-nodes-base.telegram - Edit Fields (Set)
n8n-nodes-base.set - HTTP Request
n8n-nodes-base.httpRequest - OpenAI
@n8n/n8n-nodes-langchain.openAi
From the author
💥 Automate Scrape Google Maps Business Leads (Email, Phone, Website) using Apify 🧠 AI-Powered Business Prospecting Workflow (Google Maps + Email Enrichment) Who is this for? This workflow is designed for entrepreneurs, sales teams, marketers, and agencies…