Skip to content
GraviPointThe Centre of Productivity
  • AI AgentNew
  • Pricing
  • Community
Log inGet started free
TemplatesSales & CRMAccounts & CustomersOnline Reviews and Reputation Tracker

SpreadsheetAccounts & CustomersFree

Online Reviews and Reputation Tracker

Log reviews from every platform, track average rating and sentiment, and make sure each one gets a reply on time.

Shown with sample data

Colour

Online Reviews and Reputation Tracker

Log reviews from every platform, track average rating and sentiment, and make sure each one gets a reply on time.

Average rating
3.7
Out of 5
Reviews logged
9
Response rate
56%
Average response time (days)
1.2
Overdue replies
3
Negative share
22%
Average rating by platform
  • Amazon4.5
  • Google4
  • Trustpilot4
  • Yelp3
  • Facebook1
Reviews by platform
  • Google333%
  • Trustpilot222%
  • Amazon222%
  • Yelp111%
  • Facebook111%

How to use it

  1. 1Set your response-time target in days on the Settings sheet.
  2. 2Check each platform daily or weekly and log new reviews with rating and a one-line summary.
  3. 3Reply to every review, starting with Overdue and negative ones, then enter the date you responded.
  4. 4Read the By platform sheet monthly to see where ratings are rising or falling.
  5. 5Note recurring themes in negative reviews and pass them to the team that can fix them.

In this workbook

  • About
  • What’s included
  • How to use
  • Questions
  • Related resources

About this template

Reviews shape buying decisions and local search rankings, and how you respond is public. Log each review with platform, location or product, rating and summary; the tracker classifies sentiment, measures response time against your target from the Settings sheet and flags reviews still waiting for a reply. A By platform sheet shows review volume, average rating and response rate for Google, Trustpilot, Amazon and the rest.

Who it’s for

  • Businesses managing reviews on several sites
  • Multi-location brands comparing branches
  • Monthly reputation reporting
  • Making sure negative reviews are answered quickly

What’s included

  • Reviews sheet: One row per review.
  • By platform sheet: Volume, rating and response rate per platform.
  • Settings sheet: Your response target.

How to use it

  1. 1Set your response-time target in days on the Settings sheet.
  2. 2Check each platform daily or weekly and log new reviews with rating and a one-line summary.
  3. 3Reply to every review, starting with Overdue and negative ones, then enter the date you responded.
  4. 4Read the By platform sheet monthly to see where ratings are rising or falling.
  5. 5Note recurring themes in negative reviews and pass them to the team that can fix them.

Tips

  • Reply to negative reviews within a day or two: acknowledge, apologise where appropriate, take the detail offline and fix the issue.
  • Thank positive reviewers by name and mention something specific; generic replies look automated.
  • Never offer incentives for positive reviews or post fake ones. Platform rules and consumer protection laws (such as the FTC’s rule on fake reviews in the US) prohibit it.
  • Ask every happy customer for a review; a steady flow of recent reviews matters as much as the average.

Questions

Should I respond to every online review?

Yes, ideally. Responding shows prospective customers you listen, and Google notes that replying to reviews can improve your local presence. Prioritise negative and detailed reviews.

How quickly should I respond to a negative review?

Within 24–48 hours. Set your own target on the Settings sheet; the tracker flags anything past it.

How do I calculate my average rating?

Add up all star ratings and divide by the number of reviews. The tracker does this overall and per platform.

Related searchesonline review trackerreputation management spreadsheetgoogle reviews trackerreview response trackercustomer reviews logaverage rating calculator

Details

Format
Spreadsheet
Category
Accounts & Customers
Sheets
3
Setup
10 min
Level
Beginner
Price
Free

Download a copy

Downloads need a free account.

SpreadsheetAccounts & CustomersFree

Online Reviews and Reputation Tracker

Log reviews from every platform, track average rating and sentiment, and make sure each one gets a reply on time.

A free account keeps your copy safe so you can come back to it. Have one? Log in

Download a copy

Downloads need a free account.

Details

Format
Spreadsheet
Category
Accounts & Customers
Sheets
3
Setup
10 min
Level
Beginner
Price
Free

Your copy is private to you.

More accounts & customers templates

View all
Customer Health Scorecard2 sheets

Accounts

6

At risk

2

Revenue at risk

$134,000

Annual revenue by segment
$204k
$116k
$32k
EnterpriseMid-marketSmall business
SpreadsheetAccounts & Customers

Customer Health Scorecard

Score each account on usage, support, relationship and payments to spot churn risk early.

10 min setupPreview
RFM Customer Segmentation3 sheets

Customers

14

Champions’ share of revenue

48%

Revenue from at-risk customers

$4,600

ABCD
1CustomerLast orderOrdersTotal spend
2Amelia TurnerNov 914$2,860
3Noah BennettOct 287$1,240
4Isla FraserNov 121$85.00
5Leo HughesApr 211$2,310
Customers
SpreadsheetAccounts & Customers

RFM Customer Segmentation

Score every customer on recency, frequency and spend, label them Champions to Lost and see where your revenue is at risk.

10 min setupPreview
Customer Contact List3 sheets

Customers

9

Lifetime revenue

$187,400

Revenue at risk

$37,100

ABCD
1CustomerContact personCityOwner
2Northwind RetailSara AliSeattleDana
3Blue Harbor CafeHana KimPortlandMia
4Oak & Pine StudioWill GrantDenverLeo
5Delta FoodsBen ColeChicagoLeo
Customers
SpreadsheetAccounts & Customers

Customer Contact List

A light CRM: every customer with owner, value, order history and an automatic segment, health and next contact.

10 min setupPreview

Practical guides and new resources, monthly.

One short email with new templates, calculators and how-tos. Unsubscribe any time.

GraviPointThe Centre of Productivity

Find the right resource. Make it work for you. Get things done with spreadsheets, documents, forms and calculators you can use right in your browser.

support@gravipoint.com
  • @gravipoint
  • @GraviPoint
  • GraviPoint
  • 𝕏@gravipoint

Templates

  • All templates
  • Budgets & expenses
  • Invoices & billing
  • Project management
  • HR & people
  • Inventory & stock
  • Sales & CRM
  • Financial calculators

Popular

  • Monthly budget
  • Invoice
  • Employee shift schedule
  • Weekly timesheet
  • Project plan & Gantt chart
  • Inventory tracker
  • Expense report
  • Mortgage calculator

Solutions

  • Individuals & households
  • Freelancers & consultants
  • Founders & startups
  • Small business owners
  • Teams & operations
  • Students & educators

Company

  • About
  • Features
  • Pricing
  • Community
  • Journal
  • Contact
© 2026 GraviPoint. All rights reserved.
  • Privacy
  • Terms
  • Help centre
  • FAQ