See llms.txt for all machine-readable content.

Back to Templates

Find Google Maps business leads with Apify and Google Sheets

Created by

Created by: Bolva Frok || bolvein-firex
Bolva Frok

Last update

Last update 8 hours ago

Categories

Quick overview

This workflow runs daily, uses the Apify Google Maps Business Lead & Email Finder Actor to collect business leads (including emails when available), cleans and deduplicates the results, and optionally appends the final rows to a Google Sheets spreadsheet.

How it works

  1. Runs every day at 08:00 on a schedule trigger.
  2. Builds the Apify Actor input, including Google Maps search queries and lead limits.
  3. Calls the Apify API to run the Google Maps Business Lead & Email Finder Actor and returns the dataset items.
  4. Removes empty fields, deduplicates businesses by placeId, and adds source and scrape timestamp metadata.
  5. Outputs the cleaned businesses and, if enabled, appends one row per business to Google Sheets.

Setup

  1. Create an Apify account and add an HTTP Query Auth credential in n8n with parameter name token set to your Apify API token.
  2. Update the Actor input in the search configuration (for example searchQueries, max_results, extractEmails, and onlySaveResults) to match the leads you want to collect.
  3. (Optional) Add a Google Sheets credential, set the target spreadsheet ID and sheet name, and enable the Google Sheets append step.

Requirements

  • An Apify account and API token (the free plan includes monthly usage credit). Actor usage is billed to your Apify account; see the Actor Pricing tab. Optional: a Google Sheets credential.