Use this guide to pull data from Google Play Reviews into the Google Sheets, Looker Studio, and Excel reports you create with Supermetrics.
If you need to connect this data source to one of our data warehouse or cloud storage destinations, explore our prerequisite and filling guides.
Before you begin
Google Play Reviews is a public data source — you don't need a specific account or permissions to access it. It returns data for any app's 400 most recent reviews in the Google Play Store.
To search for an app's data, you need to pull its app ID from its Play Store URL. This allows you to query that data with Supermetrics. To find this ID:
- Open the Play Store page for the app you'd like to pull data for.
- Look at the URL in your browser bar. The text string after id= is the app's ID. For example, in a URL ending in /store/apps/details?id=ee.example.client, the app ID would be ee.example.client.
Instructions
Make sure you've installed the Supermetrics add-on before you connect.
- Open a new Google Sheets file.
- Navigate to Extensions → Supermetrics → Launch sidebar to open Supermetrics.
- Click Create new query.
- Under Data source, select Google Play Reviews.
- Click Start.
- Navigate to Report configuration.
- Enter the app's Google Play Store ID.
Learn about advanced settings, best practices, and troubleshooting tips for Supermetrics for Google Sheets.
Make sure you've connected Supermetrics to Looker Studio before following the steps below.
- Open the Supermetrics data source gallery.
- Navigate to Google Play Reviews and click Try.
- You'll see two buttons that read Authorize. If you're using Supermetrics for the first time, click the left-hand one and log in with the Google Account you use with Supermetrics.
- Once that's done, or if you've done it before, click the right-hand Authorize button (under "Google Play Reviews requires authorization to connect to data").
- Select a team that has access to the account you want to connect.
- Choose to make this connection shared or private.
- Click Start.
- Navigate to Report configuration.
- Enter the app's Google Play Store ID.
- Scroll down to the bottom of the page. To create a report with our template, select Use report template for new reports. To create a blank report, deselect this option.
- In the pane's top right, click Connect.
- Click Create report.
- Click Add to report.
Learn about advanced settings, best practices, and troubleshooting tips for Supermetrics for Looker Studio.
Make sure you've installed the Supermetrics add-on before you connect.
- Open an Excel file.
- Click Data → Show Supermetrics.
- Under Data source, select Google Play Reviews.
- Choose to make this connection shared or private.
- Click Start.
- Navigate to Report configuration.
- Enter the app's Google Play Store ID.
Learn about advanced settings, best practices, and troubleshooting tips for Supermetrics for Excel.