The Google Sheets connector synchronizes spreadsheet data into your knowledge base. Each sheet tab becomes a separate document.
Authentication
OAuth — requires scope: https://www.googleapis.com/auth/drive
Configuration
| Field | Type | Required | Description |
|---|---|---|---|
| Spreadsheet ID | Input | Yes | From the spreadsheet URL |
| Sheet Filter | Dropdown | No | All sheets or First sheet only |
How It Works
- Metadata Fetch — Gets spreadsheet title, sheet names, and grid properties
- Modified Time — Fetches
modifiedTimeseparately from Drive API - Value Extraction — First row treated as headers; subsequent rows as data
- Formatting — Each row rendered as labeled key-value pairs
Document Format
Row 1:
Header1: value1
Header2: value2
Row 2:
Header1: value3
Header2: value4Metadata Tags
| Tag | Type | Description |
|---|---|---|
| Sheet Name | Text | The sheet tab name |
| Row Count | Number | Number of data rows |
| Column Count | Number | Number of columns |
| Last Modified | Date | From Drive API modifiedTime |
Limitations
- Maximum 10,000 rows per sheet
- Maximum 3 concurrent sheet fetches