Google reviews to Google Sheets
A business with twelve sites has twelve reputations. One sheet holds all of them, one row per review with the shop named on it, kept in sync every thirty minutes.
- Set up in under five minutes
- No demo required
Copperfield Bakehouse
Synced 8 min ago
| Row | B | E | H | J |
|---|---|---|---|---|
| 1 | Profile Name | Overall | Score | Review Date |
| 2 | Copperfield Bakehouse Stockport | Queue out the door and one person on the till. Twenty minutes for two coffees and a sausage roll. | 2 | 2026-09-07 14:12 |
| 3 | Copperfield Bakehouse Didsbury | Ordered the birthday cake on Tuesday, collected it Saturday, and it was exactly the drawing my daughter gave them. | 5 | 2026-09-07 13:41 |
| 4 | Copperfield Bakehouse Chorlton | Sourdough is still warm at nine in the morning and they slice it for you without being asked. | 5 | 2026-09-07 11:26 |
| 5 | Copperfield Bakehouse Stockport | Card machine down again, cash only, and no sign on the door until you reach the front of the queue. | 1 | 2026-09-07 10:58 |
| 6 | Copperfield Bakehouse Altrincham | Good flat white and proper tables. The pain au raisin was yesterday’s and they took it off the bill. | 3 | 2026-09-06 16:04 |
| 7 | Copperfield Bakehouse Ancoats | Bardzo dobre pieczywo i miła obsługa, ale w sobotę rano nie ma gdzie usiąść. | 4 | 2026-09-06 09:37 |
They love how easy we've made it
10 000 Slack notifications
Online Pet Supplies Retailer
6000 reviews routed to Zendesk
European Bank
Monitoring 12 platforms
Marketing Software Company
100 000 reviews across 97 tours
Tour operator in Iceland
4500 locations monitored
Luggage Storage & Lockers
5000 AI replies generated
Sushi Restaurant Chain
Twelve shops, twelve reputations, one league table
Every shop has its own Google Business Profile and star average, and a group figure hides the site that moved. Every review lands with its shop in column B, so a pivot of locations by month shows it: the group held at 4.5 all summer while Stockport went 4.6 in June, 4.4 in July, 4.0 in August.
Google reviews
| Row | A | B | C | D | E |
|---|---|---|---|---|---|
| 1 | Location | Jun | Jul | Aug | Sep |
| 2 | Altrincham | 4.7 | 4.7 | 4.6 | 4.7 |
| 3 | Ancoats | 4.4 | 4.4 | 4.3 | 4.4 |
| 4 | Chorlton | 4.6 | 4.5 | 4.6 | 4.6 |
| 5 | Didsbury | 4.5 | 4.4 | 4.5 | 4.5 |
| 6 | Sale | 4.5 | 4.6 | 4.5 | 4.4 |
| 7 | Stockport | 4.6 | 4.4 | 4.0 | 3.9 |
| 8 | All 12 shops | 4.5 | 4.5 | 4.5 | 4.5 |
A sync, not twelve JSON files in twelve folders
Google Takeout gives you one reviews.json per location, with the rating as the word FIVE. Reviewflowz creates one spreadsheet in your Google Drive and syncs it every thirty minutes. New reviews land at the top, and an edited review updates its own row, keyed on the review ID in column A. On a paid plan, seed it with your past Google reviews.
JSON only, no CSV, and starRating is the word FIVE rather than the number 5.
Try it Free for 14 days
Your review history imports the moment you connect, so there is something to reply to from the first minute.
One sheet for the group. One for the shop.
A sync covers the profiles you point it at. Point one at all twelve shops for the estate, and a second at Stockport alone, so its manager gets a spreadsheet that only ever contained their rows. Restrict a sync by score and a sheet of two star and below reviews is a setting, not a formula.
Score and text are the conditions a Google sync offers. Filtering by language or by a keyword happens in the sheet, not on the way in.
Google reviews arrive on Saturdays
Google review volume tracks footfall: it climbs at the weekend and jumps after a campaign. Over the last ninety days these twelve shops took 231 reviews on Saturdays and 89 on Tuesdays, and a monthly average reports neither. Every row keeps the full timestamp, so a pivot by weekday and shop shows which shop's Saturdays are quiet while everyone else's are busy.
Google reviews
| Row | A | B | C |
|---|---|---|---|
| 1 | Weekday | Reviews | Chart |
| 2 | Monday | 96 | |
| 3 | Tuesday | 89 | |
| 4 | Wednesday | 94 | |
| 5 | Thursday | 104 | |
| 6 | Friday | 141 | |
| 7 | Saturday | 231 | |
| 8 | Sunday | 175 |
Reviewflowz writes the review timestamp. It does not know how many people walked in.
FAQs
Is this a one-off export or a live sync?
A live sync. Reviewflowz creates the spreadsheet in your Google Drive and writes it every thirty minutes: new Google reviews are inserted at the top, newest first, an edited review updates its own row, and a removed review loses its row. Nobody re-runs anything.
How does the sheet say which location a review came from?
Column B, Profile Name, on every row. Each Google Business Profile listing is its own review profile in Reviewflowz, so connecting one Google account brings in every open listing at once and each review lands with its shop beside it. Column B carries the listing name as Google has it, so if all twelve of your listings read the same, rename each profile in Reviewflowz once, before you seed the history, and every row after that says which shop.
Which columns land in the sheet?
A fixed header, twenty-eight columns, the same on every sync. Review ID in column A, then the profile name, the platform, the review text, the score, the timestamp, the language, the reviewer name, the tags and Google's own review ID. The header also carries columns only other platforms fill, pros and cons and reviewer job title among them, and those stay empty on a Google row. Your replies to reviews are not in the sheet.
Does the first sync include our Google review history?
Yes, on a paid plan. Once the sync is on, Reviewflowz offers to seed the spreadsheet with your past Google reviews and keeps it current from there. On the free trial that seeding step is locked, so a trial sheet fills from new reviews only.
Can I choose which Google reviews go in?
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. Those are the filters a Google sync offers; there is no language filter and no keyword filter on the sync itself.
Can Reviewflowz see the rest of my Google Drive?
No. The Drive 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.
Do I need a demo to get started?
No. You connect your Google Business Profile, pick Google Sheets as the destination and connect your Google account yourself, in under five minutes. 14 day free trial, no credit card.
Put every location's Google reviews on the same rows
Set up in under five minutes. No demo required.