Enrich Google Maps business leads using Apify, OpenAI, Jina AI, Telegram and Sheets

B2B leads without the database subscription. This workflow scrapes Google Maps, writes AI business summaries, and digs contact emails out of websites, all triggered from Telegram on your phone. Four hours of manual hunting becomes 5 minutes per 50 leads.

Last updated: September 2026.

Why Use This Workflow?

Time Savings: Lead research drops from 4 hours of manual searching to 5 minutes of automated execution per 50 leads.

Cost Reduction: A pay-as-you-go model with Apify and OpenAI replaces expensive monthly lead database subscriptions.

Error Prevention: AI deduplicates results and keeps company summaries professional and CRM-ready.

Scalability: Trigger massive scraping tasks from your phone while the backend does the heavy lifting.

Ideal For

• Sales Development Reps (SDRs): Targeted lists of local businesses for cold outreach or door-knocking campaigns.
• Marketing Agencies: New businesses in specific sectors (e.g., "Dentists in Paris") for SEO or advertising pitches.
• Real Estate Investors: Commercial properties or business types by area for investment scouting.

How It Works

1. Trigger: The workflow starts when you send a message to your Telegram bot in the format: Sector; Limit; MapsURL.
2. Data Collection: n8n parses these parameters and triggers an Apify Actor to scrape Google Maps for business details.
3. Processing: The workflow retrieves the results, removes duplicate entries, and begins a loop to process each business.
4. Intelligence Layer (Summary): OpenAI analyzes the business data to create a natural, human-like summary of the company.
5. Enrichment (Email Hunting): If the business has a website, Jina AI fetches the page content, and OpenAI extracts the most authoritative contact email.
6. Output & Delivery: Core data is upserted into Google Sheets, and the email is updated once found. A "DONE" notification is sent to Telegram upon completion.

Setup Guide

Prerequisites

Requirement	Type	Purpose
n8n instance	Essential	Workflow execution and logic
Apify Account	Essential	Scrapes Google Maps data
OpenAI API Key	Essential	Generates summaries and extracts emails
Google Sheets	Essential	Data storage and lead management
Telegram Bot	Essential	User interface for triggering searches
Jina AI Key	Essential	Converts websites to LLM-friendly Markdown

Installation Steps

1. Import the JSON file into your n8n instance.
2. Configure credentials:
   • Telegram: Create a bot via @BotFather and add your token to the Telegram nodes.
   • Apify: Provide your API token to the "Run Maps Scraper" and "Fetch Dataset" nodes.
   • OpenAI: Add your API key to the enrichment nodes.
   • Google Sheets: Connect your Google account and select your target Spreadsheet ID.
3. Set up the Sheet: Ensure your Google Sheet has headers matching the "Upsert" node (Title, Email, Category, Website, etc.).
4. Test execution: Send a message like Coffee Shops; 5; https://www.google.com/maps/search/coffee+shops+london to your bot.

Technical Details

Core Nodes

Node	Purpose	Key Configuration
Telegram Trigger	Captures user input	Listens for /message updates
Apify Node	Executes Maps Scraper	Uses nwua9Gu5YrADL7ZDj actor ID
OpenAI Node	AI Analysis	Configured for JSON output (Summary) and extraction (Email)
Jina AI	Web Scraping	Converts HTML to Markdown for AI readability
Google Sheets	Database	Uses Append or Update based on the business Title

Workflow Logic

The workflow utilizes a Split In Batches loop to ensure stability. It first performs a "shallow" save of business details (name, phone, address) and then attempts a "deep" enrichment only if a website URL is detected. This two-stage approach ensures you don't lose data if a website crawl fails.

Customization Options

Basic Adjustments:

• Rate Limit: Adjust the "Wait" node duration (default 2s) to comply with Google Sheets or API limits.
• Language: Modify the OpenAI prompt to generate summaries in your preferred language (e.g., English, French, Spanish).

Advanced Enhancements:

• CRM Integration: Replace Google Sheets with HubSpot or Pipedrive for direct lead injection.
• Slack Notifications: Send the final lead list or business summary directly to a sales channel.
• Auto-Emailer: Add a Gmail/Outlook node to automatically send an introductory email once a lead is found.

Troubleshooting

Common Issues:

Problem	Cause	Solution
Empty Email column	Website protected by bot-blockers	Try a different scraper or use a proxy in Jina AI
Apify Timeout	Scraping limit set too high	Lower the "limit" parameter in your Telegram message
429 Errors	Google Sheets rate limits	Increase the duration in the "Wait Rate Limit" node

Use Case Examples

Scenario 1: Local SEO Agency

Challenge: Finding local contractors with poor reviews but high revenue potential.
Solution: Use the workflow to scrape "Plumbers" in a city, use AI to summarize their online presence, and collect emails.
Result: A curated list of 100 leads with contact info and a "Pitch" summary generated in minutes.

Scenario 2: SaaS Cold Outreach

Challenge: Getting the direct email of a business owner for a new booking software.
Solution: Trigger the scraper via Telegram while in the field. The workflow extracts the "authoritative" email (manager/owner) from their site.
Result: Accurate, high-intent lead data delivered directly to a master spreadsheet for the sales team.

---

Quick Answers

What do I send the bot?
Sector; Limit; MapsURL. Example: Coffee Shops; 5; https://www.google.com/maps/search/coffee+shops+london.
Which Apify actor runs?
nwua9Gu5YrADL7ZDj for Maps scraping, configured in the workflow nodes.
Can summaries be non-English?
Yes. Adjust the OpenAI prompt language (English, French, Spanish, etc.).

Made by: khmuhtadin
Category: Marketing | Tags: Lead Gen, AI, Google Maps, Telegram
Need custom workflows? Contact me

Connect with the creator:
Portfolio • Workflows • LinkedIn • Medium • Threads

Additional info

Built with n8n. Need an assessment on your business? Feel free to reach out at https://khmuhtadin.com/consultation/