SheetMagicSheetMagic

Export App Store Reviews to Google Sheets, Fix What Churns

Export App Store reviews to Google Sheets with =APPSTOREREVIEWS: rating, text, date and app version for your app and competitors in one tab. Find the release behind your 1-star reviews. 1 scraping credit per review.

Phil Nguyen · 6 min read

=APPSTOREREVIEWS(, "us", 200) puts up to 200 App Store reviews for an iOS app into Google Sheets, with rating, title, review text, reviewer, date and app version on every row. You see which release and which complaint is behind your 1-star reviews in one sortable tab, at 1 scraping credit per review.

Picture a product manager for a habit-tracking app who, before every sprint, scrolls App Store Connect and two competitor pages and copies reviews into a doc. At about 30 seconds per review, 200 reviews is 100 minutes of copying, and the doc still cannot be sorted by version. One formula does the same pull for about 200 scraping credits, and the time goes into fixing what the reviews say instead.

How do I export App Store reviews to Google Sheets?

Type the formula in a cell:

=APPSTOREREVIEWS(appIds, country, maxResults)
  • appIds: one or more numeric App Store IDs. Write a single ID as {"389801252"}, or point at a range of cells that hold IDs.
  • country: the App Store storefront to read, "us" by default.
  • maxResults: how many reviews to return. Leave it out and you get 50.

The example ID 389801252 is Instagram. Swap in your own app's ID:

=APPSTOREREVIEWS({"389801252"}, "us", 200)

The cell shows ⏳ Scraping... at once. APPSTOREREVIEWS runs as a background job that takes up to about a minute, and the reviews then land in their own tab. Reviews come back newest first.

How do I find an app's App Store ID?

Open the app's page on apps.apple.com and look at the end of the URL. The ID is the digits after "id". In https://apps.apple.com/us/app/instagram/id389801252 the ID is 389801252.

Use the number, not the app name. A name, or an Android package name such as com.burbn.instagram, is rejected and the cell shows an error instead of reviews.

The country matters too. Reviews are per storefront: the US store and the German store hold completely different reviews for the same app. The storefronts you can pick are us, gb, ca, au, de, fr, es, it, jp, br, in, mx, nl and se.

What does each row contain?

The reviews go to a new tab called Appstore Reviews Results. The first column, Source, holds the cell reference of the formula that fetched the row. Then come:

Rating, Title, Review Text, Reviewer, Date, App Version, Country, App ID, Review ID, Reviewer URL, Review URL, Input Source.

The shape of the output, with made-up values for illustration:

SourceRatingTitleReview TextDateApp VersionApp ID
B21Lost my streakUpdated and my 90 day streak reset to zero...2026-11-094.2.01234567890
B25Finally sticksThe reminders are the only ones I do not ignore...2026-11-084.2.01234567890

There is no developer response column. The formula has no star-rating filter, date range or sort order either: pull the reviews, then filter the Rating or Date column in the sheet.

Can I pull reviews for several apps at once?

Yes. appIds takes more than one ID. Put your app and two competitors in A2:A4 and write:

=APPSTOREREVIEWS(A2:A4, "us", 300)

All three apps land in one tab, and the App ID column tells you which app each review belongs to. maxResults caps the total number of reviews, not the count per app, because one app can supply many reviews.

What can I do with the reviews?

  1. Tie a ratings drop to a release, and roll back faster. In the results tab, column B is Rating and column G is App Version. =COUNTIFS('Appstore Reviews Results'!B:B, "<=2", 'Appstore Reviews Results'!G:G, "4.2.0") counts 1 and 2 star reviews on version 4.2.0. Compare it with the version before. A jump that appears with one release points at what broke, so you know which release to fix first.
  2. Fix the most common complaint first. Add a column next to the reviews and label each one with AITEXT, pointing at the Review Text cell rather than nesting the scraper: =AITEXT("Label this App Store review with one word: bug, crash, pricing, feature, praise or other.", D2). Drag it down, then COUNTIF the labels. The biggest bucket is the fix that moves the most ratings. AITEXT spends AI tokens, separate from scraping credits.
  3. Win users who are leaving a competitor. Filter a competitor's App ID to Rating 1. Their 1-star reviews name the features people wanted and did not get. =AILIST("List each feature this review asks for", D2) turns one review into a list in the cells below, so you can collect the asks. See AI list extraction.
  4. Hand support a reply list. Filter to 1 and 2 stars from the last week and give support the Review URL column. Support can answer unhappy reviewers while the problem is still fresh.

How much does it cost?

APPSTOREREVIEWS costs 1 scraping credit per review, and no AI tokens. In the example, 200 reviews is 200 credits, against about 100 minutes of copying by hand. Three apps at 100 reviews each is 300 credits.

The Free plan includes 100 scraping credits, one time, which covers a 100-review test of your own app. The Solo plan includes 10,000 scraping credits a month. If your balance cannot cover the full maxResults, SheetMagic lowers maxResults to what the balance covers and adds a note row saying so. If it cannot cover even one review, the cell shows an out of credits message with the amount needed and the amount you have. See AI tokens vs scraping credits for how the two pools work.

To track many apps with separate formulas, put each ID in column A and drag =APPSTOREREVIEWS(A2, "us", 100) down column B. Formulas dragged down one column share one results tab, and the Source column says which formula each row came from.

What goes wrong?

  • Wrong storefront, few reviews. An app with most of its users in Germany has few reviews on us. Run "de" too.
  • App name instead of the ID. Only the digits after "id" work.
  • Waiting on the cell. ⏳ Scraping... is normal for up to about a minute. The reviews appear in the results tab, not below the formula.
  • Nesting it inside AITEXT. The scraper returns the Scraping placeholder first, so AITEXT would read the placeholder. Keep APPSTOREREVIEWS in its own cell and point AITEXT at the Review Text cells.
  • Expecting a refresh. With Keep Formula on (the default), the formula is kept as text after it runs so it does not run and charge again. Delete the leading apostrophe to pull fresh reviews. Each run is charged.
  • Android apps. APPSTOREREVIEWS is iOS only. Google Play reviews have their own formula, GPLAYREVIEWS.

For every scraper in one place, see the web scraping guide. For what to do with the data once it is in the sheet, see data analysis in Google Sheets.

Text and scraping formulas run on the free allowance. Install from the Google Workspace Marketplace, no card, no expiry.

Install free for Google Sheets

About the author

Phil NguyenPhil builds SheetMagic, the Google Sheets add-on that brings AI and web scraping into the spreadsheet, used by 6,000+ people. He writes these guides from the formulas he runs on his own sheets.