G2 reviews to Looker Studio

No, and Looker Studio has no OData connector either, so nothing here pretends otherwise. The path is the Google Sheets sync: Reviewflowz writes your G2 reviews into a spreadsheet in your own Drive every thirty minutes, and Looker Studio reads a Google Sheet as a first-class data source. Add data, Google Sheets, pick the file, take the header row as the field names.

Yes, and it is the reason this page exists. Reviewflowz reads G2's own question headings, so the answer to "What do you like best?" lands in the Pros column, the answer to "What do you dislike?" lands in the Cons column, and the rest of the questionnaire including the problems-solved answer lands in Overall. In Looker Studio each of those is a field you can count, filter or chart on its own.

Thirteen columns fill on a G2 row: profile name, platform, title, overall, pros, cons, score, link, review date, reviewer name, reviewer job title, reviewer company size and G2's review ID. Three more are ours: the review ID that keys the row, your tags, and the review owner. Twelve stay empty because they belong to other platforms, including reviewer company, industry, department and language. There is no reply column.

Yes. Both are on every G2 row, company size in column S and job title in column P, so both are ordinary dimensions and both work as page-level controls. That is usually the most useful pair in the report: an enterprise average and a small-business average are frequently different products as far as your roadmap is concerned.

A live sync. The sheet is written every thirty minutes, new G2 reviews are inserted at the top under the header, and a review that gets edited rewrites its own row rather than appearing twice. Your G2 profile itself is re-checked at least every four hours. Nobody re-runs anything, so a report is right whenever somebody opens it.

On a paid plan, yes. Once the sync is on, Reviewflowz offers to seed the spreadsheet with your past G2 reviews and keeps it current from there, so the trend line has a baseline on day one. On the free trial that seed is locked and the sheet fills from new reviews only.

Each sync covers the G2 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 on the way in. There is no keyword filter and no language filter for a G2 profile, which is what a calculated field in Looker Studio is for. A second sync gets its own spreadsheet rather than a second tab.

Yes, with Looker Studio's own sharing: viewer access by link or by email address, the same as any Google file. It opens on a phone, needs no install, and nobody in that chain holds a BI licence or a Reviewflowz login. Keep the underlying spreadsheet shared with whoever owns the report and the audience never has a file to break.

No. G2 gives no write access for vendor responses, so nothing in Reviewflowz publishes to G2 and there is no reply column in the sheet. What it does is make sure you know a review exists, and what it says, within the hour rather than the quarter.

No. You add your G2 profile, pick Google Sheets as the destination and connect your Google account yourself, in under five minutes. 14 day free trial, no credit card.