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: