Home/ Templates/ Review Aggregator
📅 Last updated: June 2026
Reviews & Reputation Automation

Never Miss a Review — Aggregate, Score & Alert Automatically

Most small businesses check their reviews manually — or worse, miss them entirely. This template monitors Google, Yelp, and Facebook every 6 hours, AI-scores every review, and emails you the moment something needs attention.

73%
of customers read reviews before visiting One unanswered negative review can cost you dozens of customers.

What this template does

  • Runs every 6 hours on a schedule — no manual checking needed
  • Pulls new reviews from Google Business Profile, Yelp & Facebook simultaneously
  • AI (gpt-4o-mini) scores every review: Positive, Neutral, or Negative
  • Sends you an email alert the moment a negative review arrives
  • Email includes an AI-generated suggested reply — ready to copy and send
  • Logs every review to a Google Sheets dashboard with full metadata
  • Works 24/7 with zero intervention after initial setup
n8n Make.com
$47one-time
✦ No monthly fee — runs on your free n8n or Make.com account
Get the Template — $47 →
  • n8n workflow JSON file
  • Make.com blueprint JSON file
  • Plain-English setup guide (PDF)
  • Google Sheets dashboard template
  • Commercial licence included
Delivered instantly via Gumroad. Works with:
n8n Make.com
🛡️ Questions? Email support@peakautomations.online

How does the Review Aggregator work?

The workflow runs automatically on a 6-hour schedule. Here is exactly what happens each time it fires:

1

Schedule trigger fires every 6 hours

n8n or Make.com wakes the workflow automatically. No manual action required — it runs in the background 24 hours a day, 7 days a week.

2

Pulls reviews from all three platforms

Simultaneously queries your Google Business Profile API, Yelp Fusion API, and Facebook Graph API for any reviews posted since the last run.

3

AI scores every review for sentiment

Each review text is sent to OpenAI gpt-4o-mini, which returns a sentiment label (Positive / Neutral / Negative) and generates a suggested reply draft.

4

Logs everything to Google Sheets

Every review is appended to your dashboard with the platform, rating, text, sentiment score, date, and suggested reply — all searchable and filterable.

5

Sends alert email for negative reviews

If any Negative review is detected, a formatted email alert goes to your inbox immediately — with the review text and the AI-suggested reply included, ready to copy.

What's included in the download?

Workflow filesn8n JSON + Make.com blueprint — both included, use whichever platform you prefer
Setup guideStep-by-step PDF for non-technical users — connecting Google, Yelp, Facebook, OpenAI, Gmail, and Google Sheets credentials
Google Sheets templatePre-formatted dashboard with 11 columns, colour-coded sentiment rows, and filter dropdowns — copy with one click
Platformsn8n (self-hosted or cloud free tier) · Make.com (free tier)
APIs usedGoogle Business Profile · Yelp Fusion · Facebook Graph · OpenAI gpt-4o-mini · Gmail · Google Sheets
Setup time15–25 minutes
Ideal forLocal businesses: restaurants, salons, gyms, dental/medical, retail, hospitality
DeliveryInstant digital download via Gumroad
LicenceCommercial use — deploy for your own business

What customers say

★★★★★

Set it up in about 25 minutes. Next morning I had 3 new reviews in my sheet and one negative already flagged with a suggested reply. Saved me so much time every day.

MR
Marcus R.
Owner, HVAC Company
★★★★★

I had zero experience with n8n. The guide walked me through every step. Was live in 20 minutes and it's been running perfectly for 3 months — I barely think about reviews anymore.

DK
David K.
Restaurant Owner, 2 locations

Frequently asked questions

The template monitors Google Business Profile, Yelp, and Facebook simultaneously, pulling new reviews every 6 hours on a scheduled trigger.
No. The template includes a plain-English setup guide written for non-technical business owners. You connect your accounts through simple UI forms in n8n or Make.com — no code required.
The template comes in both n8n and Make.com formats. Both have free tiers that are more than sufficient for this workflow. n8n can also be self-hosted completely free.
OpenAI is pay-per-use. For a typical small business running this automation (checking ~100 reviews per month), the cost is under $1/month — it uses the efficient gpt-4o-mini model to keep costs minimal.
Yes. You pay $47 once and own the template forever. No subscription fees from Peak Automations. The automation platforms (n8n, Make.com) and most APIs have free tiers that cover typical small business usage.
Most customers are live in 15–25 minutes. The setup guide walks through every step — connecting Google, Yelp, Facebook, OpenAI, Gmail, and Google Sheets. If you get stuck, email support@peakautomations.online.

Start monitoring every review automatically — today.

$47 one-time. Download, follow the guide, and your automation is live in under 25 minutes.

Get the Template — $47 →
One-time payment · Instant download via Gumroad · No subscription