Generate and enrich Google Maps leads with Apify, Hunter and Google Sheets

How it works
This workflow automatically scrapes business leads from Google Maps on a daily schedule and ensures only high-quality, unique leads are processed. New businesses are cleaned, validated, and deduplicated against an existing Google Sheets database before enrichment begins. Verified emails are enriched using domain-based lookup and classified by confidence. Finally, the workflow sends a detailed email report and stores all enriched leads in Google Sheets for ongoing tracking.

Step-by-step
Scrape & deduplicate leads**
Schedule Trigger – Runs the workflow automatically at a fixed time each day.
Google Maps Scraper – Scrapes business listings based on search query and location.
Format & Validate Data – Cleans fields, normalizes data, and scores lead quality.
Check Existing Leads – Reads existing records from Google Sheets.
Deduplicate Leads – Removes businesses already stored in the database.
Format Error Data – Captures and structures scraper or processing errors.
Error Notification – Sends an email alert if the workflow fails.

Enrich emails**
Has New Leads? – Checks whether any new unique leads remain after deduplication.
Batch for AI Processing – Splits leads into small batches to control API usage.
HTTP Request (Hunter) – Performs domain search to find professional emails.
Merge & Validate Results – Selects the best email and assigns confidence levels.
No New Leads Notification – Sends a message when no new leads are found.

Report & store results**
High Confidence Leads? – Separates outreach-ready leads from lower-confidence ones.
Build Email Report – Generates a detailed HTML report with lead analytics.
Send Email Report – Emails the daily lead summary to stakeholders.
Prepare Sheet Data – Formats enriched leads for storage.
Save to Google Sheets – Appends or updates leads in the sheet.
Merge – Synchronizes parallel execution paths.
Wait – Controls workflow execution flow and batching cycles.

Why use this?
Fully automates Google Maps lead generation and enrichment
Prevents duplicate and low-quality leads from entering your database
Enriches leads with verified emails and confidence scoring
Delivers clear daily reports for faster outreach decisions
Maintains a centralized, continuously updated lead system