📍 Automated Lead Generation Workflow (n8n)

Easily generate targeted leads without expensive scraping tools. Uses Google Maps API and Google Sheets to extract business data by ZIP code and category, including emails.

---

🎯 Who It's For

• Entrepreneurs and marketers who want automated lead generation
• Agencies collecting business contact information
• Small businesses targeting local prospects without paying for scraping tools

---

✨ Key Features

• Automated Lead Generation – Processes ZIP codes and business categories on a schedule
• Data Extraction – Queries Google Maps for business details based on ZIP + subcategory
• Data Processing:
  • Skips entries with STATUS = "N/A"
  • Removes duplicates using place.id
  • Formats relevant business information
• Error Handling:
  • Exponential backoff on API rate limits
  • Stops after 10 retry attempts
• Data Storage – Saves results to Google Sheets and tracks completed ZIP/subcategory combinations
• Notifications – Alerts via Telegram and WhatsApp (Rapiwa)

---

⚙ Requirements

• Google Maps API – Business lookup
• Google Sheets OAuth2 – Data storage
• Telegram Bot API – Notifications
• Rapiwa API – WhatsApp alerts

---

🛠 Step-by-Step Setup

1. Set Up Credentials in n8n

• Google Maps API → named "Google MAP"
• Google Sheets OAuth2 → named "Google Sheets"
• Rapiwa API → named "Rapiwa account 2"

2. Prepare Your Google Sheet

Create a Sheet with these tabs:

• zip → ZIP codes to process
• maps categories → Business categories/subcategories
• result → Where extracted business data is stored

Update workflow nodes with:

• Document ID of your Google Sheet
• Sheet IDs (gid values) for each tab

3. Customize the Workflow

• Limit node → Control ZIP codes processed per batch (default: 10)
• Retry settings → Max retry attempts (default: 10)
• Schedule node → Set preferred run frequency (default: hourly)

This creates a simple, scalable, and cost-efficient lead generation system.

---

🔗 Useful Links

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

---

💬 Support & Help

• WhatsApp: Chat Now
• Discord: SpaGreen Community
• Facebook Group: SpaGreen Support
• Website: spagreen.net
• Developer Portfolio: Codecanyon SpaGreen