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