spreadsheets_values_get

GET

gsheets_spreadsheets_values_get.py

from charter.packs import gsheets

result = await gsheets.spreadsheets_values_get.ainvoke({"spreadsheetId": ..., "range": ...})

Requires https://www.googleapis.com/auth/spreadsheets. Costs 1 against the provider’s own quota.

Path parameters

Field	Type	Description
`spreadsheetId` *	`string`	The ID of the spreadsheet to retrieve data from.
`range` *	`string`	The A1 notation or R1C1 notation of the range to retrieve values from.

Field	Type	Description
`majorDimension`	Dimension	The major dimension that results should use. For example, if the spreadsheet data in Sheet1 is: A1=1,B1=2,A2=3,B2=4, then requesting range=Sheet1!A1:B2?majorDimension=ROWS returns [[1,2],[3,4]], whereas requesting range=Sheet1!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.