AutomationMart
Home/Browse/Enrich B2B Google Maps leads with Apify, Jina AI, GPT-5.2 and Google Sheets
n8n

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

n8nn8n15 modulesv1.0
HubSpotGmailSlackGoogle SheetsOpenAIPipedriveTelegramLinkedIn

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 ne

At a glance

Enrich B2B Google Maps leads with Apify, Jina AI, GPT-5.2 and Google Sheets is a ready-made n8n workflow you import as a workflow JSON file — no build required. It connects HubSpot, Gmail, Slack, Google Sheets. It's free to download. Follow the 5-step import below to go live in minutes.

Platform
n8n
Connects
HubSpot, Gmail, Slack, Google Sheets, OpenAI, Pipedrive
Modules
15
Price
Free
Version
v1.0
Enrich B2B Google Maps leads with Apify, Jina AI, GPT-5.2 and Google Sheets workflow diagram

About this workflow

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; 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

n8n

How to import this n8n workflow

  1. 1

    Download the workflow JSON file after purchase.

  2. 2

    Open n8n → click the menu → Import from File.

  3. 3

    Select the downloaded JSON and import.

  4. 4

    Set up credentials for each node that requires them.

  5. 5

    Click Execute Workflow to test, then activate.

Setup guide

Setup guide included

Purchase to unlock the full step-by-step guide

Related N8n workflows

Upsert a contact in HubSpot CRM from a custom webhook

Automatically update or add contacts in HubSpot CRM when triggered by a custom webhook, ensuring your CRM data stays current and accurate.

Free

Add new rows to a Goolge Sheets spreadsheet from new HappyFox tickets

Every time a new ticket is created in HappyFox Help Desk, Make will automatically add a new row to a Google Sheets spreadsheet. The template uses this [example spreadsheet.](https://docs.google.com/spreadsheets/d/1e-KG_01I1TictJDLg6tUqnkVjP6n5-ixzz1nbeEDe38/edit?usp=sharing) You should make a copy of it before configuring the template.

Free

AI proposal generator

Overview Stop spending hours formatting proposals. This workflow turns a short post-call form into a high-converting, fully-personalized PandaDoc proposal—plus updates your CRM and drafts the follow-up email for you. After a sales call, just fill out a 3-minute form summarizing key pain points, solutions pitched, and the price. The workflow uses AI to generate polished proposal copy, then builds a PandaDoc draft using dynamic data mapped into the JSON body (which you can fully customize per

Free

Create a new Google Docs document for every new row in Google Sheets with Perplexity AI

This automation generates a Google Docs document for each new row in Google Sheets, enriched with Perplexity AI completions, streamlining document creation and data management.

Free

Create AI-ready vector datasets for LLMs with Bright Data, Gemini & Pinecone

Who this is for? This workflow enables automated, scalable collection of high-quality, AI-ready data from websites using Bright Data’s Web Unlocker, with a focus on preparing that data for LLM training. Leveraging LLM Chains and AI agents, the system formats and extracts key information, then stores the structured embeddings in a Pinecone vector database. This workflow is tailored for:​ - ML Engineers & Researchers building or fine-tuning domain-specific LLMs. - AI Startups needing clean, struct

Free

Shorten a link from a Google Sheets row using Bitly and send it as a Discord message

Use this template to automatically shorten a link stored in your Google Sheets spreadsheet with Bitly and post it as a Discord message. Your Google Sheets spreadsheet has to contain at least 1 column: a link you want to shorten.

Free

Simple eval for legal benchmarking

This workflow demonstrates a simple way to run evals on a set of test cases stored in a Google Sheet. The example we are using comes from an info extraction task dataset, where we tested 6 different LLMs on 18 different test cases. You can see our sample data in this spreadsheet here to get started. Once you have this working for our dataset, you can plug in your own test cases matching different LLMs to see how it works with your own data. How it works: - It loads test cases from Google Sheets.

Free

AI speech coach & generator using Telegram, Open AI and Gemini

Description This n8n workflow acts as your personal AI speechwriting coach, directly accessible through Telegram. It listens to your spoken or typed drafts, provides insightful feedback on clarity, engagement, structure, and content, and iteratively refines your message based on your updates. Once you're ready, it synthesizes a brand-new speech or talk incorporating all the improvements and your accumulated ideas. This tool streamlines the speechwriting process, offering on-demand AI assistance

Free

Reviews

No reviews yet

Be the first to buy and share your experience.

Leave a review

Sign in to share your experience with this workflow.

Log in to review
Free
No ratings yet

Create a free account to purchase workflows.

  • JSON blueprint — instant download
  • Setup guide PDF included
  • 5 downloads · valid 30 days
  • Works with n8n

Need help setting this up?

Book a 3-hour live setup session with an Agility consultant.

₹2,499/ session
3 hrs · video call
  • Configure live on Google Meet / Zoom
  • Free follow-up if workflow has defects
  • Platform expert assigned to you
Book installation session
Free