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. From the menu select Security, then Access and data control, and then API controls.
3. Click Manage Third-Party App Access to view your configured apps.
4. Click Configure new app and select OAuth App Name Or Client ID.

5. Enter the following client ID:

   192174083921-gcguirlj6ltqcreni233koj6r1r3ner1.apps.googleusercontent.com
   

6. Click Search.

7. Select the option Trusted: can access all Google services and then click Configure.
8. Retry the OAuth configuration following the process in OAuth.