Connect Google Looker Studio to OttoKit

This guide will walk you through setting up a connection between Google Looker Studio and OttoKit.

Prerequisites

Before you begin, ensure that:

• You have a Google Cloud Platform (GCP) project created and configured for Google Looker Studio.
• You have the required permissions to enable APIs and configure OAuth in GCP.
• You have an active Google Looker Studio account.
• You have access to your OttoKit account.

Create and Configure a Google Cloud Platform Project for Google Looker Studio

To connect Google Looker Studio to OttoKit, you first need to create and configure a project in GCP to obtain Client ID and Client Secret credentials.

1. Create a Google Cloud Platform Project

1. Log in to the Google Cloud Platform Console with your Google account.
2. Click Create or select a project > New project.
3. Enter a Project name and select the Location.
4. Click Create.
5. Ensure your newly created project is selected from the Select a project dropdown in the top menu.

2. Enable Required APIs for Google Looker Studio

1. In Basic Setup, under Enable an API, click Enable the Google Looker Studio API.
2. In GCP, go to APIs & Services > Library.
3. Search for and enable the following APIs:
   • Looker Studio API

If you see Manage instead of Enable, the API is already active.

3. Configure the OAuth Consent Screen

1. In the left sidebar of GCP, click Google Auth Platform.
   If not visible, click View all products and pin it to your sidebar.
2. Click Get Started.
3. Under App information:
   • App name: OttoKit
   • User support email: Your Gmail address
4. Under Audience, select External.
   (See Google’s Exceptions to verification requirements for details.)
5. Enter your Gmail address under Contact Information.
6. Under Finish, agree to the Google User Data Policy.
7. Click Continue > Create.
8. Click Create OAuth Client.
9. In the Branding section, under Authorized domains, add ottokit.com, and click Save.
10. Optional: In the Audience section, add your Gmail address on the Test users page, then click Save and continue if you want the project to remain in the Testing publishing status.

4. Create Your Google Looker Studio Client Credentials

1. In Google Auth Platform, click Clients.
2. Click + Create Client.
3. In the Application type dropdown, select Web application.
4. Update the Name of your OAuth client. This will help you identify it in the platform.
5. In the Authorized redirect URIs section, click + Add URI and enter the following redirect URI:
   https://api.ottokit.com/Looker_Studio/connection
6. Click Create.
7. Click the OAuth 2.0 Client you created, copy your Client ID and Client secret values, and store them in a safe place.

You will use these values in the Client ID and Client Secret fields in OttoKit during connection creation.

5. Connect Google Looker Studio in OttoKit

1. Log in to your OttoKit account.
2. Add any Trigger.
3. Add any Google Looker Studio action to your workflow.
4. In the Select Connection dropdown, click Create a connection.
5. Enter:
   • Title for this connection (optional)
   • Client ID and Client Secret (from Step 5 above)
6. Click the Connect Google Looker Studio button.

You have now successfully connected Google Looker Studio to OttoKit.