Generate verified local leads from Google Maps with Apify and Google Sheets

Quick Overview

This workflow uses Apify to scrape Google Maps business leads, verify their emails with a live SMTP check, and append only safe-to-send contacts to a Google Sheets spreadsheet.

How it works

1. Starts when you manually run the workflow.
2. Calls the Apify Google Maps Lead Finder actor to search Google Maps for the configured queries and enrich results with email addresses.
3. Filters the results to keep only leads that include a non-empty primary email address.
4. Sends each primary email to the Apify Email Verifier actor to validate deliverability and return a safe-to-send flag and verification details.
5. Combines the original lead data with the corresponding email verification result.
6. Filters out any leads that are not marked safe to send.
7. Appends the remaining verified leads to a Google Sheets tab with business, contact, and email verification fields.

Setup

1. Create an Apify personal API token and configure an HTTP Header Auth credential (Header name Authorization, value Bearer <YOUR_APIFY_TOKEN>) for both Apify HTTP requests.
2. Connect Google Sheets OAuth2 credentials and select your target spreadsheet and sheet tab in the append step.
3. Update the Apify Lead Finder request body (for example queries, resultsDepth, and locationCode) to match your target niche and location.