Get Started
Back to Templates

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

Created by

Created by: Jaures NYA || jauresnya

Jaures NYA

Last update

Last update 16 hours ago

Categories

Share

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