Trustpilot volume tracks order volume. That makes a live sheet of your Trustpilot reviews an operations instrument, not a reputation report: one row per review, newest at the top, kept in sync every thirty minutes.
Set up in under five minutes • No demo required
Ashcroft Home · Trustpilot reviews
Synced 6 min ago
| Row | A | E | H | J |
|---|---|---|---|---|
| 1 | Review ID | Overall | Score | Review Date |
| 2 | tp_8f31c2 | Sofa cover fabric is heavier than the photos suggest and it fits our two seater exactly. | 5 | 2026-09-07 14:12 |
| 3 | tp_7d0a91 | Courier left the parcel on the step in heavy rain, the cushions were soaked, I have asked for a refund. | 1 | 2026-09-07 11:48 |
| 4 | tp_4b6e5c | Die Lampe war zwei Tage nach der Bestellung da und war gut verpackt. | 5 | 2026-09-07 09:31 |
| 5 | tp_2c9f84 | Rug is the exact colour shown on the site. The return label was not in the box. | 4 | 2026-09-06 18:07 |
| 6 | tp_e05a17 | Le colis est arrivé neuf jours après la date annoncée, sans aucun message. | 2 | 2026-09-06 15:22 |
| 7 | tp_9a3d60 | The mirror arrived cracked and they posted a replacement the same day without an argument. | 5 | 2026-09-05 20:44 |
Trustpilot invites your customers after they buy. That is what its Automatic Feedback Service is, an email a few days after each order, so your review count follows your order count far more closely than it follows anything marketing does. A raw count of reviews tells you how busy you were. Reviews divided by orders tells you whether the operation kept up.
Paste the month's order total into a column beside the sheet and the rest is one formula: reviews per hundred orders, and the share of them at one or two stars. The first holds steady while the business runs normally. The second is the alarm. When it climbs from six percent to fourteen in a month where volume barely moved, something broke at the courier or in the warehouse, not in your advertising.
The sheet keeps the whole history, so the pivot has a baseline. Six months of a flat ratio is what makes the seventh month legible. A dashboard that starts the day you buy it cannot tell you what normal looked like.
Trustpilot reviews
| Row | A | B | C | D | E |
|---|---|---|---|---|---|
| 1 | Month | Reviews | Orders | Per 100 orders | 1 to 2 star |
| 2 | Apr 2026 | 214 | 7,180 | 2.98 | 6% |
| 3 | May 2026 | 232 | 7,640 | 3.04 | 5% |
| 4 | Jun 2026 | 208 | 7,020 | 2.96 | 6% |
| 5 | Jul 2026 | 241 | 8,110 | 2.97 | 7% |
| 6 | Aug 2026 | 236 | 7,890 | 2.99 | 14% |
| 7 | Sep 2026 to 7 Sep | 61 | 2,040 | 2.99 | 13% |
Column C is the one you paste in. Reviewflowz does not sync order counts.
Everyone knows the courier is a problem, because someone remembers a review that said so. Memory keeps the vivid review and drops the count. A sheet keeps the count.
The full review text sits in column E and its date in column J, so one COUNTIFS counts every review that mentioned a refund this month, and the same formula dragged across gives you the six months before it. Nineteen in August against four or five in every month before is a finding you can hand to whoever owns refunds, with the rows underneath it.
Reviewflowz also fills a Tags column on every row as it arrives, worked out from what the review means rather than which words it uses, so a French review about the livraison lands under the same tag as an English one about delivery. Pivot on the tag, not on a word you had to guess.
It runs over the whole history, not just the reviews since you started counting. Seed the sheet with your past reviews and a theme you first noticed in September traces back to the month it began.
| Row | E | Z |
|---|---|---|
| 1 | Overall | Tags |
| 2 | La livraison a pris neuf jours et personne n'a répondu à mes messages. | Delivery |
| 3 | Courier left the parcel in the rain and it took a week to get a refund. | Delivery Refund |
Your TrustScore is not a lifetime average. Trustpilot weights recent reviews more heavily, adds seven neutral 3.5-star reviews to every calculation so a new profile starts balanced, and, below ten thousand reviews, recalculates the moment a new one posts. A bad month moves the number in a way a bad year three years ago no longer can.
So the average worth watching is the recent one, and in a sheet that is one formula. Score is column H and the review date is column J: AVERAGEIFS over the last ninety days is the number Trustpilot is reacting to, and the same formula over thirty days is your early warning.
Put both next to the lifetime average and the gap is the whole conversation. A 4.6 for all time, a 4.35 for the quarter and a 4.1 for the last thirty days: the public number is about to follow the last of those, and the rows underneath say why.
Trustpilot shows you the score. It does not show you the window. This does, for as many windows as you care to type.
4.6 is history. 4.1 is what Trustpilot weights now.
Trustpilot Business will export your reviews. It is a button, a date-range dialog and a person who has to remember to press it, and service reviews and product reviews come out as two separate files. Whoever runs it is the reason the sheet is right, and the week they are away is the week it stops being.
Reviewflowz creates the spreadsheet in your Google Drive, writes the header row, and keeps it in sync from then on. New reviews are inserted at the top, newest first. An edited review updates its own row. One row per review, keyed on the review ID in column A, so nothing lands twice.
The sync writes every thirty minutes. A Trustpilot profile you add by its URL is checked a few times a day; connect it through your Trustpilot Business API and it is checked every fifteen minutes.
Seed it with your past reviews the moment it is connected and the history is there on day one. Reviewflowz asks for access to the one file it created and nothing else in your Drive.
service-reviews-2026-08-01-to-2026-08-31.csv
product-reviews-2026-08-01-to-2026-08-31.csv
A date range dialog, two files, and somebody who has to remember.
4 new rows inserted at row 2
Newest Trustpilot review first
Row 47 updated in place
Reviewer edited their review, 2 stars to 4
Nothing changed
No write to the sheet
1 new row inserted at row 2
Keyed on Review ID, so nothing lands twice
The newest Trustpilot review is always row 2.
A sync covers the Trustpilot profiles you choose. Point it at every profile you run, one per country site if that is how you sell, and the sheet is the whole company's Trustpilot history in one place, with the profile named on every row.
Then narrow a second sync. Set the score filter to two stars and below, require the review to have text, and that sheet holds only the reviews somebody has to act on. Share that one with the people who act and the full one with the people who count.
A second sync gets its own spreadsheet with its own filters, so the ops sheet and the finance sheet are never the same document with two people fighting over the filter view.
Score and text are the filters a Trustpilot sync offers. There is no keyword filter on the way in, which is what the COUNTIFS above is for.
Ashcroft Home Ashcroft Home DE Ashcroft Home FR Ashcroft Home Ashcroft Home DE Ashcroft Home FR Rating and text are the filters a Trustpilot sync offers.
The warehouse lead needs the number every Monday. Finance needs it at month end. Neither will ever open a review tool, and neither should have to. A Google Sheet is the one document they already know how to open on a phone.
Share it as a viewer and they see the live rows, the pivots you built and the charts on top, with nobody needing a Reviewflowz login to read any of it. Keep the editor seat for the one person who owns the formulas.
The review tab carries a protected range that warns anyone typing over the rows that the sync will overwrite them, so the file survives being shared widely. Build the pivots on a second tab and the review tab stays the source.
Point Looker Studio or the monthly slide deck at the same file instead of maintaining a copy that drifts. One document, one number, and nobody arguing about whose export is the current one.
Protected range: the next sync replaces edits to the Reviews tab.
Nobody on this list needs a Reviewflowz login to read the file.
Set up in under five minutes. No demo required.
A live sync. Reviewflowz creates the spreadsheet in your Google Drive and writes it every thirty minutes: new Trustpilot reviews are inserted at the top, newest first, and an edited review updates its own row. Nobody re-runs anything.
Yes, on a paid plan. Once the sync is on, Reviewflowz offers to seed the spreadsheet with your past reviews, and keeps it current from there. A Trustpilot profile added by its URL carries its most recent 200 reviews; connect your Trustpilot Business API and the seed brings the full history. On the free trial the past-review seed is locked, so a trial sheet fills from new reviews only.
A fixed header, the same on every sync: Review ID in column A, then profile name, platform, title, the full review text, score, link, review date, language, reviewer name, tags, and Trustpilot's own review ID. The header also carries columns only other platforms fill, pros and cons, reviewer company, app version, and those stay empty on a Trustpilot row. Your replies to reviews are not in the sheet.
Yes. Each sync covers the profiles you pick, and you can restrict it by score (at or below two stars, for example) and to reviews that have text. Rating and text are the only filters for Trustpilot profiles; there is no keyword filter on the sync itself.
No. The Google permission it asks for covers files it created itself, which is the one spreadsheet. It cannot list, read or change anything else in your Drive.
No. You add your Trustpilot profile, pick Google Sheets as the destination and connect your Google account yourself, in under five minutes. 14 day free trial, no credit card.
