Scrape & Summarize Google Maps Businesses with APIFY + GPT-4O to Sheets

This workflow automates the process of scraping local business listings from Google Maps and generating clean, AI-powered summaries for each one — using Apify (community node) and OpenAI’s GPT-4o.

All results are then saved automatically into Google Sheets, ready for lead generation, enrichment, or outreach.

What it does This workflow saves hours of manual research by automatically:

Scraping structured business data from Google Maps (name, category, address, phone, website, etc.)

Creating natural-language summaries for each business using GPT-4o

Storing everything into Google Sheets — perfectly formatted for outreach or CRM import

Who’s it for

This automation is ideal for:

Lead generators and sales teams building B2B lists from local businesses

Freelancers and agencies prospecting new clients in specific cities or industries

Recruiters or marketers looking to enrich business data for campaigns

Automation enthusiasts who want to summarize and structure raw scraped data — without writing a single line of code

How it works

Trigger: The workflow starts manually via the Execute Workflow trigger (ideal for testing or batch runs).

Scrape: It uses an Apify actor to scrape Google Maps search results and collect structured business info (name, category, address, phone, website, Google Maps URL...).

Fetch Data: The dataset is retrieved from Apify using the actor's dataset ID, and each business is loaded for processing.

Deduplicate: Removes duplicate business listings to keep your database clean.

Loop Over: Iterates over each business to generate a clean summary, one at a time.

Generate Summary: Sends the business data to OpenAI to generate a human-readable paragraph (including name, category, address, city, phone, and Google Maps link).

Store: Appends the summarized info into a Google Sheet — your final lead database.

Pause for rate limit: Adds a short delay (optional) to control flow or avoid rate limits.

Customization Tips

Change the Apify search query to target different cities, industries, or keywords.

Adjust the OpenAI prompt to include tone, length, or focus areas (e.g., add business highlights).

Add filters (e.g., add-on: reviews, add-on: images, etc.).

Setup Guide Apify Setup

Use a Google Maps scraping actor in Apify.

Copy your Actor ID and Token — add them to your Apify node in n8n.

Note your Dataset ID (where results are stored).

OpenAI Setup

Add your OpenAI API key to the Generate Summary node.

The model gpt-4o is recommended for best quality/cost balance.

Google Sheets Setup

Connect your Google account.

How to use

Set up your Apify actor for Google Maps scraping (or use a prebuilt one).

Connect your OpenAI API key to the Message node (company summary).

Connect your Google Sheets account and select the target sheet.

Run the workflow → it will:

1 Scrape business data

2 Clean and summarize each one

3 Save everything to your spreadsheet.

Requirements

✅ A working Apify actor that scrapes Google Maps listings

✅ An OpenAI account (GPT-4) with API access

✅ A Google Sheet for storing the summarized results

❓ Need help

Contact me for consulting and support: LinkedIn / YouTube / Skool