App Store reviews to Google Sheets

App Store reviews do not arrive evenly. They pile up in the hours after a release and the days after a featuring, and a broken build shows up as a run of one-stars in a few territories before your crash reporter agrees. When the rows are in a sheet that updates itself, the rollout is something you watch rather than something you hear about.

Reviewflowz checks the App Store every two hours by default, every ten minutes on the high-frequency setting, and syncs the sheet every half hour. On release day that means the first bad rows are on screen while the engineers are still at their desks, not in the next morning’s summary.

A chart on the sheet is a chart of the release. Reviews per day, split by rating, with Tuesday’s ship date marked. You can see the red band appear on Tuesday afternoon and shrink again after the hotfix on Friday. Nobody built a dashboard for that. Somebody inserted a chart.

The same sheet settles the argument afterwards. Was 4.2 actually worse, or did it feel worse because three people forwarded the same review? Count the rows.

An export is a file somebody remembers to make. This is a Google Sheet in your Drive that Reviewflowz keeps right. A new App Store review is a new row at the top of the sheet within half an hour of Reviewflowz seeing it, so the sheet is current when you open it, whoever opens it, on a Sunday.

Rows change when the review changes. A reviewer who edits their one-star into a four-star after your fix ships moves that row from 1.0 to 4.0, in place. A review Apple removes from the store loses its row. The sheet never holds a version of the truth the App Store no longer does.

Reviewflowz creates the spreadsheet in your Google Drive and writes one tab, Reviews. Nothing to build, no script to keep alive, no Zap that stops working the day a column moves. The tab carries a notice that it is managed by Reviewflowz and warns anyone about to type into it.

One click sends your whole review history into the sheet, so the trend line starts full rather than filling up over the next quarter. Connect on Tuesday and by Tuesday afternoon you can pivot three years of App Store reviews.

Sync every App Store review from every app you ship, or narrow it. Each App Store listing is a review profile in Reviewflowz, and a sync takes one profile or several. The app’s name is on every row, so one sheet for Fjord and Fjord Pro still pivots by app.

Per app, pick the countries. Leave it empty and every storefront the app sells in is tracked. Pick Japan and Germany and only those rows arrive, which is how a localisation team gets a sheet of just its markets without a filter anyone has to maintain.

Add a rating filter: three stars or less for the sheet the support lead reads, five stars for the one marketing mines for quotes. There is a switch for reviews with text only, so a bare star rating with nothing written under it never takes a row. Two syncs from the same app to two sheets is fine.

Setup is the same at one app or eight: connect the App Store listing, click Connect Google Sheets and sign in with Google, pick the apps, switch it on. Under five minutes, and the first rows are in the sheet on the next sync.