Google Sheets

Google Sheets is a web-based spreadsheet application. This module provides functionality to load and process data from Google Sheets documents, supporting various data formatting options and sheet selection.

This module provides a sophisticated Google Sheets document loader that can:

• Load data from multiple spreadsheets

• Select specific sheets and ranges

• Handle formatted and unformatted values

• Process formulas and calculations

• Customize header handling

• Process content with text splitters

• Handle OAuth2 authentication

Inputs

Required Parameters

• Connect Credential: Google Sheets OAuth2 credentials. Refer to #Google Sheets
• Select Spreadsheet: Choose spreadsheet(s) from your Google Drive

Optional Parameters

• Sheet Names: Comma-separated list of sheet names to load

• Range: Specific range to load (e.g., A1:E10)

• Include Headers: Whether to include first row as headers (default: true)

• Value Render Option: How values should be represented:

  • Formatted Value: As shown in the UI

  • Unformatted Value: Raw values

  • Formula: Original formulas

• Text Splitter: A text splitter to process the extracted content

• Additional Metadata: JSON object with additional metadata

• Omit Metadata Keys: Comma-separated list of metadata keys to omit

Outputs

• Document: Array of document objects containing metadata and pageContent

• Text: Concatenated string from pageContent of documents

Features

• OAuth2 authentication

• Multiple spreadsheet support

• Sheet selection

• Range specification

• Header handling

• Value formatting options

• Text splitting support

• Metadata customization

Value Render Options

Formatted Value

• Values as displayed in UI

• Includes formatting

• Numbers with decimals/currency

• Dates in specified format

Unformatted Value

• Raw cell values

• Numbers without formatting

• Dates as serial numbers

• Boolean as true/false

Formula

• Original formulas

• Cell references

• Functions

• Calculations

Document Structure

Each document contains:

• pageContent: Formatted sheet content

• metadata:

  • spreadsheetId: Google Sheets ID

  • spreadsheetName: Document name

  • sheetName: Sheet name

  • range: Selected range

  • headers: Column headers (if included)

  • lastModified: Last modification date

  • url: Web view link

  • Additional custom metadata

Notes

• Requires OAuth2 authentication

• Handles rate limiting

• Supports large spreadsheets

• Memory-efficient processing

• Error handling for invalid ranges

• Automatic token refresh

• Real-time data access