Aggregate Reviews Across All Your Locations Into One Dashboard
See every location's reputation at once — pull reviews from all your Google Business locations into a single dashboard with per-location scores.
- 1
Schedule the Pull
Add a
Schedule Triggerrunning daily. - 2
Fetch Reviews Per Location
Add an
HTTP Requestnode looping over all your location IDs to fetch recent reviews and ratings. - 3
Aggregate the Scores
Add a
Codenode computing average rating, review count and recent trend per location. - 4
Update the Dashboard
Add a
Google Sheetsnode writing the per-location metrics for at-a-glance comparison. - 5
Activate and Test
Activate the workflow and run it once. Confirm each location's numbers match its profile.
Frequently asked questions
Can I alert on a dropping location?
Yes — flag any location whose rating falls below a threshold so managers can intervene.
Does it handle new locations?
Pull the location list dynamically so newly added sites are included automatically.
Run a WhatsApp NPS Survey and Log Scores to Google Sheets
An n8n workflow that captures customers' WhatsApp replies to a 0–10 'how likely are you to recommend us' survey, logs the score and any comment to Google Sheets, and routes unhappy responders to your team — turning WhatsApp into a lightweight, high-response-rate NPS channel.
Free recipe
Segment NPS Respondents and Trigger the Right Follow-Up Automatically
Route every NPS response into promoter, passive, or detractor buckets and fire a tailored follow-up — a review ask for promoters, a check-in for detractors.
Free recipeGet a Daily Brand Sentiment Report From Social Mentions
Understand how people feel about your brand — collect daily social mentions, score sentiment with AI, and get a report highlighting shifts and hot topics.