Generate local business leads with Google Places API & website email scraping

Description

Purpose & Audience
This workflow automates the process of finding and collecting contact information for local businesses in any city or region. Built entirely with free-tier APIs, it eliminates the need for expensive scraping services while delivering professional-quality lead generation results.
Perfect for agencies, freelancers, sales teams, and entrepreneurs who need to build targeted prospect lists without breaking the bank or dealing with complex scraping tools.

What It Does
This comprehensive automation workflow:
Searches Google Places for businesses by type and location (restaurants, gyms, salons, etc.)
Retrieves up to 60 businesses per city using built-in pagination across 3 pages
Extracts complete business details: name, address, phone, website, rating, and description
Scrapes business websites to find email addresses automatically
Handles edge cases gracefully: businesses without websites, failed scrapes, or missing data
Batches API requests with intelligent rate limiting to respect Google's quotas
Makes clean CSV files available for download with all collected data ready for outreach
(Optional) Sends results/csv via email automatically when scraping completes

Who Is It For?
Ideal Users:
Marketing Agencies building prospect lists for local business campaigns
Sales Teams targeting specific industries in multiple cities
Freelancers offering services to local businesses (web design, SEO, consulting)
Entrepreneurs researching competitors or potential partners
Recruiters finding company contact information
Event Organizers building vendor or sponsor lists

Use Cases:
Build email lists for cold outreach campaigns
Research local market competitors
Find potential clients in specific industries
Gather vendor contact information
Create business directories
Market research and analysis

Expected Results
Per Search:
60 businesses maximum (with pagination)
70-85% will have websites
40-60% websites will contain email addresses
Processing time: ~5-10 minutes per city/search

Monthly Capacity/Quota (Free Tier):
Places API: 150 requests per day ( = ~5,000 per month) to stay within the free tier
Places API (New): 300 autocomplete requests per day ( = 10,000 per month), 300 GetPlace requests per day ( = 10,000 per month)

Key Features:
✅ Form-based input for easy use (no coding required)
✅ Pagination support for maximum results (60 per search)
✅ Smart email extraction with false-positive filtering
✅ Fallback handling for businesses without websites
✅ Rate limiting to stay within free API tiers (see the Quota for awareness)
✅ Batch processing for efficient execution
✅ CSV export for immediate use in CRMs