Extract Google My Business Leads by Service or Location with Bright Data

Description

📍 Extract Google My Business Leads by Service & Location with Bright Data to Google Sheets
This template requires a self-hosted n8n instance to run.

A comprehensive n8n automation that extracts Google My Business listings by service type and geographic location using Bright Data's Google Maps dataset, with intelligent city expansion and automatic duplicate removal.

👥 Who is this for?
Lead generation professionals
Sales teams
Marketing agencies
Business development representatives
Entrepreneurs conducting outreach or market research

❓ What problem is this solving?
Manual lead generation from Google Maps is time-consuming and inefficient. This workflow automates the process of finding businesses by service type and location, expanding searches across cities, removing duplicates, and organizing results in a structured format.

⚙️ What this workflow does

Input Processing
Accepts service type, state, and country via web form
Uses Claude AI to generate city lists
Auto-categorizes services
Creates search queries per city

Data Collection
Uses Bright Data's Google Maps dataset
Processes in batches with rate limits
Monitors scraping with retry logic
Formats and handles API responses

Quality Control
Removes duplicates by name and phone
Maintains clean data in Google Sheets
Ensures structured, usable datasets

📄 Output Data Points

| Field | Description | Example |
| :-------------- | :-------------------------- | :---------------------------- |
| Business Name | Company or business name | TechFix Computer Repair |
| Category | Business category type | Electronics |
| Country | Country location | US |
| City | Specific city searched | Austin |
| Phone Number | Contact phone number | +1 (555) 123-4567 |
| Website URL | Business website | https://techfix.com |
| Google Maps URL | Direct Maps link | https://maps.google.com/... |
| Address | Full business address | 123 Main St, Austin, TX |
| Operating Hours | Business hours | Mon-Fri 9AM-6PM |
| Google Rating | Star rating | 4.5 |
| Total Reviews | Number of reviews | 127 |
| Reviews URL | Link to reviews | https://maps.google.com/reviews... |

🚀 Setup Instructions

Prerequisites
n8n instance (self-hosted or cloud)
Google account with Sheets access
Bright Data account with Google Maps dataset access
Anthropic API key for Claude AI

Step-by-Step
Import the workflow JSON into n8n
Configure Bright Data credentials and dataset access
Set up Google Sheets and OAuth2 credentials
Configure Claude AI with your API key
Replace all placeholder credential IDs and tokens. For improved security, use credentials instead of hardcoding the API token placeholder in the HTTP Request node.
Test with sample data (e.g., "Coffee Shop" in California, US)
Activate the workflow and use the form for submissions

🛠 How to Customize

Modify Geographic Scope
Add countries to the form dropdown
Customize Claude prompts for city generation
Adjust search logic for international markets

Enhance Data Collection
Add more fields from Bright Data
Include revenue, employee count, social profiles

Improve Duplicate Detection
Use fuzzy matching for similar names
Include address-based checks

Customize Output Format
Transform data for CRM compatibility
Export to CSV, database, or multiple destinations

Implement Advanced Features
Integrate email finder services
Include lead scoring logic
Discover social media profiles

Batch Processing Optimization
Adjust batch sizes per Bright Data limits
Use parallel processing and retry logic

Integration Options
Connect to CRMs like HubSpot or Salesforce
Trigger email automation
Integrate with marketing platforms