> For the complete documentation index, see [llms.txt](https://presight.gitbook.io/presight-v1.0/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://presight.gitbook.io/presight-v1.0/data-in/connect/data-connectors/google-sheets-connection.md).

# 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 %}