> For the complete documentation index, see [llms.txt](https://daton-sarasanalytics.gitbook.io/daton/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://daton-sarasanalytics.gitbook.io/daton/integrations/data-sources/files/google-sheets.md).

# 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="/files/R1fOqJ7WPCE4iDc9fhC2" alt=""><figcaption></figcaption></figure>
4. Provide Google **user-id**, and **password** used for Google Docs/Sheets.&#x20;

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

   <figure><img src="/files/kMXCAUNb42YD4IGt73yU" 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="/files/JAW59JPEPeW1GnIeEhGk" 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="/files/xQZcbxH1NmW3HIUirjhY" 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="/files/mrxZNXVXUikIirR5Z6Qj" 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.