spreadsheets_values_update - Charter Docs

PUT

gsheets_spreadsheets_values_update.py

import asyncio

from charter.packs import gsheets

result = asyncio.run(gsheets.spreadsheets_values_update.ainvoke({"spreadsheetId": ..., "range": ..., "valueInputOption": ..., "valueRange": ...}))

Requires https://www.googleapis.com/auth/spreadsheets 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 update.
`range` *	`string`	The A1 notation of the values to update.

Query parameters

Field	Type	Description
`valueInputOption` *	ValueInputOption	How the input data should be interpreted.
`includeValuesInResponse`	`boolean`	Determines if the update response should include the values of the cells that were updated. By default, responses do not include the updated values. If the range to write was larger than the range actually written, the response includes all values in the requested range (excluding trailing empty rows and columns).
`responseValueRenderOption`	ValueRenderOption	Determines how values in the response should be rendered. The default render option is FORMATTED_VALUE.
`responseDateTimeRenderOption`	DateTimeRenderOption	Determines how dates, times, and durations in the response should be rendered. This is ignored if responseValueRenderOption is FORMATTED_VALUE. The default dateTime render option is SERIAL_NUMBER.

Body

Field	Type	Description
`valueRange` *	ValueRange	The request body contains an instance of ValueRange.