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

What This Workflow Does The automation runs on a schedule to process ZIP codes and business categories. It queries Google Maps for businesses based on each ZIP/subcategory combination, skips entries with STATUS = "N/A," removes duplicates using place.id, and formats relevant business details. Exponential backoff handles rate limits, stopping after 10 retries. Results are saved in Google Sheets, tracking completed ZIP/subcategory pairs.

Key Features

Automated lead generation by ZIP code and category

Google Maps business lookup with email extraction

Deduplication and data formatting

Error handling with retry limits and exponential backoff

Scheduled batch processing (default: hourly)

Results stored in Google Sheets for easy access

Notifications via Telegram and WhatsApp

Requirements Google Maps API, Google Sheets OAuth2, Telegram Bot API, Rapiwa API.

Setup Overview Add API credentials in n8n. Prepare a Google Sheet with tabs: zip (ZIP codes), maps categories (business categories/subcategories), and result (extracted data). Update document and sheet IDs in workflow nodes. Customize batch size, retries, and schedule to suit your needs for a scalable, low-cost lead generation system.