Extract Google Maps business leads with Apify, GPT-4o-mini and Google Sheets

Go to Workflow
0 views
Built by SpaGreen Creative SpaGreen Creative
Created on June 05, 2026

Description

Who Is This For?
This workflow is designed for business analysts, market researchers, lead generation specialists, and sales teams who need to gather detailed business intelligence from Google Maps. It's particularly valuable for anyone conducting competitor analysis, building prospect lists, or researching local business landscapes.
What This Workflow Does
This workflow functions as an automated Google Maps data extraction and intelligence system that:
Searches for businesses on Google Maps based on a specific query and location
Extracts comprehensive data for each listing, including name, rating, address, phone, website, and reviews
Structures the raw data into a clean, usable format for analysis
Programmatically initiates the scraping process using a dedicated, cloud-based scraping tool
Monitors the scraping job until completion, ensuring all data is captured
Delivers the final dataset in a structured JSON format, ready for integration into CRMs, spreadsheets, or other applications

Key Features
On-Demand Data Extraction** – Can be triggered anytime to scrape fresh data from Google Maps
Comprehensive Data Points** – Captures a wide range of information including ratings, reviews, contact details, and URLs
Cloud-Powered Scraping** – Leverages a specialized, pre-built actor (crawler-google-places) from the Apify platform for reliable and efficient scraping
Automated Job Management** – Automatically starts, monitors, and waits for the scraping task to complete
Structured Output** – Delivers clean, structured JSON data that is easy to parse and use
Programmatic Control** – Manages the entire process through API calls, making it easy to integrate into other workflows

Requirements & Setup
Apify Account & API Token**: Required to access and run the Google Maps scraping actor.
Apify Actor ID**: The specific ID for the crawler-google-places actor (nwua9GuXXXXDL7ZDj).
Apify Task ID**: An optional pre-configured task (IldouXXXQalCKQpfO) for consistent scraping parameters.
Input Parameters**: You need to provide the searchString (e.g., "restaurants near Islamic University") and other scraping options.

Support & Help
WhatsApp**: Chat on WhatsApp
Discord**: SpaGreen Community
Facebook Group**: SpaGreen Support
Website**: https://spagreen.net
Developer Portfolio**: Codecanyon SpaGreen

Nodes Used (7)

Code
n8n-nodes-base.code
Google Sheets
n8n-nodes-base.googleSheets
HTTP Request
n8n-nodes-base.httpRequest
Microsoft Teams
n8n-nodes-base.microsoftTeams
OpenAI
@n8n/n8n-nodes-langchain.openAi
Slack
n8n-nodes-base.slack
Telegram
n8n-nodes-base.telegram