# Looker Studio Connector

You can find the review here: [Send Data to Google Looker Studio](https://app.getconduit.app/discover/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](https://script.google.com/home/usersettings).

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.

<figure><img src="https://2311731864-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FWkzjcMtcJloeTqt0wsJi%2Fuploads%2FmYIJs2LoP1xh9ApbGwke%2Fimage.png?alt=media&#x26;token=647962c3-509a-4935-acd0-ae17fd9e7eae" alt=""><figcaption></figcaption></figure>

#### **Open Google Script Editor**:

* Go to the [Google Script Editor](https://script.google.com/).
* Create a new project.

<figure><img src="https://2311731864-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FWkzjcMtcJloeTqt0wsJi%2Fuploads%2FlB7UFjXiR5chKUPJQBRL%2Fimage.png?alt=media&#x26;token=57b92544-fe59-4e99-94fb-ac60b409aa5a" alt=""><figcaption></figcaption></figure>

#### **Enable Display of Manifest File**:

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

<figure><img src="https://2311731864-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FWkzjcMtcJloeTqt0wsJi%2Fuploads%2Fagyw8N4h6qAY9j8vtj6z%2Fimage.png?alt=media&#x26;token=24ba2d31-cdea-4e88-a74c-bbfe00f21320" alt=""><figcaption></figcaption></figure>

<figure><img src="https://2311731864-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FWkzjcMtcJloeTqt0wsJi%2Fuploads%2FZY69zw8rAuXIBqB9OW1Q%2Fimage.png?alt=media&#x26;token=d747a6a4-895f-44c1-97b4-d6575372a036" alt=""><figcaption></figcaption></figure>

#### **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.

<figure><img src="https://2311731864-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FWkzjcMtcJloeTqt0wsJi%2Fuploads%2FHjRtSSHhtWwxxYl0cX0n%2Fimage.png?alt=media&#x26;token=2c96e049-ba2b-4791-a476-badde4e95fc4" alt=""><figcaption></figcaption></figure>

**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.

<figure><img src="https://2311731864-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FWkzjcMtcJloeTqt0wsJi%2Fuploads%2FML3Ftl3QVHWR2BJKCzEQ%2Fimage.png?alt=media&#x26;token=0527f229-e424-409e-a928-1b83ad7ff016" alt=""><figcaption></figcaption></figure>

#### **Test Deployment**:

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

<figure><img src="https://2311731864-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FWkzjcMtcJloeTqt0wsJi%2Fuploads%2FE4ITf4P20czDCNS41htp%2Fimage.png?alt=media&#x26;token=6dcc56ab-7803-462a-95a7-a7ee21501409" alt=""><figcaption></figcaption></figure>

<figure><img src="https://2311731864-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FWkzjcMtcJloeTqt0wsJi%2Fuploads%2FiFTjV49nln5c9qXRoyJj%2Fimage.png?alt=media&#x26;token=63b2a7b0-32d8-4cc5-8e12-0f853e9f6cc0" alt=""><figcaption></figcaption></figure>

#### **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.

<figure><img src="https://2311731864-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FWkzjcMtcJloeTqt0wsJi%2Fuploads%2FsCyqGlpRzMFFIpPyDGQM%2Fimage.png?alt=media&#x26;token=4b17f118-fc5a-4e29-8f53-d44a4c155efe" alt=""><figcaption></figcaption></figure>