Extract leads from Google Maps into Google Sheets using the Places API

Who is this for

This workflow is designed for sales teams, marketing professionals, and business developers who want to automate lead generation. It is ideal for budget-conscious individuals or small businesses looking to collect structured contact information from Google Maps without manual searching or relying on third-party middleware providers.

How it works

The workflow operates in two modes: Manual and Automated.

Manual Mode: Submit a search query via an n8n Form node to trigger the workflow instantly. Automated Mode: A Schedule trigger processes pending queries from a Google Sheets spreadsheet.

Once triggered, the workflow uses the Places API (New) to find businesses matching the query. It then maps the data into structured fields (name, address, phone, and website) and saves them as leads in a separate sheet. If triggered automatically, it marks the original query as "scraped" to prevent reprocessing. Duplicate leads are prevented via a deduplication mechanism based on the Google Place ID.

Requirements

To use this workflow, you will need: