blog post

How to connect Google Play Store to Catchr

Johan Chemin
July 1, 2024
How to connect Google Play Store to Catchr

Quick steps to create a Google Play Store report with Google Sheets:

You can easiliy create a Google Play Store report following this step :

  1. Get informations from the data integration from our Google Play Store connector.
  2. Create a source on catchr.io.
  3. Download our Google Sheets extensions.
  4. Configure and run your request
If you need more informations, you can follow the tutorial.

How to install Google Sheets Catchr Add-on.

To start exporting your Google Play Store data to Google Sheets, you need to install the Catchr add-on. You currently have two options :

Option A: Via the marketplace:

  1. Visit the Catchr Add-on page on the Google Workspace Marketplace and click "Install."
  2. Grant the necessary permissions for the add-on.
  3. Upon successful installation, open a Google Sheets to proceed.
Connect Google Sheet to Facebook Ads
Install Catchr Google Sheets Add-on

Option B: Directly within a Google Sheets:

  1. Open a new Google Sheets.
  2. In the top menu, click "Extensions", then hover over "Add-ons" and select "Get add-ons."
  3. Search for "Catchr" and choose "Catchr - data connector."
  4. Click "Install" and grant the required permissions.
  5. Close the installation pop-up when completed.
  6. Start using the Catchr add-on.
Install Catchr Add-on for Google Sheets
Install Catchr Add-on for Google Sheets

Once you have installed the add-on, you can start making requests.

The tutorial

Quick steps to create a Google Play Store report with Looker Studio:

You can easiliy create a Google Play Store report following this step :

  1. Get informations from the data integration from our Google Play Store connector.
  2. Create a datasource and new report on Looker Studio.
  3. Choose your metrics and dimensions.
  4. Use charts with your metrics and dimensions.
If you need more informations, you can follow the tutorial. You can also find a template for Google Play Store at the end of the page.

The tutorial

Quick steps to create a Google Play Store report with PowerBI:

You can easiliy create a Google Play Store report following this step :

  1. Get informations from the data integration from our Google Play Store connector.
  2. Create a source on catchr.io.
  3. Configure your request on the PowerBI request manager.
  4. Copy the given URL in PowerBI
If you need more informations, you can follow the tutorial. You can also find a template for Google Play Store at the end of the page.

The tutorial

How to connect Google Play Store to Catchr

Connecting your Google Play Store account to Catchr is the best way to make your Apps data accessible to your best reporting tools. To connect your account, you will need to grant access to our Google Services account, find your bucket ID in your Google Play Store account and create a new Source on Catchr with it. Once done, your Google Play Apps data will be accessible on Looker Studio, Google Sheets, PowerBI, Tableau...

We will cover everything in this article.

Granting access to our Google Services account:

For this first step, you will need Admin-level access to your Google Play Console Developer Account.

Go to your Google Play Store account, Users and Permissions and invite our Google account.

You can find our service address in the pop-up when creating a Catchr Source :

Catchr Google Service address, copy it and use it to invite us.

(do not copy it from this image, it is dynamically generated)

You must give it the following permissions:

  1. View app information and download bulk reports (read-only).
  2. View financial data, orders, and cancellation survey responses.
  3. Manage store presence.

IMPORTANT: Ensure both "App Permissions" and "Account Permissions" are given. You can find those two tabs under "Permission":

Please note that Google can take up to 30 hours to confirm the new access.

Now, you have granted access to our Google Services, let's find your bucket ID and create your Catchr Source.

Finding your Bucket Id :


  • Select any option below the "Download Reports" section on the menu.
google play download reports
Open the download report section.

  • Click on "Copy Cloud Storage API".

image
Click on Copy Cloud Storage URL


  • Open a note and paste the Cloud Storage URL.
  • Select the section between gs:// and /stats/. This is your Bucket ID.

Copy it, and we will use it to create your new sources on Catchr.

How to create your Google Play Store Source on Catchr ?

Connect to your Catchr space (or create an account if necessary), and add a new source.

Add a new Google Play Store Source on Catchr

Select Google Play Store and give it the Bucket ID.

Enter your bucket ID to create your new Catchr source

If our Google Services have been invited, you should find your list of Apps once the pop-up closes (it can take 2 or 3 minutes maximum).

Here's an example of a Meta Ads source with a visible account (it should look exactly the same but with the Play Store logo).

Once your Apps are visible on Catchr, you can use the data for all our destinations. If they are not visible, please come back in 30 hours when Google processed the new Access granted in the first step.

Starting with Looker Studio and Google Play Store:

Follow this link to our Google Play Store connector for Looker Studio. Go through the authorization steps (be sure to log in to Looker Studio and Catchr with the same account; you will avoid many issues).

Select your account in the list and click Connect:

Create your Google Play Store data source on Looker Studio.

Once your data source is created, you'll land on the field list with their description. ClickCreate Report to make your new Google Play Store report with Looker Studio.

Create your new Google Play Store report on Looker Studio.

Starting with Google Sheets and Google Play Store:

You can install our Google Sheets add-on and import data to Google Sheets automatically!

Open a new Google sheets, click on Extension -> Catchr - Data Connector -> Launch:

Launch the Catchr Add-On for Google Sheets.

You now have access to our Add-on. Click on Add new to start creating a new query:

Start creating a new request on our Google Sheets Add-on

Follow this link to find a complete tutorial on how to use our Google Sheets Add-on for your Google Play Store Apps.

Bonus : Your free Google Play Store Template

In this Google Play Store template, you will find all the metrics and dimensions you would need to get a better view of your data.

If you need more templates, you could look at our looker studio template gallery.

No items found.

In this Google Play Store template, you will find all the metrics and dimensions you would need to get a better view of your data thank to our integrations.

If you need more templates, you could look at our PowerBI template gallery.

Unlock Insights with Style!

Transform your marketing data into stunning dashboards.

Integrate, visualize, and impress with Catchr's seamless dashboards. Elevate your data game now!
Build your first report
14 days free-trial - No credit card required 🎉

More blog post about Google Play Store