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