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 t