Google Query authentication guide

This is a step-by-step guide to authorizing the following Google query components:

• Google Ads Query
• Google Analytics Query
• Google BigQuery Query
• Google Sheets Query

The Google query components all use OAuth 2.0 for third-party authentication.

---

Create an OAuth connection

Create an OAuth connection by following the instructions given in OAuth.

If you receive the error "This app is blocked" from Google during the OAuth creation process, you may need to alter your Google security settings to allow app access, as follows:

1. Log in to the Google Admin console with an account that has administrator privileges.

2. Follow the instructions to configure a new app in the Manage app access to Google services & add apps section of the Google documentation.

   Note

   • The Data Productivity Cloud's client ID is 192174083921-gcguirlj6ltqcreni233koj6r1r3ner1.apps.googleusercontent.com.
   • You will need to grant the Data Productivity Cloud Trusted access.

3. Return to the Data Productivity Cloud and retry the OAuth configuration.

Got feedback or spotted something we can improve?

We'd love to hear from you. Join the conversation in the Documentation forum!