Google reviews to Looker Studio
Reviewflowz keeps a Google Sheet of your reviews current in your own Drive, and Looker Studio reads a Google Sheet natively. Rating by location sits beside the local traffic it came from, on a page you hand out as a link.
- Set up in under five minutes
- No demo required
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
A Google Sheet in your Drive, read natively
Looker Studio reads a Google Sheet natively, so that is the path. Reviewflowz creates one spreadsheet in your own Google Drive and keeps your Google reviews in it current every thirty minutes: new reviews insert at the top, edited reviews update their row, removed reviews lose theirs. In Looker Studio you pick Add data, Google Sheets, that file. Nothing to install, nothing to host.
There is no OData connector in Looker Studio, so the Reviewflowz OData feed is the road into Power BI and Tableau rather than this one. Looker takes the sheet.
One page for the board, one per site manager
A report goes out as a link, and whoever opens it needs no licence, no seat and no Reviewflowz login. Build a group page for the Monday meeting and a site page pinned to one Profile Name, so a manager sees their own reviews. A viewer cannot clear a filter you pinned, and you take the link back in the same panel you gave it in.
Nobody replies from here. Reviewflowz posts your replies to Google, and there is no reply column in the sheet behind this report, so what a viewer holds is the counting instrument and not the inbox.
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.
Column B is your location dimension
Each Google Business Profile listing is its own review profile, so connecting one Google account brings in every open listing, and every review lands with its listing in column B, Profile Name. Break any chart down by it and you have per site. The header is fixed at twenty eight columns, so a chart built in June still runs in December.
The same header carries the columns other platforms fill, Pros, Cons and Reviewer Job Title among them. They are empty on a Google row, so hide them here in the data source rather than in the sheet.
Profile Name is the listing title Google shows, not an address. Rename a profile in Reviewflowz and the nightly refresh from Google leaves your name alone.
Reviews and Google traffic on the same row
A Google review arrives tied to a listing, and that listing's sessions already sit in your analytics property. Blend them in Looker Studio on the location name and a star average becomes a question. At an eleven site garden centre group, Chorley pulls the most Google traffic, 3,180 sessions in ninety days, and converts 3.0 percent of it: the busiest local page, behind the worst rated shop.
Redwing GA4
| Profile Name | Rating | Sessions | Directions |
|---|---|---|---|
| Redwing Chorley | 4.1 | 3,180 | 3.0% |
| Redwing Cheadle | 4.6 | 3,020 | 4.9% |
| Redwing Tarporley | 4.7 | 2,410 | 3.7% |
| Redwing Wilmslow | 4.7 | 2,240 | 5.4% |
| Redwing Knutsford | 4.8 | 940 | 7.6% |
| All 11 sites | 4.5 | 20,740 | 4.6% |
Reviewflowz supplies one side of this table. The sessions come from your own analytics property, and the two only meet inside your report.
FAQs
Is there a Reviewflowz connector for Looker Studio?
No, and Looker Studio has no OData connector either, so the OData feed Reviewflowz offers on Premium is the road into Power BI and Tableau rather than this one. The path here is a Google Sheet: Reviewflowz creates one in your own Google Drive, syncs your Google reviews into it, and Looker Studio reads a Google Sheet as a first class data source. Both ends are Google, so there is nothing to install and nothing to host.
How does the report know which location a review came from?
Column B, Profile Name, on every row, which arrives in Looker Studio as a dimension you can break any chart down by. Each Google Business Profile listing is its own review profile in Reviewflowz, so connecting one Google account brings in every open listing at once. Column B carries the listing title rather than an address, so if several of your listings read the same, rename each profile in Reviewflowz once, before you seed the history.
How current is the dashboard?
Reviewflowz writes the sheet every thirty minutes, at two past and thirty two past. New reviews insert at the top, a review its author edited updates its own row, and a removed review loses its row. Looker Studio reads that sheet and refreshes on its own; the report also carries a refresh control if you want it now rather than shortly.
Can I share the report outside the company?
Yes, with Looker Studio's own sharing, and that is usually the reason teams pick it. A site manager, a franchisee or a client opens a link. They need no Reviewflowz login, no seat and no licence for anything.
Does the report start with our Google review history?
Yes, once you seed it. Seeding the sheet with your past Google reviews is a step you take once, on a paid plan, and after it the trend line is full from the first morning. On the free trial that step is locked, so a trial sheet fills from new reviews only.
Can I choose which Google reviews go into a report?
Yes, on the way in. Each sync covers the profiles you pick and can be restricted by score or to reviews that have text, and each sync writes its own spreadsheet, so a narrow report is a narrow source rather than a filter somebody can clear. There is no language filter on a Google sync and no keyword filter on any platform; language and tags come in as columns you filter on inside the report instead.
Can Reviewflowz see the rest of my Google Drive?
No. The Drive permission it asks for covers files it created itself, which is the 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 rating by location beside the traffic it came from
Set up in under five minutes. No demo required.