# Google Sheets Connection

## Steps to upload new tables

By clicking on <mark style="color:blue;">**Use Data Connectors**</mark>, then choose <mark style="color:green;">**Google Sheets**</mark>, you can link your Google Sheet files to Presight.&#x20;

<figure><img src="/files/enf0azbxRsao98fnO5ET" alt=""><figcaption></figcaption></figure>

1. Signing in to <mark style="color:green;">**Google**</mark> to continue connecting:

<figure><img src="/files/ccnbJPnOtScXBrSg0MgP" alt="" width="460"><figcaption></figcaption></figure>

{% hint style="warning" %}
Required format for CSV Upload:

* The table needs to contain at least one <mark style="color:blue;">**ID**</mark> column and one <mark style="color:blue;">**Date**</mark> column;
* ID column needs to contain **unique** values only;
* Column names need to be **unique**;
* Date format must be in <mark style="color:green;">**YYYY-MM-DD**</mark>.&#x20;

If you wish to create numerical metrics, you need to make sure that the columns are formatted with <mark style="color:blue;">**`Number.`**</mark> If there are **`Null`** or **`Blank`** cells in the metric columns, please fill them with number "0".
{% endhint %}

2. You will need to select a File, indicate a Sheet and the Header Row

<figure><img src="/files/LA2znWeqkGWXiQ2E6Y8A" alt="" width="532"><figcaption></figcaption></figure>

3. Then, a review file will appear and you will need to <mark style="color:blue;">**Select ID Column,**</mark> then click <mark style="color:blue;">**Upload to Presight**</mark>

<figure><img src="/files/ykE3f0MZ16z8Fb42xdt4" alt="" width="563"><figcaption></figcaption></figure>

4. After successfully connecting, you can view your new table and dimensions from the table at <mark style="color:blue;">**Data Hub**</mark>.
5. Join the **Date column** of your transactional tables to **Date column** of <mark style="color:blue;">**Presight's Dimdates table**</mark>. Then, you can start creating metrics.

{% hint style="info" %}
Instructions for joining with the <mark style="color:blue;">**Dimdates table**</mark>, creating metrics and editing dimensions in the documentations below:
{% endhint %}

{% content-ref url="/pages/hQV29qmxNNGHDfuEV4cW" %}
[Dimensional Dates (Dimdates table)](/presight-v1.0/data-in/connect/data-connectors/dimensional-dates-dimdates-table.md)
{% endcontent-ref %}

{% content-ref url="/pages/webdopx9Iz6EI8PtAhh3" %}
[Broken mention](broken://pages/webdopx9Iz6EI8PtAhh3)
{% endcontent-ref %}

{% content-ref url="/pages/RzbK8aina5WkIcCmKGOC" %}
[Create a New Dimension](/presight-v1.0/model/segments-and-custom-segments/create-a-new-dimension.md)
{% endcontent-ref %}

## Steps to update data for existing metrics with Google Sheets Connection

Your data will be automatically synced every 24 hours at 12:00AM. Everything you add in your Google Sheets can be seen on Presight. You can request for more updating times per day or choose another updating time via email <mark style="color:blue;"><support@presight.io></mark>.&#x20;

{% hint style="warning" %}
Required format for Updating Google Sheets Tables:

* ID column, Date Format, Column Name and Column Format should remain the same during the connection time.
* New Columns cannot be updated. If you have new columns or you change the column name in your table at Google Sheets, you need to upload it as a new table.
  {% endhint %}

{% hint style="danger" %} <mark style="color:red;">**The new table will overwrite all contents of the existing table.**</mark>
{% endhint %}


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://presight.gitbook.io/presight-v1.0/data-in/connect/data-connectors/google-sheets-connection.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.