Googlesheets Update Values Batch

通过 Aident Loadout 使用 Google Sheets Tools 的 Googlesheets Update Values Batch。执行前查看输入、输出、设置、价格和风险。

写入操作风险等级 2/5OAuth 连接

服务提供商说明

Tool to set values in one or more ranges of a spreadsheet. Use when you need to update multiple ranges in a single operation for better performance.

dataarray
必填
The new values to apply to the spreadsheet. Each ValueRange specifies a range and the values to write to that range. Multiple ranges can be updated in a single request.
spreadsheet_idstring
必填
The ID of the spreadsheet to update. This ID can be found in the URL of the spreadsheet (e.g., https://docs.google.com/spreadsheets/d/{spreadsheet_id}/edit). Must be a valid Google Sheets spreadsheet ID.
valueInputOptionstring
必填
How the input data should be interpreted. RAW: Values are stored exactly as entered, without parsing. USER_ENTERED: Values are parsed as if typed by a user (numbers stay numbers, strings prefixed with '=' become formulas, etc.). INPUT_VALUE_OPTION_UNSPECIFIED: Default input valu…
includeValuesInResponseboolean
Determines if the update response should include the values of the cells that were updated. By default, responses do not include the updated values.
responseValueRenderOptionstring
Determines how values in the response should be rendered. Only used if includeValuesInResponse is true. FORMATTED_VALUE (default): Values are formatted as displayed in the UI. UNFORMATTED_VALUE: Values are unformatted. FORMULA: Formulas are not evaluated.
responseDateTimeRenderOptionstring
Determines how dates, times, and durations in the response should be rendered. Only used if includeValuesInResponse is true. SERIAL_NUMBER (default): Dates are returned as numbers. FORMATTED_STRING: Dates are returned as formatted strings.