अभी शुरू करें
Google Sheets Tools

Googlesheets Update Values Batch

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

राइट Actionजोखिम स्तर 2/5OAuth कनेक्शन
Googlesheets Update Values Batch का उपयोग करें

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

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.

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

मूल्य
मुफ़्त Action
एकीकृत भुगतान
अभी समर्थित नहीं

इनपुट

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

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

  • data
    आवश्यक
    Data from the action execution
  • errorstring
    Error if any occurred during the execution of the action
  • successfulboolean
    आवश्यक
    Whether or not the action execution was successful or not

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

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

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

प्रदाता स्रोत