BatchReadSheetDataSchema#

class langchain_google_community.sheets.read_sheet_tools.BatchReadSheetDataSchema[source]#

Bases: ReadBaseSchema

Input schema for BatchReadSheetData.

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 convert_to_records: bool = False#: Whether to convert data to records (list of dictionaries) using first row as headers.

param date_time_render_option: DateTimeRenderOption = DateTimeRenderOption.SERIAL_NUMBER#: How dates, times, and durations should be rendered.

param major_dimension: MajorDimension = MajorDimension.ROWS#: The major dimension that results should use.

param numericise_values: bool = True#: Whether to automatically convert string numbers to numeric types.

param ranges: List[str] [Required]#: List of A1 notation ranges to read from the spreadsheet.

param spreadsheet_id: str [Required]#: The ID of the Google Spreadsheet to read from.

param value_render_option: ValueRenderOption = ValueRenderOption.FORMATTED_VALUE#: How values should be rendered in the output.