Scrape Google Maps business leads with verified emails to Google Sheets via Apify

Description

Quick overview
This workflow manually runs an Apify Google Maps scraping actor to collect business leads for a given location and category, keeps only entries with verified (ACTIVE) emails, and appends the cleaned lead data to a Google Sheets spreadsheet.

How it works
Starts when you manually execute the workflow in n8n.
Sets the search location, business category (search term), and maximum number of Google Maps results to retrieve.
Calls the Apify Business Monster Google Maps Scraper actor via HTTP to fetch matching businesses and wait for the dataset results.
Splits the returned dataset into one item per business.
Filters the results to keep only businesses whose email verification status is marked ACTIVE.
Formats each business into a single, flattened row of key fields (name, category, contact details, socials, tracking flags, and Maps URL).
Appends the rows to a selected Google Sheets document and worksheet.

Setup
Create an Apify account, get an API token, and set it as the APIFY_TOKEN environment variable (or replace the token placeholder in the Apify request URL).
Connect Google Sheets credentials in n8n.
Select the target Google Sheets document and sheet tab in the Google Sheets append step.
Update the search settings (location, search term, and maxResults) to match your lead criteria, and disable the email-status filter if you want results without verified emails.

Requirements
An Apify account and API token — new accounts include free platform credit
A Google account with access to the target spreadsheet

Customization
Disable the "Keep only verified emails" filter to keep every business, with or without an email
Edit "Build spreadsheet rows" to pick from the 100+ fields the Actor returns per business
Swap the manual trigger for a Schedule Trigger to run it automatically
Filter on has_meta_pixel and has_google_analytics being false to find businesses with no tracked paid marketing