spreadsheets_values_batch_get - Charter Docs

GET

gsheets_spreadsheets_values_batch_get.py

import asyncio

from charter.packs import gsheets

result = asyncio.run(gsheets.spreadsheets_values_batch_get.ainvoke({"spreadsheetId": ..., "ranges": ...}))

Requires https://www.googleapis.com/auth/spreadsheets.readonly, or any of https://www.googleapis.com/auth/spreadsheets, https://www.googleapis.com/auth/drive.readonly or https://www.googleapis.com/auth/drive. Costs 1 against the provider’s own quota.

Path parameters

Field	Type	Description
`spreadsheetId` *	`string`	The ID of the spreadsheet to retrieve data from.

Query parameters

Field	Type	Description
`ranges` *	`string`[]	The A1 notation or R1C1 notation of the range to retrieve values from. min 1 items
`majorDimension`	Dimension	The major dimension that results should use. For example, if the spreadsheet data is: A1=1,B1=2,A2=3,B2=4, then requesting ranges=[“A1:B2”],majorDimension=ROWS returns [[1,2],[3,4]], whereas requesting ranges=[“A1:B2”],majorDimension=COLUMNS returns [[1,3],[2,4]].
`valueRenderOption`	ValueRenderOption	How values should be represented in the output. The default render option is FORMATTED_VALUE.
`dateTimeRenderOption`	DateTimeRenderOption	How dates, times, and durations should be represented in the output. This is ignored if valueRenderOption is FORMATTED_VALUE. The default dateTime render option is SERIAL_NUMBER.