Latenode
Google sheets
HTTP Request
JavaScript

Automate lead generation from Google Maps business listings

This n8n workflow automates the process of identifying and extracting contact details and lead information for businesses listed on Google Maps. Users can specify a list of ZIP codes and subcategories to search, and the workflow will leverage the Google Maps API to retrieve the relevant location data.

The results are then filtered, de-duplicated, and organized into a structured Google Sheets spreadsheet, providing a streamlined lead generation system. The workflow includes built-in exponential backoff retries to handle Google Maps API rate limits, ensuring reliable data collection even under high usage conditions.

Updated May 8, 2026Est. run: 23sEst. cost: $0.0014
How Latenode estimates time and cost

Latenode bills workflow runs in credits: 1 credit = 30 seconds of processing. Minimum charge per run depends on your plan. Plug-and-Play (PnP) AI nodes are billed separately—each PnP token is $1 USD, charged pay-as-you-go at vendor cost plus a small processing fee, with no API keys required.

Full pricing — how credits work →
Scraping & data collection

Workflow preview

What this template does

  • Retrieves business location data from Google Maps based on specified ZIP codes and subcategories.
  • Extracts contact details and lead information for the identified businesses.
  • Filters and deduplicates the retrieved data to ensure a clean and organized dataset.
  • Exports the processed data into a structured Google Sheets spreadsheet.
  • Implements exponential backoff retries to handle Google Maps API rate limits.

How it works

1
Trigger

Scheduled Workflow Trigger

The workflow is triggered on a 15-minute interval to automate the regular extraction of business contact details and lead information from Google Maps.

2
Action

Configure Google Sheets

The workflow is configured to use a Google Sheets spreadsheet as the source for the list of ZIP codes and subcategories to search for on Google Maps.

3
Action

Get Zip Codes

The workflow retrieves the list of ZIP codes to search from the specified Google Sheets spreadsheet.

4
Logic

Loop through Zip Codes

The workflow enters a loop to process each ZIP code from the list, retrieving the associated subcategories from the Google Sheets spreadsheet for each ZIP code.

5
Action

Get Subcategories

For the current ZIP code, the workflow retrieves the list of subcategories to search for from the Google Sheets spreadsheet.

6
Logic

Loop through Subcategories

The workflow enters a nested loop to process each subcategory for the current ZIP code, calling the Google Maps API to retrieve the relevant business location data.

7
Action

Call Google Maps API

The workflow calls the Google Maps API to retrieve the business location data for the current ZIP code and subcategory combination.

8
Logic

Filter Empty Responses

The workflow filters out any records that did not return any data from the Google Maps API call, ensuring only valid data is processed further.

9
Logic

Remove Duplicates

The workflow de-duplicates the retrieved data by the place ID, ensuring that each unique business is only included once in the final output.

10
Action

Add to Google Sheets

The workflow stores the retrieved and de-duplicated business contact details and lead information in the specified Google Sheets spreadsheet.

11
Action

Update Status

The workflow marks the current ZIP code and subcategory combination as processed in the Google Sheets spreadsheet, ensuring that the same data is not retrieved again in subsequent runs.

12
Logic

Exponential Backoff

The workflow introduces a delay between API requests to handle the Google Maps API rate limits, using an exponential backoff strategy to ensure reliable data collection even under high usage conditions.

Setup guide

1

Add Google Maps API Credential

1. In the Latenode Credentials panel, add a new credential for the Google Maps API. 2. Enter your Google Maps API key or OAuth2 credentials. 3. Save the credential, then select it when configuring the Google Maps API node in the workflow builder.

2

Configure Google Sheets Integration

1. In the Latenode Credentials panel, add a new credential for Google Sheets. 2. Authenticate with your Google account to grant access to the Google Sheets API. 3. In the Google Sheets node settings, select the Google Sheets credential and specify the spreadsheet URL and sheet names to use.

3

Set Workflow Input Parameters

1. In the workflow builder, locate the 'Get Zip Codes from Google Sheets' node. 2. In the node settings, map the 'Zip Codes' input to a cell range in your Google Sheets spreadsheet. 3. Locate the 'Get Subcategory from Google Sheets' node and map the 'Subcategories' input to another cell range in your Google Sheets.

4

Configure Google Maps API Node

1. In the workflow builder, locate the 'Call Google Maps API' node. 2. In the node settings, select the Google Maps API credential added earlier. 3. Specify the required parameters, such as the search radius, location types, and any other relevant settings for your use case.

5

Map Output to Google Sheets

1. In the workflow builder, locate the 'Add retrieved data to Google Sheets' node. 2. In the node settings, map the output fields from the Google Maps API response to the corresponding columns in your Google Sheets spreadsheet. 3. Adjust any formatting or additional processing steps as needed to organize the data in your spreadsheet.

Requirements

Google Maps API key with Places API enabled
Google Cloud Firestore or Google Sheets account with write access
Google Cloud Platform project with billing enabled
n8n workspace with JavaScript and Google Sheets nodes installed

FAQ

Common questions about this template

Each run uses credits on your Latenode plan. We charge for processing time (1 credit = 30 seconds). Your actual cost depends on your plan and how long the run takes. See pricing plans for plans and how credits work.
Contact support →

More templates

You might also like

Browse all templates →
Scraping & data collection

Automatically Sync Google Maps Business Data to a Spreadsheet

This automation workflow allows users to efficiently scrape business data from Google Maps, including names, contact details, and reviews, and export the structured information into a spreadsheet or database. The workflow uses the SerpAPI service to retrieve Google Maps search results, which are then transformed and appended to a Google Sheet. This enables users to generate leads, conduct market analysis, and gain valuable insights from the collected data in a cost-effective and scalable manner.

10s$0.0006
Scraping & data collection

Scrape Zillow property data and sync to Google Sheets automatically

This Latenode automation extracts real estate listing details from Zillow and automatically populates a Google Sheets spreadsheet with the property data. It leverages the Scrape.do web scraping API to bypass anti-bot protections and fetch the full HTML of Zillow listings, then parses key information like price, address, days on Zillow, and Zestimate, and saves the structured results into a Google Sheet. This solution is designed for real estate professionals, investors, and market analysts who need to collect property data at scale without manual effort, enabling better market research, portfolio tracking, and lead generation.

9s$0.0006
Scraping & data collection

Automatically scrape and store Booking.com hotel data

This workflow automates the search and extraction of hotel data from Booking.com, triggered by a chat message. It uses a combination of web scraping with Bright Data's Web Scraper and AI-powered data processing with OpenRouter to deliver a concise, human-friendly list of hotels, including the title, address, original price, and final price. The final output is a clean and formatted report, making it a valuable tool for travelers, event planners, and business professionals who need to quickly find accommodation.

12s$0.0007