Google Play reviews to Google Sheets

Google Play reviews sync into a Google Sheet as they arrive. Each one is a row: the app, the rating, the date, the reviewer, the app version it was written on, the language, the full text and your tags. New rows land at row 2, so the newest review is the first thing you see when you open the sheet.

Nobody re-runs anything. Play Console's own export is one CSV per app per month, posted three to seven days after the fact, and someone still has to download each file, strip the header row and paste it under last month's. That is the Monday chore this replaces.

The sheet stays right after it fills, too. When a reviewer edits their review, the row updates. When Google removes one, the row goes. Reviewflowz checks every 30 minutes and writes only the difference, so what you see in the sheet is what is on Google Play.

Nothing to maintain, either. There is no Apps Script to patch, no scraper that breaks the week Google changes a page, and no monthly task budget to watch. You connect the app, pick the sheet, and keeping the sheet right stops being anybody's job.

Google Play reviews arrive with the language they were written in, and that lands in its own column. Pivot by language instead of by version and a release that broke in one market shows up as one row that looks nothing like the others.

Portuguese at 2.1 while every other language sits above four is not a rating problem. It is a string that didn't ship, a payment method that only fails in one currency, or a date format nobody tested. The sheet points at the market, and the review text in the next column says what went wrong.

Filter the same column down to one language and you have the batch to hand to whoever owns that market, in the words the reviewers used, without anyone copying a spreadsheet together by hand first.

Google Play gives you the language, not the country. For most markets those are the same answer, and where they are not you will know it from the first three reviews you read. Either way it is a column that was already there, not a report somebody has to commission first.

Load your history and the sheet is full before the first new review arrives. Every Google Play review Reviewflowz holds for the app goes in, so the version pivot has a trend line on day one rather than in three months.

Then share it the way you share any sheet. The product manager who wants the pivot, the agency that owns the Brazilian launch, the founder who reads one-stars on Sunday: they open a Google Sheet. No Reviewflowz login, nothing to install, nothing to explain.

It is a normal sheet, so everything you already know works on it. Filter views, conditional formatting on the Score column, a chart on the pivot, a Looker Studio report reading the same tab. Build the monthly rollup once and it keeps producing itself.

The synced tab looks after itself, too. Reviewflowz marks it as managed, so Google warns anyone about to type over a row the sync owns, and the sync only ever writes that one tab. Build your pivots, your filter views and your charts on a second tab and nothing you make collides with what arrives next.