$5 · Support the community
Reputation & ReviewsFREE

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.

difficulty Advancedsetup 40 minresult You get a unified view of reviews and ratings across all locations, spotting problem sites fast.—
—
  1. 1

    Schedule the Pull

    Add a Schedule Trigger running daily.

  2. 2

    Fetch Reviews Per Location

    Add an HTTP Request node looping over all your location IDs to fetch recent reviews and ratings.

  3. 3

    Aggregate the Scores

    Add a Code node computing average rating, review count and recent trend per location.

  4. 4

    Update the Dashboard

    Add a Google Sheets node writing the per-location metrics for at-a-glance comparison.

  5. 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.

Related recipes
Reputation & ReviewsFREE
Googlen8nOpenAI
agent ready—

Draft On-Brand Replies to New Google Business Reviews With AI, Delivered to Slack

Each new Google Business review is summarised, its sentiment scored, and a ready-to-send reply is drafted by AI and dropped into Slack for a human to approve — turning review management from a chore into a one-click task.

n8nn8nGoogleGoogleOpenAIOpenAISlack
Intermediate · 40 min setup
Reputation & ReviewsFREE
WhatsAppn8nGoogle Sheets
agent ready—

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.

n8nn8nWhatsAppWhatsAppGoogle SheetsGoogle SheetsSlack
Intermediate · 55 min setup
Reputation & ReviewsFREE
TypeformGmailn8n
agent ready—

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.

n8nn8nTypeformTypeformGmailGmail
Intermediate · 35 min setup
Explore more like this
All Reputation & Reviews recipes →n8n Google Business Profile API automationsn8n Google Sheets automations
About this recipe. Recipes on FlowRecipesHub are written for business owners, not developers, and are tested before publishing — how recipes get made. Some ingredient links are affiliate links that cost you nothing — full disclosure.