Scrape Brazil Google Maps Leads with Apify + Google Sheets (n8n Workflow)

Scrape Brazil Google Maps leads automatically—Apify + n8n → Google Sheets

This on-demand n8n workflow scrapes Google Maps leads in Brazil using Apify, enriches results with available CNPJ details, and then appends each lead into Google Sheets with business contact and profile information.

What this workflow does

• Runs on demand (manually triggered) so you control when lead collection starts.
• Lets you configure the Google Maps search term (termo), the Brazilian location (local), and max results (max_resultados).
• Uses Apify Actor paulovitor18~gmaps-brasil-leads to scrape Google Maps results, hydrate place details, and enrich leads with CNPJ, legal name, and `registration status` when available.
• Appends one row per lead into Google Sheets, capturing fields such as name, category, address, CEP, state, phone, website, email, Instagram, rating, reviews, Maps URL, and Place ID.
• Supports customization to improve speed/cost: set enriquecer_cnpj to false to run faster without CNPJ enrichment.
• Includes an option to use “Append or update” behavior by matching on Place ID.

Use cases

• Build targeted lead lists for a specific niche (e.g., “law firms”, “dentists”, “plumbers”) in a Brazilian city/region.
• Continuously grow a sales prospecting spreadsheet with fresh Google Maps business contacts.
• SaaS operators and automation engineers who need an n8n Google Sheets lead pipeline fed by Apify data.

Technical details

• Nodes / tech stack: Manual Trigger, set, Sticky Note, Google Sheets, Apify (apifyn8n-nodes-apify).
• Apify: Requires an Apify account and API token; the Actor is pay-per-result (e.g., 40 leads cost a few cents, per the source guidance).
• Google Sheets: OAuth2 credential, configured with target spreadsheet (document ID) and worksheet (sheet name).

Get started by adding your Apify API token credential in n8n, selecting the Google Sheet to append into, and updating termo, local, and max_resultados for your market.