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.
| 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 replicationPrerequisites
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/\{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/\{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 | ✔ |
Note that by authorizing this connector, you agree with the following policies:
You can revoke access on the Google Security Settings page.
