Empezar ahora
Google Sheets Tools

Googlesheets Update Values Batch

Usa Googlesheets Update Values Batch con Google Sheets Tools mediante Aident Loadout. Revisa sus entradas, salidas, configuración, precio y riesgo antes de ejecutarla.

Action de escrituraNivel de riesgo 2 de 5Conexión OAuth
Usar Googlesheets Update Values Batch

Descripción del proveedor

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.

Precios y límites

Precio
Action gratuita
Pago unificado
No compatible actualmente

Entradas

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

Salida observable

  • data
    Obligatorio
    Data from the action execution
  • errorstring
    Error if any occurred during the execution of the action
  • successfulboolean
    Obligatorio
    Whether or not the action execution was successful or not

Skills que usan esta Action

Casos de uso relacionados

Fuente oficial

Fuente del proveedor