Menu

1 / 2

How to get App Store and Google Play reviews into a spreadsheet in 5 minutes

DEV Community: datascience·Hải Hà Phan Thanh·1 day ago
#JQRRrtlA
#devtodatascience#science#devto#dev#reviews
Reading 0:00
15s threshold

If you work on an app, or on a competitor's, you eventually want the raw reviews in a spreadsheet: to tag complaints, track a rating drop after a release, or feed them to a sentiment model. The App Store and Google Play make that annoying. Apple has no export for other people's apps, Google Play's console only shows your own reviews, and the two stores have different formats.

This post shows two ways to do it: a DIY version for each store, and a version using an Apify actor I built that returns both stores in one schema. I'll be upfront about limits at the end.

The DIY route

Apple publishes a public customer-reviews RSS feed. No key needed:

import requests

app_id , country = " 310633997 " , " us " # WhatsApp url = f " https://itunes.apple.com/ { country } /rss/customerreviews/page=1/id= { app_id } /sortby=mostrecent/json " entries = requests . get ( url , timeout = 20 ). json ()[ " feed " ].…

Continue reading — create a free account

Join HashtagPLUS to read full articles, follow hashtags, vote, and join the conversation.