Who Is This For?
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. An n8n automation workflow template by SpaGreen Creative.
SpaGreen Creative
web
paid
Others in the same category, ranked by how often they are opened.
