Commencer maintenant
Google Sheets Tools

Googlesheets Update Values Batch

Utilisez Googlesheets Update Values Batch 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 Update Values Batch

Description du fournisseur

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.

Tarifs et limites

Tarif
Action gratuite
Paiement unifié
Non pris en charge actuellement

Entrées

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

Sortie observable

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

Skills qui utilisent cette Action

Cas d’usage associés

Source officielle

Source du fournisseur