Who Is This For This workflow is ideal for anyone looking to automate lead generation with n8n using Google Maps API and Google Sheets, without expensive scraping tools. It extracts business emails at no extra cost.

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

Key Features

Scheduled automated lead generation

Business lookup via Google Maps API

Deduplication and data formatting

Error handling with retries and exponential backoff

Batch processing (default: 10 ZIP codes per run)

Stores results and tracking in Google Sheets

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), and result (extracted data). Update document and sheet IDs in workflow nodes. Customize batch size, retries, and schedule to create a scalable, low-cost automated lead generation system.