POST
gsheets_spreadsheets_batch_update.py
from charter.packs import gsheets
result = await gsheets.spreadsheets_batch_update.ainvoke({"spreadsheetId": ..., "requests": ...})
Requires
https://www.googleapis.com/auth/spreadsheets. Costs 1 against the provider’s own quota.This tool’s JSON schema is 190 KB, because Three of the 74 are kept here. Which ones your agent needs is yours to pick. The tool underneath is unchanged.
See Projections.
requests carries 74 kinds of edit behind one method.
That is more context than most tasks. Narrow it at the call site
with Tool.derived:narrowed = gsheets.spreadsheets_batch_update.derived(
name="spreadsheets_batch_update_narrowed",
keep={"update_spreadsheet_properties", "update_sheet_properties", "update_dimension_properties"},
)
Path parameters
| Field | Type | Description |
|---|---|---|
spreadsheetId * | string | The spreadsheet to apply the updates to. |
Body
| Field | Type | Description |
|---|---|---|
requests * | Request[] | A list of updates to apply to the spreadsheet. Requests will be applied in the order they are specified. Each Request sets exactly one kind of update. If any request is not valid, no requests will be applied. |
includeSpreadsheetInResponse | boolean | Determines if the update response should include the spreadsheet resource. |
responseRanges | string[] | Limits the ranges included in the response spreadsheet. Meaningful only if includeSpreadsheetInResponse is ‘true’. |
responseIncludeGridData | boolean | True if grid data should be returned. Meaningful only if includeSpreadsheetInResponse is ‘true’. This parameter is ignored if a field mask was set in the request. |
commentsViewMode | CommentsViewMode | The comments view mode to apply to the spreadsheet. This allows viewing the spreadsheet with comments omitted or included. If one is not specified, COMMENTS_VIEW_MODE_OMITTED is used. Meaningful only if includeSpreadsheetInResponse is ‘true’. Developer Preview. |