Googlesheets Values Update

Aident Loadout के माध्यम से Google Sheets Tools के साथ Googlesheets Values Update का उपयोग करें। चलाने से पहले इनपुट, आउटपुट, सेटअप, मूल्य और जोखिम देखें।

राइट Actionजोखिम स्तर 2/5OAuth कनेक्शन

Googlesheets Values Update का उपयोग करें

प्रदाता विवरण

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...

इनपुट

rangestring
आवश्यक
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
आवश्यक
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
आवश्यक
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
आवश्यक
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

प्रदाता विवरण

Googlesheets Values Update

प्रदाता विवरण

मूल्य और सीमाएँ

इनपुट

देखा जा सकने वाला आउटपुट

इस Action का उपयोग करने वाली Skills

इस Action का उपयोग करने वाली Skills

संबंधित उपयोग के मामले

आधिकारिक स्रोत

इस Action का उपयोग करने वाली Skills