Googlesheets Values Update

Utilisez Googlesheets Values Update avec Google Sheets Tools via Aident Loadout. Vérifiez les entrées, sorties, la configuration, le tarif et le risque avant exécution.

Action d'écritureNiveau de risque 2 sur 5Connexion OAuth

Utiliser Googlesheets Values Update

Description du fournisseur

Tool to set values in a range of a Google Spreadsheet. Use when you need to update or overwrite existing cell values in a specific range.

Preparing Your Aident Workspace...

Entrées

rangestring
Obligatoire
The A1 notation of the range to update values in (e.g., 'Sheet1!A1:C2', 'MySheet!C:C', or 'A1:D5'). Must be actual cell references, not placeholder values. If the sheet name is omitted (e.g., 'A1:B2'), the operation applies to the first visible sheet. IMPORTANT: The range must n…
valuesarray
Obligatoire
The data to write. This is an array of arrays, the outer array representing all the data and each inner array representing a major dimension. Each item in the inner array corresponds with one cell.
spreadsheet_idstring
Obligatoire
The unique identifier of the Google 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 non-empty string.
major_dimensionstring
The major dimension of the values. ROWS (default) means each inner array is a row of values. COLUMNS means each inner array is a column of values. Defaults to ROWS if unspecified.
auto_expand_sheetboolean
If True (default), automatically expands the sheet's dimensions (adds columns/rows) when the target range exceeds the current grid limits. If False, the operation will fail with an error if the range exceeds grid limits.
value_input_optionstring
Obligatoire
How the input data should be interpreted. RAW: Values are stored exactly as entered, without parsing (dates, formulas, etc. remain as strings). USER_ENTERED: Values are parsed as if typed by a user (numbers stay numbers, strings prefixed with '=' become formulas, etc.).
include_values_in_responseboolean
Determines if the update response should include the values of the cells that were updated. By default, responses do not include the updated values.
response_value_render_optionstring
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 (numbers, booleans, formulas). FORMULA: Formulas are not eval…
response_datetime_render_optionstring
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 strings formatted per the cell's locale.

Googlesheets Values Update

Description du fournisseur

Googlesheets Values Update

Description du fournisseur

Tarifs et limites

Entrées

Sortie observable

Skills qui utilisent cette Action

Skills qui utilisent cette Action

Cas d’usage associés

Source officielle

Skills qui utilisent cette Action