G
GTM Vault
Browse
  • Dashboard
    • Automations
    • Skills
    • Prompts
    • Makers
  • Sign in
All Automations

Scrape Google Maps business leads with Apify & GPT-4 email extraction

Automatically scrapes Google Maps business data, extracts contact emails using AI, and organizes leads in Google Sheets with Telegram notifications.

workflowlead_generation
Dr. Firasby Dr. Firason n8n
Nodes

17

Triggers

1

Platform

n8n

Tech Stack
Apify
Apify
Google Sheets
Google Sheets
Telegram
Telegram
OpenAI
OpenAI
How It Works

This workflow searches Google Maps for businesses based on your criteria, then uses AI to extract contact information and generate business summaries. All qualified leads are automatically organized in a Google Sheets database with complete contact details.

1

Send search criteria via Telegram

Send a message specifying business type, number of leads needed, and target Google Maps location to trigger the workflow.

2

Scrape business data from Google Maps

Apify automatically extracts publicly available business information including names, addresses, phone numbers, and websites from Google Maps.

3

Remove duplicate entries

The system filters out any duplicate businesses to ensure clean, unique results in your final database.

4

Generate AI business summaries

GPT-4 analyzes each business and creates concise summaries to help you better understand potential prospects.

5
Attached Files
workflow.json

Extract professional email addresses

AI scans company websites to find and extract professional contact email addresses for outreach purposes.

6

Save leads to Google Sheets

All business information, contact details, and AI summaries are automatically organized in a structured Google Sheets database.

7

Receive completion notification

Get a Telegram notification confirming when all businesses have been processed and added to your database.

What You'll Need

  • Telegram bot token from BotFather
  • Apify account with API access
  • Google Sheets account
  • OpenAI API key for GPT-4 access

This automation has 5 configurable settings you'll customize during setup.