GetSpreadsheetInfoSchema#

class langchain_google_community.sheets.get_spreadsheet_info.GetSpreadsheetInfoSchema[source]#

Bases: BaseModel

Input schema for GetSpreadsheetInfo.

Create a new model by parsing and validating input data from keyword arguments.

Raises [ValidationError][pydantic_core.ValidationError] if the input data cannot be validated to form a valid model.

self is explicitly positional-only to allow self as a field name.

param fields: str | None = None#

Specific fields to return (e.g., ‘sheets.properties.title,sheets.properties.sheetId’). If None, returns all available fields.

param include_formatting: bool = False#

Whether to include cell formatting information when include_grid_data is True.

param include_grid_data: bool = False#

Whether to include detailed grid data (cell properties, formatting). Note: This can significantly increase response size.

param include_validation: bool = False#

Whether to include data validation rules when include_grid_data is True.

param ranges: List[str] | None = None#

Specific ranges to get information about. If None, gets info for all sheets.

param spreadsheet_id: str [Required]#

The ID of the Google Spreadsheet to get information about. Can be extracted from URL or provided directly.