Enrich B2B Google Maps leads with Apify, Jina AI, GPT-5.2 and Google Sheets
Go to Workflow
Khairul Muhtadin
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