Generate Business Leads from Google Maps & Places API to Google Sheets

Overview

This workflow automates the process of generating niche-specific business leads from Google Maps, leveraging the Google Places API and Google Sheets for seamless data collection and storage.

Who Is This For?

Business owners**, marketers, sales teams, or anyone needing to build targeted lead lists by business type and location quickly.

Main Use Cases

Building outreach lists for local marketing campaigns. Finding potential clients in a specific location and industry. Automating research for sales prospecting.

How It Works

Collect Inputs via Form:
Gather your business type (search term), target location, desired number of results, and Google Maps API key using a simple built-in form. Geocode Location:
The workflow automatically converts your location input into geographic coordinates. Search Businesses:
It utilizes the Google Places API to search for businesses that match your criteria within a 10-km radius of your location. Extract & Validate Data:
For each business found, it extracts key contact details (name, address, phone, website, etc.), validates for essential info, and automatically appends valid leads into your connected Google Sheet—ready for action.

Prerequisites

Google account connected to Google Sheets. Active Google Maps API key. Your target Google Sheet is set up to receive leads.

Setup Steps

Connect your Google Sheets account inside n8n. Obtain a Google Maps API key (usually takes a few minutes from the Google Cloud Console). Configure the workflow:
Fill out the form inside the workflow with your business type, location, number of results, and your API key. Run the workflow and watch qualified leads flow into your Google Sheet in real-time.

Customization Options

Adjust the search radius or result count to match your needs. Extend extracted fields or add filters for advanced lead qualification. Change the Google Sheet structure as per your business process.

Example Output

Each row in your sheet contains: Business Name Address Phone Website Google Maps URL Ratings & Reviews Business Types Search Query & Location Scraped At timestamp

> Tip:
> For more details and advanced customizations, refer to the in-workflow sticky notes.