🎣 Enrich B2B Google Maps leads with Apify, Jina AI, GPT-5.2 and Google Sheets
⚡ 81 views · 🎣 Lead Generation & Enrichment
💡 Pro Tip — HTTP Request scraping tends to break when sites update their markup. If you’re scraping a major platform, check if ScraperNode covers it — it has maintained scrapers for LinkedIn, Instagram, TikTok, YouTube, and 20+ other platforms that return structured data.
Description
Stop wasting hours manually hunting for business leads. This workflow automates the entire process from scraping Google Maps to extracting contact emails all triggered from your phone via Telegram.
What It Does
Send a single message to your Telegram bot (Sector; Limit; MapsURL) and the system takes over. It scrapes business data from Google Maps using Apify, generates AI-powered company summaries via OpenAI, hunts for contact emails from business websites using Jina AI, then stores everything neatly in Google Sheets.
Who It’s For
Sales reps building cold outreach lists, marketing agencies prospecting new clients, or anyone who needs targeted local business data fast — without paying for overpriced lead databases.
Why It’s Worth It
Manual research that takes 4 hours gets done in under 5 minutes for 50 leads. Pay only for what you use (Apify + OpenAI) instead of fixed monthly subscriptions. AI deduplication keeps your CRM clean and consistent.
What You’ll Need
| Tool | Purpose |
|---|---|
| n8n | Workflow engine |
| Apify | Google Maps scraper |
| OpenAI API | Summaries & email extraction |
| Google Sheets | Lead storage |
| Telegram Bot | Mobile trigger interface |
| Jina AI | Website-to-text conversion |
Quick Setup
- Import the JSON workflow into your n8n instance
- Connect credentials: Telegram bot token, Apify API key, OpenAI key, Google account
- Set up your Sheet with the matching column headers
- Test with:
Coffee Shops; 5; https://www.google.com/maps/search/coffee+shops+london
How the Logic Works
The workflow runs a two-stage loop per business. First it saves core data (name, phone, address). If a website exists, it then attempts email enrichment. This way, you never lose basic lead data even if a website crawl fails.
Extend It Further
Swap Google Sheets for HubSpot or Pipedrive, push results to a Slack sales channel, or chain a Gmail node to auto-send intro emails the moment a lead is found.
Created by: Khaisa Studio Category: Marketing | Tags: Lead Gen, AI, Google Maps, Telegram Need custom workflows? Contact us
Connect with the creator: Portfolio • Workflows • LinkedIn • Medium • Threads
🔗 Nodes Used
Google Sheets, Telegram, Telegram Trigger, OpenAI, Jina AI
📥 Import
Download workflow.json and import into n8n:
Workflow menu → Import from File