Google Business Profile Review Analyzer

This workflow is a weekly Google Business Profile review report for local businesses and agencies. Every Monday, it pulls your latest Google reviews, uses AI to run sentiment analysis and theme detection, then emails a polished report you can export as a PDF and share with your team or clients.

What this workflow does

Runs every Monday (automatic weekly schedule)
Fetches Google Business Profile reviews (per location)
Analyzes reviews with AI:
- sentiment (positive / neutral / negative)
- recurring themes & keywords (service, staff, pricing, wait time, cleanliness, etc.)
- common praise vs. recurring complaints
Highlights top & worst reviews (includes reviewer profile image when available)
Drafts suggested public replies for negative reviews
Emails the weekly report to one or more recipients

What the PDF report includes

Coverage summary
- location(s) included
- time range of reviews analyzed
- total reviews, average rating, rating breakdown (5★ → 1★)
Executive summary
- one-line health check of your reputation this week
- top 3 things customers loved
- top 3 issues to address
Sentiment & themes
- positive themes (with counts + example quotes)
- negative themes (with counts + example quotes)
Top reviews (highlights)
- 3–5 best reviews that represent your strengths
- reviewer name, rating, date, short excerpt
- reviewer image (if provided by Google)
Worst reviews (needs attention)
- 3–5 most critical reviews with the main issue called out
- suggested public reply for each (copy-paste ready)
Urgent reviews (respond ASAP)
- all 1–2★ reviews and strongly negative feedback
- why it matters + suggested reply
Action plan
- quick wins for the next 7 days
- longer-term improvements for the next 30 days
Keyword watchlist
- important phrases to monitor (e.g., “rude”, “late”, “refund”, “dirty”)
- why they matter for reputation and local SEO
Notes / data limitations
- missing fields, empty reviews, or anything that could affect accuracy