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