DEV Community

Aurelix Solutions
Aurelix Solutions

Posted on

App Store and Google Play apps, top charts and reviews in one table with Python, no login

Product, growth and ASO teams usually watch both stores: what users say about their own app, how competitors are rated, and where everyone sits on the charts. Apple and Google show all of that on public pages, but in two different shapes, so the sheet never lines up.

This post pulls apps and reviews from both stores into one table in Python, checks what users complain about, reads an App Store top chart with ranks, and sets up a daily feed of new reviews.

Disclosure: I'm Aurelix, and I built App Store & Google Play Scraper, the tool used here. It's a paid tool (prices below).

What each row holds

Every row has type (app or review), store (app_store or google_play), app_id, country, url and scraped_at.

  • App rows (50 fields): title, developer, genre, price, is_free, rating, ratings_count, version, released_at, updated_at, release_notes, icon_url, screenshots, plus installs and rating_histogram on Google Play.
  • Review rows (19 fields): rating, review_title, text, date, app_version, helpful_votes, developer_reply, developer_reply_at and the reviewer's display name as the store shows it.
  • Chart rows add chart, chart_rank and chart_ranks (every chart and rank the app holds in the run).

One app on both stores, with reviews

pip install apify-client
Enter fullscreen mode Exit fullscreen mode
import os

from apify_client import ApifyClient

client = ApifyClient(os.environ["APIFY_TOKEN"])
run = client.actor("aurelix/app-store-google-play-scraper").call(
    run_input={
        "apps": ["https://apps.apple.com/us/app/spotify-music-and-podcasts/id324684580", "com.spotify.music"],
        "maxReviewsPerApp": 100,
        "countries": ["us", "gb"],
    }
)
rows = list(client.dataset(run["defaultDatasetId"]).iterate_items())
apps = [r for r in rows if r["type"] == "app"]
reviews = [r for r in rows if r["type"] == "review"]

for a in apps:
    print(a["store"], a["country"], a["title"], a["rating"], a["ratings_count"], a["version"])
Enter fullscreen mode Exit fullscreen mode

Apps can be App Store URLs, App Store IDs such as 324684580, or Android package names such as com.spotify.music, mixed freely. This example input returned 42 rows in our test run for about half a cent.

What users complain about

from collections import Counter

low = [r for r in reviews if r["rating"] and r["rating"] <= 2]
print(f"{len(low)} of {len(reviews)} reviews are 1 or 2 stars")

by_version = Counter((r["store"], r["app_version"]) for r in low if r["app_version"])
print("low ratings by version:", by_version.most_common(5))

words = Counter(w for r in low for w in (r["text"] or "").lower().split() if len(w) > 5)
print("common words:", words.most_common(15))
Enter fullscreen mode Exit fullscreen mode

The review text goes straight into an LLM prompt too, if you want themes such as bugs, pricing complaints and feature requests instead of a word count.

Top charts and developer pages

run_input = {
    "appStoreCharts": ["top-free", "top-grossing"],
    "chartGenre": "6014",  # Games; leave empty for all categories
    "countries": ["us", "de"],
    "maxAppsPerList": 100,
}
Enter fullscreen mode Exit fullscreen mode

Each app comes back with its rank, and an app on several of the charts you asked for carries all of them in chart_ranks. developers takes App Store or Google Play developer pages and returns every app of that publisher.

Only the new reviews, every morning

run_input = {
    "apps": ["https://apps.apple.com/us/app/duolingo-language-lessons/id570060128", "com.duolingo"],
    "countries": ["us"],
    "maxReviewsPerApp": 200,
    "onlyNewReviews": True,
    "stateKey": "duolingo-daily",
    "slackWebhookUrl": "https://hooks.slack.com/services/...",
}
Enter fullscreen mode Exit fullscreen mode

With onlyNewReviews on, the first run returns everything that matches and each later run skips reviews an earlier run already returned, so you pay only for new ones. Save the input as a task in the Apify Console and schedule it daily: Slack gets a short digest of the new reviews, and nothing is sent when there are none. webhookUrl sends the same digest as JSON to Zapier, Make or n8n.

Why this tool

  • Both stores in one schema, so one sheet covers iOS and Android.
  • Reviews with ratings, versions and developer replies.
  • App Store top charts with ranks, and every app of a developer.
  • Several store countries per run.
  • An only-new-reviews mode with a Slack or webhook digest.

Limits

  • No keyword search on either store and no Google Play charts: those paths are disallowed by the stores' robots.txt.
  • Review depth is what the stores publish: up to 500 App Store reviews per app and country, and about 20 Google Play reviews per app and language (what the public page shows).
  • Charts go to rank 100.
  • Google Play shows "Varies with device" for many apps, so version and minimum Android version are often empty.
  • Apple's review feed sometimes answers with no reviews for a while; those apps are named in the run status as not read instead of looking review-free.

Cost

$0.18 per 1,000 apps on Apify's free plan (from $0.14 on paid plans) and $0.025 per 1,000 reviews on every plan, plus a start fee per run. Unknown app IDs, duplicate reviews and reviews already returned in only-new mode are never charged. The current prices are on the Store page; Apify's free plan includes $5 of credit a month.

Use it from an AI assistant

The tool also works through Apify's hosted MCP server, so Claude, ChatGPT or Cursor can run it from a request like "get the latest 100 US reviews of Duolingo on both stores and summarise the complaints". Server URL: https://mcp.apify.com/?tools=aurelix/app-store-google-play-scraper.

Links

Top comments (0)