This guide gives instructions on how to connect Google Play Reviews with Google Sheets, Data Studio, and Excel.
Before you begin
Google Play Reviews doesn't require a Google Play account. This data source has no access requirements.
Main features
With Google Play Reviews you can:
- Return data for 400 most recent reviews for any app in the Google Play store
Note that searches are carried out with app IDs that can be extracted from the Play Store URL. For example, for https://play.google.com/store/apps/details?id=ee.mtakso.client, the ID would be ee.mtakso.client.
Data protection agreement
If you have any questions about how Supermetrics handles and secures your data, read our policy on data privacy and security.
Instructions
- Open a new Google Sheets file.
- Click Add-ons → Supermetrics → Launch to open the sidebar.
- Under Data source, select the data source.
- Navigate to Report configuration.
- Under Query type, select the query type.
- Insert the Google Play ID.
Next steps
Learn how to create your first Supermetrics query with Google Play Reviews.- Open the Supermetrics data source gallery.
- Navigate to the data source and click Try.
- Click Authorize to authorize Supermetrics in Data Studio.
If you're authenticating the data source for the first time, log in with the Google account you use with Supermetrics. Click Allow. - Click Authorize to log in to the data source.
- Under Query type, select the query type. Click Next.
- Insert the Google Play ID.
- Click Connect on the top right-hand side. This will open a full list of fields available in this connector. You can skip this list.
- Click Create report.
- Click Add to report to complete the authentication steps.
Next steps
Learn how to create your first Supermetrics query with Google Play Reviews.
Before you can authenticate Google Play Reviews in Excel, you need to install the Supermetrics add-on.
- Open an Excel file.
- Click Data → Show Supermetrics
- Under Data source, select the data source.
- Navigate to Report configuration.
- Under Query type, select the query type.
- Insert the Google Play ID.
Next steps
Learn how to create your first Supermetrics query with Google Play Reviews.Explore our guides to set up data transfers to various destinations.
- Set up BigQuery
- Set up data warehouse and cloud storage (Amazon S3, Google Cloud Storage, Snowflake, Azure Storage, or Azure Synapse)
- Set up the Supermetrics API
Next steps
Learn how to create your first Supermetrics query with Google Play Reviews.