# Google Sheets

### Snapshot

| Features                        | Details                     |
| ------------------------------- | --------------------------- |
| Release Status                  | In-dev                      |
| Workbook Selection              | Yes                         |
| Table Selection                 | Yes                         |
| Column Selection                | Yes                         |
| Edit Integration                | Yes                         |
| Replication Type Selection      | Yes                         |
| Authentication Parameters       | Google docs Id and password |
| Replication Type                | Full Load Replication       |
| Replication Key                 | Datetime                    |
| Suggested Replication Frequency | 24hr                        |

### Instructions to Integrate Google Sheets with Daton

#### Prerequisites <a href="#prerequisites" id="prerequisites"></a>

You must have Read/Write access to a Google Sheet to connect Google Sheets to Daton.

#### Integrate Google Sheets with Daton

1. [Sign in](https://daton.sarasanalytics.com/login) to Daton.
2. Select **Google Sheets** from the list of Integrations.
3. Provide the necessary **Integration Name**, **Replication Frequency**, and **Replication Start Date** data and click on the **'Authenticate'** button.\
   \
   \&#xNAN;*Please Note, the **Integration Name** would be used in creating tables for the integration and cannot be changed later.* <br>

   <figure><img src="https://15515196-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-LbJ1eMq5M51cIpU163R%2Fuploads%2FHrzXQXQDdr7vwF3ZS3c9%2Fgsheet1.png?alt=media&#x26;token=6c9336fc-fa0d-4f3c-b04c-61cbd34494bc" alt=""><figcaption></figcaption></figure>
4. Provide Google **user-id**, and **password** used for Google Docs/Sheets.&#x20;

   <figure><img src="https://15515196-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-LbJ1eMq5M51cIpU163R%2Fuploads%2FApoTqnd6QP0XZwSKHUh5%2Fgsheet2.png?alt=media&#x26;token=13ebd98b-f9cd-4ed7-8a7a-22e0b0baf4ab" alt=""><figcaption></figcaption></figure>

   <figure><img src="https://15515196-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-LbJ1eMq5M51cIpU163R%2Fuploads%2Fmj9bfVcqk2ej6JdG9cPl%2Fgsheet3.png?alt=media&#x26;token=e2db8577-2778-4529-b95a-a08f4dad76ad" alt=""><figcaption></figcaption></figure>
5. Post successful authentication, provide the **'Spreadsheet Id'** of the spreadsheet you want to integrate and click the **Next** button.\
   \
   \&#xNAN;*The Spreadsheet ID is the last string of characters in the URL for your spreadsheet.*

   <figure><img src="https://15515196-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-LbJ1eMq5M51cIpU163R%2Fuploads%2FVmqflXIPZJ6V0xdrSi8s%2Fgsheet4.png?alt=media&#x26;token=fd5ec8f1-b757-47f5-b188-c6d6b7dead95" alt=""><figcaption></figcaption></figure>
6. Now you will be prompted to choose from the list of available tables. **Add** the required Tables and click on **'Next.'**\
   \&#xNAN;*These tables are nothing but the sheet names in your spreadsheet.*

   <figure><img src="https://15515196-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-LbJ1eMq5M51cIpU163R%2Fuploads%2FgXlrvXF7wEsdC1XCQFAz%2Fgsheet5.png?alt=media&#x26;token=582db592-ed6f-45f5-bb2d-579111c4b2fc" alt=""><figcaption></figcaption></figure>
7. Enter the **row number** to be used as a set of columns for each sheet to replicate and **Submit** the integration.\
   The replication field for each table is truncated and full load.

   <figure><img src="https://15515196-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-LbJ1eMq5M51cIpU163R%2Fuploads%2FNEV4SExiLBJ2cCByvjkJ%2Fgsheet6.png?alt=media&#x26;token=d951ef96-0e88-45e5-aa7c-317712a4fd23" alt=""><figcaption></figcaption></figure>

   Congrats! Your Spreadsheet has been integrated with Daton.

### Workflow

* Integrations would be in the **Pending state** *initially* and will be moved to the **Active state** *as soon as the first job loads* data successfully into the configured warehouse.
* Users can **view** *job status and process logs* from the integration details page by clicking on the integration name from the active list.
* Users can **Re-Authenticate, Edit, Clone, Pause** or **Delete** the integration at any given time by clicking on the settings\
  You can also edit the integration to **change frequency** and **history**.
* Each table in your integration can be accessed by clicking on the integration on the 'Sources' page. Here you may find the **status of each table,** the **last replicated time,** and **Reload access buttons**.

### Tables

Each selected sheet of the selected workbook will form a table in a warehouse with '\_' as its name to differentiate.

### Fields

Column header names with non-empty values will form column names in a warehouse, in other cases generic header (A..D..AB..) will act as column name.

The datatype for every column is STRING.