Skip to main content

How to bring your Reviewflowz reviews into Google Sheets

Import your reviews and ratings history from every platform into Google Sheets with the Reviewflowz add-on. Sign in, pick your data and a period, and refresh whenever you want.

A
Written by Axel Lavergne

Reviewflowz has its own add-on for Google Sheets. You install it once, sign in to Reviewflowz, and import your reviews or your ratings history from every platform into a sheet. A refresh from the menu brings the sheet up to date, and the charts and pivot tables you built on it keep working. You need a Premium or Enterprise plan.

Before you start

  • A Premium or Enterprise plan. The add-on needs API access, which both plans include. There is no separate fee for the add-on.

  • A Google account with Google Sheets.

Import your reviews into Google Sheets

Step 1: Install the add-on

Install Reviewflowz from the Google Workspace Marketplace. You can also install it from Google Sheets: open Extensions › Add-ons › Get add-ons and search for Reviewflowz.

Step 2: Open the sidebar

In any spreadsheet, open Extensions › Reviewflowz › Open. The Reviewflowz sidebar opens on the right.

Step 3: Sign in to Reviewflowz

Click Sign in to Reviewflowz. The sign-in opens in a new tab. Sign in, pick the Reviewflowz account to share, then come back to your spreadsheet. You never copy or paste a token.

If your plan does not include API access, the sidebar says so and links to our plans.

Step 4: Choose your data and import

Under Data, choose Reviews or Ratings history. Under Period, pick Last 30 days, Last 12 months or All time. Then click Import.

A Google Sheet of Reviewflowz reviews, with the Reviewflowz sidebar open on Reviews and Last 12 months

The sidebar tells you how many rows it imported and into which sheet.

Choose your data

Each kind of data goes into its own sheet, so you can import both into one spreadsheet.

Reviews

Reviews goes into a sheet named Reviewflowz reviews, with one row per live review. Removed reviews are left out. The columns include the rating, review date, platform, reviewer name, review text, reply, listing, location name, tags and topics. Your custom dimensions arrive as columns too, with no setup.

Ratings history

Ratings history goes into a sheet named Reviewflowz ratings history, with one row per listing per day. Each row has the rating and review count that platform showed that day, in the Platform rating and Platform review count columns.

A Reviewflowz ratings history sheet in Google Sheets, with one row per listing per day

Dates and times are in UTC, and their column names say so.

Keep your sheet up to date

To bring a spreadsheet up to date, open Extensions › Reviewflowz › Refresh imported data. It reruns every import that spreadsheet made, with the period you picked. You can also click Import again in the sidebar.

A new import replaces what the sheet held but keeps the sheet and its formatting. Charts and pivot tables built on it keep working. Keep your own notes in another sheet, because a refresh replaces everything in the imported one.

The add-on or the automatic sync: when to use which

Reviewflowz has two ways into Google Sheets.

  • The add-on imports your review history into a sheet when you ask for it, and a refresh brings it up to date. Use it for reports, charts and pivot tables across every platform.

  • The automatic sync, under Forward Reviews in Reviewflowz, adds each new review to a sheet as it arrives. Use it when your team works through new reviews in a sheet. See How to sync Google reviews to Google Sheets automatically.

You can use both.

Use several Reviewflowz accounts

The add-on reads one Reviewflowz account at a time. To import another one, click Sign out in the sidebar, then sign in again and pick the other account.

Your sign-in applies to every spreadsheet you use the add-on in, so a refresh reads the account you are signed in to. Give each account its own spreadsheet.

Control what the add-on can see

The add-on asks Google for three things only: the spreadsheet it is opened in, its own sidebar, and calls to Reviewflowz. It cannot open your other files.

In Reviewflowz, open Integrations, then Data Sync. The Google Sheets card shows when the add-on last synced. To stop sharing, click Revoke on that card. The add-on then asks you to sign in again.

The Reviewflowz sidebar in Google Sheets after an import of ratings history

Fix an error message

The add-on shows these messages word for word. Each one says what to do.

  • There is more data than Google Sheets can load in one go. Pick a shorter period.

  • This would not fit in one spreadsheet. Pick a shorter period.

  • Reviewflowz no longer accepts this sign-in (it was revoked or expired). Sign in again.

Related articles

Did this answer your question?