Reviewflowz keeps a Google Sheet in sync with your Google reviews, so you set it up once and never export again. It checks for changes every 30 minutes. New reviews land at the top of the sheet. The sync is included in every plan, and the same sync works for every platform you track, not only Google.
This is the live version of an export. If you only need a file once, export your Google reviews to Excel or CSV instead.
How to sync Google reviews to Google Sheets automatically
You set this up as an automation, and it takes a few minutes.
Open Integrations and go to the Forward Reviews tab.
Click + Add a new alert.
Next to To, click Google Sheets.
Click Connect Google Sheets and sign in with the Google account that should own the sheet.
Choose which reviews to send (see below), then turn the automation on.
When Reviewflowz asks whether to send all past reviews to your spreadsheet, click Yes.
You don't pick a spreadsheet. When you connect, Reviewflowz creates a new one in your Google Drive, named "Reviewflowz Integration" with the date. It can only open files it created, so it never sees the rest of your Drive. After you turn the automation on, Open spreadsheet appears at the bottom of the card.
Step 6 fills the sheet with your whole review history. If you click No, the sheet starts empty and only gets reviews from then on.
What the sheet contains
The sheet has one tab, called Reviews, with a header row and one row per review. The newest review is always on row 2.
Column A is Review ID, Reviewflowz's own number for the review. The sync uses it to find the right row when a review changes, so leave it where it is. The next 27 columns are:
Column | What it holds |
Profile Name | The listing the review belongs to |
Platform | Google Maps, Tripadvisor, G2 and so on |
Title, Overall, Pros, Cons | The review text. Google reviews fill Overall |
Score | The star rating |
Link | The review on its platform |
Review Date | The date of the review |
Language | The language it is written in |
Reviewer Name | The reviewer, when the platform shows one |
Photos | Links to attached photos |
Tags | Your tags on the review |
Review Owners | The team members the review is credited to |
External Review ID | The platform's own ID |
The remaining columns (reviewer company, job title, department, industry and company size, plus fields such as Likelihood to Recommend) are filled for software review sites like G2 and Capterra, and stay empty for Google.
What stays in sync
Every 30 minutes Reviewflowz checks whether anything changed for the reviews in your automation. It then updates only those rows.
A new review is added at the top.
Edits that Reviewflowz detects are sent to the sheet.
A review deleted from Reviewflowz, for example when you remove its listing, loses its row.
Rows are matched by Review ID in column A, so don't delete or overwrite that column. New reviews are always inserted at row 2.
Choose which reviews go to the sheet
The automation card controls what lands in the sheet.
Send picks all reviews, or a star threshold such as 3 stars or less.
Review must contain some words skips ratings that have no text.
Locations and Account wide listings pick which listings feed the sheet. One sheet can hold every location, with the Profile Name column telling them apart.
To split the data, say one sheet for Google and one for G2, create a second automation and connect Google Sheets again. Each connection creates its own spreadsheet.
Build charts and reports without losing them
Reviewflowz manages the Reviews tab. It marks the tab as protected with a warning, and a manual edit can be overwritten on the next sync. So put your own work somewhere else.
Add new tabs to the same spreadsheet for your pivot tables and charts, and point them at the Reviews tab with ordinary formulas. A formula like
=COUNTIFS(Reviews!H:H, 5)keeps counting as rows arrive.Or create a separate spreadsheet and pull the data in with
IMPORTRANGE.
Turning the automation off and on again clears the Reviews tab and writes the header row again. Click Yes on the prompt that follows to fill it back up.
Plans and limits
Syncing to a Google Sheet is on the pricing page under the features included in every plan, with no cap on rows.
Two limits are worth knowing. Your plan allows a set number of active automations, and each running Google Sheets sync counts as one. And on a free trial, sending past reviews to a sheet is locked. You can buy a one-time export or subscribe to unlock it.
See it for a Google listing
A Google Sheet is also a data source for other tools.
Build a Looker Studio dashboard from your Google reviews reads this sheet.
Connect Google reviews to Power BI and Tableau uses a live OData feed instead of a sheet.
Here is Google reviews to Google Sheets, the same sync set up for a Google listing.
Want this running on your own reviews? Connect Google and your first sheet takes a few minutes. See plans and pricing.