How to get App Store and Google Play reviews into a spreadsheet and find the complaints

Updated 2026-10-28 · Data and API builders · by CyberMax

Short answer

Look up the app by name or id in each store, pull the newest public reviews for the countries you care about, and put both stores in one table with the same columns (stars, text, date, app version). Then filter to 1-2 star reviews and count the phrases that repeat: those are the complaints worth fixing first.

Give the app name or store id and choose App Store, Google Play or both.
Pick countries and a language; App Store reviews are per country.
Set the number of reviews per app and filters (stars, since date, keyword).
Group 1-2 star reviews by app version to see whether a release made things worse.
Schedule it with only-new-reviews mode to get a daily complaints feed.

Copy-paste code

Both stores, 200 reviews per app, US (your own Apify token)

curl -s -X POST "https://api.apify.com/v2/acts/cybermax~app-reviews/run-sync-get-dataset-items" \
  -H "Authorization: Bearer $APIFY_TOKEN" -H "Content-Type: application/json" \
  -d '{"apps": ["Duolingo"], "stores": "both", "maxReviewsPerApp": 200, "countries": ["us"]}'

A real app summary (Threads, App Store US, 500 newest reviews)
Field	Value
Average of the 500	3.43 stars
Negative share (1-2 stars)	38.2%
Top complaint phrase	account (24 reviews)
Worst version	447.0 (3.12 stars over 156 reviews)

Source: Gripeline (Apify Actor cybermax/app-reviews) README, real run

Gripeline: See what users hate about any app

$0.0001 per review + $0.003 per app summary

Gripeline reads both stores in one schema at $0.10 per 1,000 reviews and adds a complaint summary per app for $0.003.

Get Gripeline See what's inside Try free on Apify

Runs on your own Apify account, pay per result; failed results are not charged.

Questions

Can I get every review ever written?

No. The stores expose a limited number of recent public reviews per app and country.

Is this allowed?

The reviews are public. Use them for analysis and do not republish reviewers' personal details.

Free: the Free API Starter Kit

Copy-paste calls for 4 APIs with free daily tiers (CVE priority, VIN recalls, US duty rates, email checks), then 5 short emails on KEV/EPSS, MCP and free data.