Zip code-based business lead generation with Google Maps and Sheets

Description

Who Is This For?
This workflow is perfect for anyone who wants to automate lead generation using n8n without paying for expensive scraping tools. It uses simple Google Maps API requests and Google Sheets to pull business data by ZIP code and category, then extracts emails at no extra cost.

What This Workflow Does
Automated Lead Generation**: Runs on a schedule to process ZIP codes and business categories automatically.
Data Extraction**: Queries Google Maps for businesses based on each ZIP code + subcategory combo.
Data Processing**:
Skips entries with a STATUS = "N/A"
Removes duplicate results using place.id
Extracts and formats relevant business details
Error Handling**:
Uses exponential backoff when hitting rate limits
Stops after 10 retry attempts
Data Storage**:
Saves results directly to Google Sheets
Tracks which ZIP/subcategory pairs have been completed

Requirements
Google Maps API** (business lookup)
Google Sheets OAuth2** (data storage)
Telegram Bot API** (notifications)
Rapiwa API** (WhatsApp alerts)

How to Use — Step-by-Step Setup
1. Set Up Credentials in n8n
Add your Google Maps API credentials (named "Google MAP")
Add Google Sheets OAuth2 credentials (named "Google Sheets")
Add Rapiwa API credentials (named "Rapiwa account 2")

2. Prepare Your Google Sheet
Create one Sheet document with these tabs:
zip** — ZIP codes to process
maps categories** — Business categories/subcategories
result** — Where extracted business data will be stored
Then update:
The document ID inside the workflow nodes
The sheet IDs (gid values) so they match your actual tabs

3. Customize the Workflow
Change the Limit node to control how many ZIP codes run per batch (default: 10)
Adjust retry limits in the relevant nodes (default: 10 attempts)
Modify the Schedule node to set your preferred run frequency (default: hourly)
> This gives you a simple, scalable, nearly free system for generating targeted leads automatically.

Useful Links
MAP API Create Project & API
How to Use google map docs
Rapiwa**: Get your WhatsApp API credentials

Support & Help
WhatsApp**: Chat on WhatsApp
Discord**: SpaGreen Community
Facebook Group**: SpaGreen Support
Website**: https://spagreen.net
Developer Portfolio**: Codecanyon SpaGreen