Back to Templates
📍 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