Description
This n8n workflow automates the extraction and enrichment of business leads from Google Maps and stores them in Google Sheets. Perfect for sales, marketing, or research teams looking to build rich contact lists without the manual labor.
🔹 How It Works:
1. Lead Discovery & Scraping
-
Scrapes business info (name, address, phone, email, website) from Google Maps
-
Utilizes SerpAPI or custom scraping APIs
-
Handles missing data by searching official websites
2. AI-Powered Enrichment
-
Uses OpenAI to clean and enrich business descriptions
-
Crawls website content for additional context
-
Categorizes and tags businesses for segmentation
3. Structured Storage & Output
-
Automatically logs lead data to Google Sheets
-
Organized with dynamic headers and formatting
-
Supports customizable fields and sorting
🛠️ Setup Steps:
Setting up this workflow takes around 20–25 minutes:
1. API Configuration (8–10 minutes)
-
OpenAI API key
-
Google Sheets API credentials
-
SerpAPI / Maps Scraper API key
-
Optional: Website Crawler API
2. Sheet & Crawler Setup (5–7 minutes)
-
Create a new Google Sheet with defined headers
-
Configure scraping filters: location, business type, keywords
3. Workflow Customization (7–8 minutes)
-
Add or remove enrichment steps
-
Set Google Maps query parameters
-
Test scraping logic and verify output in Sheets
🧠 Who It’s For:
-
Sales Teams building hyper-targeted business lists
-
Marketers analyzing local or niche markets
-
Researchers conducting competitive or demographic studies
✅ Key Benefits:
-
No more manual copy-pasting from Google Maps
-
Always-updated business lead sheets
-
Fully customizable and scalable workflow
-
Easily extendable to CRM, email outreach, or analytics tools
