Skip to main content

Scrape business leads from Google Maps using OpenAI and Google Sheets

Workflow preview

Workflow preview
100%
Scrape business leads from Google Maps using OpenAI and Google Sheets preview
Open on n8n.io
n8n Cloud
$20/month : Unlimited workflows
2500 executions/month
Try free
Bright Data
THE #1 IN WEB SCRAPING
Scrape any website without limits
Try free
HOSTINGER Hostinger Early Deal
DISCOUNT 20%
Self-hosted n8n
Unlimited workflows - from $4.99/mo
Try free
Apify
#1 hub for scraping, AI & automation
6000+ actors - $5 credits/mo
Try free

Important notice

This workflow is provided as-is. Please review and test before using in production.

1. Workflow Overview

Google Maps Data Extraction Workflow for Lead Generation This workflow is ideal for sales teams, marketers, entrepreneurs, an...

Best for

  • Lead Generation automation workflows
  • AI Summarization automation workflows
  • advanced n8n builders looking for reusable templates

Tools used

@n8n/n8n-nodes-langchain.chattrigger, @n8n/n8n-nodes-langchain.agent, @n8n/n8n-nodes-langchain.lmchatopenai, @n8n/n8n-nodes-langchain.memorybufferwindow, @n8n/n8n-nodes-langchain.toolworkflow, @n8n/n8n-nodes-langchain.toolserpapi, n8n-nodes-base.stickynote, n8n-nodes-base.executeworkflowtrigger

Source and attribution

This workflow is cataloged by N8N Workflows and links back to its original n8n.io source page by Dr. Firas.

Original n8n.io source

1.1 Workflow description

Title
Scrape business leads from Google Maps using OpenAI and Google Sheets
Workflow name
Scrape business leads from Google Maps using OpenAI and Google Sheets

Google Maps Data Extraction Workflow for Lead Generation

This workflow is ideal for sales teams, marketers, entrepreneurs, and researchers looking to efficiently gather detailed business information from Google Maps for:

  • Lead generation
  • Market analysis
  • Competitive research

Who Is This Workflow For?

  • Sales professionals aiming to build targeted contact lists
  • Marketers looking for localized business data
  • Researchers needing organized, comprehensive business information

Problem This Workflow Solves

Manually gathering business contact details from Google Maps is:

  • Tedious
  • Error-prone
  • Time-consuming

This workflow automates data extraction to increase efficiency, accuracy, and productivity.

What This Workflow Does

  • Automates extraction of business data (name, address, phone, email, website) from Google Maps
  • Crawls and extracts additional website content
  • Integrates OpenAI to enhance data processing
  • Stores structured results in Google Sheets for easy access and analysis
  • Uses Google Search API to fill in missing information

Setup

  1. Import the provided n8n workflow JSON into your n8n instance.
  2. Set your OpenAI and Google Sheets API credentials.
  3. Provide your Google Maps Scraper and Website Content Crawler API keys.
  4. Ensure SerpAPI is configured to enhance data completeness.

Customizing This Workflow to Your Needs

  • Adjust scraping parameters:
    • Location
    • Business category
    • Country code
  • Customize Google Sheets output format to fit your current data structure
  • Integrate additional AI processing steps or APIs for richer data enrichment

Final Notes

This structured approach ensures:

  • Accurate and compliant data extraction from Google Maps
  • Streamlined lead generation
  • Actionable and well-organized data ready for business use

đź“„ Documentation: Notion Guide

Demo Video

🎥 Watch the full tutorial here: YouTube Demo

1.2 Logical Blocks

This catalog entry is organized from the workflow JSON. The node-level section below shows the executable blocks available for review before importing the template.

2. Block-by-Block Analysis

Block 1 - Trigger - When User Sends Message

Type / Role
@n8n/n8n-nodes-langchain.chatTrigger - chatTrigger
Config choices
Version 1.1

Block 2 - AI Agent - Lead Collection

Type / Role
@n8n/n8n-nodes-langchain.agent - agent
Config choices
Version 1.8

Block 3 - GPT-4o - Generate & Process Requests

Type / Role
@n8n/n8n-nodes-langchain.lmChatOpenAi - lmChatOpenAi
Config choices
Version 1.2

Block 4 - Memory - Track Recent Context

Type / Role
@n8n/n8n-nodes-langchain.memoryBufferWindow - memoryBufferWindow
Config choices
Version 1.3

Block 5 - Tool - Scrape Google Maps Business Data

Type / Role
@n8n/n8n-nodes-langchain.toolWorkflow - toolWorkflow
Config choices
Version 2.1

Block 6 - Fallback - Enrich with Google Search

Type / Role
@n8n/n8n-nodes-langchain.toolSerpApi - toolSerpApi
Config choices
Version 1

Block 7 - Sticky Note

Type / Role
n8n-nodes-base.stickyNote - stickyNote
Config choices
Version 1

Block 8 - Tool - Crawl Business Website

Type / Role
@n8n/n8n-nodes-langchain.toolWorkflow - toolWorkflow
Config choices
Version 2.1

Block 9 - Trigger - On Subworkflow Start

Type / Role
n8n-nodes-base.executeWorkflowTrigger - executeWorkflowTrigger
Config choices
Version 1.1

Block 10 - Scrape Google Maps (via Apify)

Type / Role
n8n-nodes-base.httpRequest - httpRequest
Config choices
Version 4.2

Block 11 - Save Extracted Data to Google Sheets

Type / Role
n8n-nodes-base.googleSheets - googleSheets
Config choices
Version 4.5

Block 12 - Aggregate Business Listings

Type / Role
n8n-nodes-base.aggregate - aggregate
Config choices
Version 1

Block 13 - Sticky Note1

Type / Role
n8n-nodes-base.stickyNote - stickyNote
Config choices
Version 1

Block 14 - Scrape Website Content (via Apify)

Type / Role
n8n-nodes-base.httpRequest - httpRequest
Config choices
Version 4.2

Block 15 - Save Website Data to Google Sheets

Type / Role
n8n-nodes-base.googleSheets - googleSheets
Config choices
Version 4.5

Block 16 - Aggregate Website Content

Type / Role
n8n-nodes-base.aggregate - aggregate
Config choices
Version 1

Block 17 - Sticky Note2

Type / Role
n8n-nodes-base.stickyNote - stickyNote
Config choices
Version 1

3. Summary Table

Workflow Scrape business leads from Google Maps using OpenAI and Google Sheets
Complexity advanced
Nodes 17
Categories Lead Generation, AI Summarization
Author Dr. Firas
Published 05 Apr 2025

4. Reproducing the Workflow from Scratch

  1. 1. Download the workflow JSON

    Use the JSON export at /data/workflows/3443/3443.json as the source template for this automation.

  2. 2. Import the template into n8n

    Open n8n, import the downloaded JSON, and review each node before activating the workflow.

  3. 3. Configure credentials and variables

    Replace placeholder credentials, API keys, webhook URLs, account IDs, and environment-specific values with your own settings.

  4. 4. Test with sample data

    Run the workflow manually or in a staging workspace, inspect node output, and confirm downstream systems receive the expected data.

  5. 5. Activate and monitor

    Enable the workflow only after testing, then monitor executions, errors, and rate limits during the first production runs.

5. General Notes & Resources

Review imported nodes carefully before activation. This catalog entry is intended to help you inspect the workflow structure, understand required services, and find related templates faster.

Node names, credentials, schedules, webhook paths, and external service limits may need adjustment for your workspace.

Download workflow JSON Original n8n.io source Lead Generation workflows AI Summarization workflows

Frequently asked questions

What does Scrape business leads from Google Maps using OpenAI and Google Sheets do?

Google Maps Data Extraction Workflow for Lead Generation This workflow is ideal for sales teams, marketers, entrepreneurs, an...

What do I need before importing this workflow?

Review the workflow JSON, configure any required credentials in n8n, and test the automation in a safe workspace before using it in production.

Can I customize this workflow?

Yes. Use the block-by-block analysis and the downloadable JSON to inspect each node, then adjust credentials, prompts, schedules, filters, or destinations for your Lead Generation, AI Summarization use case.