23 Jul 2024 10:24 PM

Looker Studio Connector

You can find the review here: Send Data to Google Looker Studio.

This article details the necessary Google Apps Script settings. These steps only need to be completed once.

If you have multiple Google Accounts, ensure all steps are completed in the correct account.

Allow Google Apps Script to Run:

Open Google Apps Script Settings.

Note: If you have more than one Google Account then open https://script.google.com/u/3/home/usersettings (instead of u/3/ use your Google user index, such as u/1/ u/2/)

Allow the Google Apps Script API in your account settings.

clipboard-2024-07-23-22-09-57-508Z.png

Open Google Script Editor:

clipboard-2024-07-23-22-11-24-566Z.png

Enable Display of Manifest File:

Follow the instructions to enable the display of the manifest file.

clipboard-2024-07-23-22-11-50-974Z.png

clipboard-2024-07-23-22-12-15-657Z.png

Copy Manifest File from Conduit Repository:

  1. Open the appsscript.json file from the Conduit repository: https://github.com/cndt-app/Conduit-Looker-Connector/blob/dev/appsscript.json
  2. Copy the contents and paste them into the appsscript.json file in your project.
  3. Save the file.

clipboard-2024-07-23-22-13-11-999Z.png

Copy Script File from Conduit Repository:

  1. Open the code.gs file from the Conduit repository: https://github.com/cndt-app/Conduit-Looker-Connector/blob/dev/code.gs
  2. Copy the contents and paste them into the code.gs file in your project.
  3. Save the file.

clipboard-2024-07-23-22-14-06-293Z.png

Test Deployment:

Click on the Test Deployment button and copy the Head Deployment ID.

clipboard-2024-07-23-22-14-42-144Z.png

clipboard-2024-07-23-22-14-58-442Z.png

Launch Connector for the First Time:

Substitute the HEAD_DEPLOYMENT_ID in the URL:

https://lookerstudio.google.com/datasources/create?connectorId=<HEAD_DEPLOYMENT_ID>

For example:

https://lookerstudio.google.com/datasources/create?connectorId=AKfycbzFa_e5gjwz60Q8yno36peROwBn2FYv8nl-sxuhrqE-

If you have more than one Google Account, create a link for the specific user:

https://lookerstudio.google.com/u/3/datasources/create?connectorId=AKfycbzFa_e5gjwz60Q8yno36peROwBn2FYv8nl-sxuhrqE-

Open the URL in the browser.

Authorize and Configure:

After authorization, the connector settings window will open.

clipboard-2024-07-23-22-24-02-131Z.png

close