Who Is This For?

This workflow is ideal for anyone wanting 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

• Automated Lead Generation: Runs on a schedule to process ZIP codes and business categories.
• Data Extraction: Queries Google Maps for businesses using ZIP code + subcategory combinations.
• Data Processing:
  • Skips entries with STATUS = "N/A"
  • Removes duplicates using place.id
  • Extracts and formats business details
• Error Handling:
  • Exponential backoff for rate limits
  • Stops after 10 retry attempts
• Data Storage:
  • Saves results to Google Sheets
  • Tracks completed ZIP + subcategory pairs

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 Google Maps API credentials (“Google MAP”)
• Add Google Sheets OAuth2 credentials (“Google Sheets”)
• Add Rapiwa API credentials (“Rapiwa account 2”)

2. Prepare Your Google Sheet

Create one document with these tabs:

• zip — ZIP codes to process
• maps categories — Business categories/subcategories
• result — Extracted business data

Then update document ID and sheet IDs (gid values) inside workflow nodes.

3. Customize the Workflow

• Adjust the Limit node to control ZIP codes per batch (default: 10)
• Modify retry limits (default: 10 attempts)
• Set run frequency in the Schedule node (default: hourly)

This creates a simple, scalable, low-cost system for generating targeted leads automatically.

Useful Links

• MAP API – Create Project & API
• Google Maps Documentation
• Rapiwa – WhatsApp API credentials