> ## Documentation Index
> Fetch the complete documentation index at: https://www.integrate.io/docs/llms.txt
> Use this file to discover all available pages before exploring further.

# Google Sheets source for ELT & CDC

> Configure Google Sheets as a data source in Integrate.io ELT & CDC. Replicate spreadsheet data to your data warehouse for analysis.

|                           |                                                                                                                                 |
| :------------------------ | :------------------------------------------------------------------------------------------------------------------------------ |
| **Description**           | **Google Sheets** is a spreadsheet program included as part of the free, web-based Google Docs Editors suite offered by Google. |
| **Supported Replication** | Continuous Sync                                                                                                                 |
| **Authentication Type**   | OAuth                                                                                                                           |

### Replication strategy

Integrate.io uses Google API to access and replicate Google Sheet data. The following scopes are necessary to perform the replication

### Prerequisites

To ensure successful replication of Google Spreadsheets, the following conditions must be met for each sheet to be synced:\
1\. **Non-Empty Sheet:** The sheet must contain data and not be empty.\
2\. **Sheet Existence:** If the sheet has already been selected in the pipeline, confirm that it still exists in the spreadsheet.\
3\. **Header Row:** The first row must contain headers, which will be used as column names in the destination. Ensure these headers comply with destination column naming rules.\
4\. **Unique Headers:** Each header must be unique. Duplicate values (e.g., having "name" in multiple columns) are not allowed.\
5\. **Empty Headers:** Columns with empty header cells will be skipped. If two consecutive columns have empty headers, the scan will stop, and only columns up to that point will be replicated.\
6\. **Data Type Row:** The second row is used to determine column data types. Ensure this row contains representative data for the entire column. If data is not provided, the cell format will be checked and the column will default to either STRING or NUMBER based on the format.

### Collections

| **Collection Name**                                                                                                                                                                                                                                                                                  | **Full/Initial Sync** | **Incremental/Continuous Sync** | **Supports Update** | **Supports Delete** | **Notes** |
| :--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | :-------------------- | :------------------------------ | :------------------ | :------------------ | :-------- |
| file\_metadata      \[[https://www.googleapis.com/drive/v3/files/](https://www.googleapis.com/drive/v3/files/)$\{spreadsheet\_id}?fields=id,name,createdTime,modifiedTime,version](https://www.googleapis.com/drive/v3/files/$%7Bspreadsheet\_id%7D?fields=id,name,createdTime,modifiedTime,version) |                       | ✔                               |                     |                     | •         |
| spreadsheet\_metadata      \[[https://sheets.googleapis.com/v4/spreadsheets/](https://sheets.googleapis.com/v4/spreadsheets/)$\{spreadsheet\_id}?includeGridData=true&ranges=1:2](https://sheets.googleapis.com/v4/spreadsheets/$%7Bspreadsheet\_id%7D?includeGridData=true\&ranges=1:2)             |                       | ✔                               |                     |                     |           |
| sheet\_metadata   For all sheets Title, URL, Area (max column and row), and Column Metadata                                                                                                                                                                                                          |                       | ✔                               |                     |                     |           |
| sheets\_loaded   Sheet title, load date, number of rows                                                                                                                                                                                                                                              |                       | ✔                               |                     |                     |           |
| + a collection for each sheet                                                                                                                                                                                                                                                                        |                       | ✔                               |                     |                     |           |

**Source setup**

<Steps>
  <Step>
    On **Sources** or **Pipeline** creation form, select Google Sheets
  </Step>

  <Step>
    Click **Authenticate** and log in to your Google account.

    <Frame>
      <img src="https://mintcdn.com/integrateio/SIDFEDRgXpxG0yrn/images/cdc/sources/image-56.png?fit=max&auto=format&n=SIDFEDRgXpxG0yrn&q=85&s=ae311952128552b253706d66735f89a5" alt="Google Sheets OAuth authenticate button and sign-in prompt" width="2018" height="994" data-path="images/cdc/sources/image-56.png" />
    </Frame>
  </Step>
</Steps>

Note that by authorizing this connector, you agree with the following policies:

* [Google Privacy Policy](https://policies.google.com/privacy)

You can revoke access on the [Google Security Settings](https://security.google.com/settings/security/permissions) page.