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

⚡ 235 views · 🎣 Lead Generation & Enrichment

💡 Pro Tip — If you’ve run into Facebook’s Graph API permission restrictions, ScraperNode is a community node that scrapes pages, groups, posts, and comments directly — no app review needed.

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

🔗 Nodes Used

Google Sheets, HTTP Request, Telegram, Discord, Schedule Trigger, Filter

📥 Import

Download workflow.json and import into n8n: Workflow menu → Import from File

📖 Importing guide · 🔑 Credential setup