Back to Templates

Enrich B2B Google Maps leads with Apify, Jina AI, GPT-5.2 and Google Sheets

Created by

Created by: Khairul Muhtadin || khmuhtadin

Khairul Muhtadin

Last update

Last update 16 hours ago

Share


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

  1. Import the JSON workflow into your n8n instance
  2. Connect credentials: Telegram bot token, Apify API key, OpenAI key, Google account
  3. Set up your Sheet with the matching column headers
  4. 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:
PortfolioWorkflowsLinkedInMediumThreads