Google Play Setup Guide
Follow our setup guide to connect Google Play to Fivetran.
Prerequisites
Depending on the authentication method you choose, you will need one of the following:
- A Google Play account with User permissions - for OAuth authentication method
- A Google Play account with the ability to invite users - for Service Account authentication methods
Setup instructions
Find Bucket ID
Log in to your Google Play console.
Click Copy Cloud Storage URI.
Find your bucket ID in the Google Storage URI. For example, if the URI is
gs://pubsite_prod_rev_01234567890987654321/reviews/
, your bucket ID ispubsite_prod_rev_01234567890987654321
. Make a note of your bucket ID. You will need it to configure Fivetran.
Finish Fivetran configuration
In the connector setup form, enter your chosen destination schema name. If you have multiple apps, this schema name is the only way to differentiate the reporting data in your destination.
Enter the bucket ID you found in Step 1.
Select the Authentication Method:
Select OAuth to authenticate through OAuth. Click Authorize to allow Fivetran access to your Google Play account using OAuth.
IMPORTANT: This method requires a Google Play account with the User permissions.
Select Fivetran Owned Service Account to authenticate with Fivetran's service account:
- Make a note of the displayed service account email.
- In Google Play Console, select Users and permissions in the left sidebar. Click the Invite new users button.
- Enter the service account email address.
- Under Account permissions, check the View app information and download bulk reports (read-only) and View financial data, orders, and cancellation survey responses boxes.
- Click the Invite User button.
Select Custom Service Account to authenticate with your own service account:
In Google Play Console, follow the same steps as outlined for the Fivetran Owned Service Account authentication method, yet send an invitation to your service account instead of the Fivetran's one.
Create a service account key:
i. Follow Google's Create a service account key documentation to set up the service account key authentication.
ii. Make a note of the entire
service account key
file. You will need it to configure Fivetran. The key must be in the following JSON format:{ "type": "service_account", "project_id": "my-project-12345", "private_key_id": "abcdefg", "private_key": "*****", "client_email": "name@project.iam.gserviceaccount.com", "client_id": "12345678", "auth_uri": "https://accounts.google.com/o/oauth2/auth", "token_uri": "https://oauth2.googleapis.com/token", "auth_provider_x509_cert_url": "https://www.googleapis.com/oauth2/v1/certs", "client_x509_cert_url": "https://www.googleapis.com/robot/v1/metadata/x509/name%40project.iam.gserviceaccount.com" }
IMPORTANT: Both the Fivetran Owned Service Account and Custom Service Account methods require a Google Play account with the Account Owner or Admin permissions.
NOTE: Applied changes can take 1-2 days to propagate to Google Cloud Storage. During that time, the connection will not be able to connect via this service account.
In the setup form, enter the Service Account Key.
Click Save & Test. Fivetran will take it from here and sync your Google Play data.
Related articles
description Connector Overview
account_tree Schema Information
settings API Connector Configuration