Aident logoAident logo centerAident Loadout
Use CasesPricingDocs
ENStart Now
AppsGoogle Sheets ToolsGooglesheets Update Values Batch
Google Sheets Tools

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.

Write actionRisk level 2 of 5OAuth connection
Use Googlesheets Update Values Batch

Pricing and limits

Aident logo

Product

Aident LoadoutAident Playbook EditorOpen-CUAK

About

AppsSkillsUse CasesDocsBlogPricingDownloadsPrivacy PolicyTerms of Service

Alternatives

vs Composiovs Zapier
llms.txtGet an AI summary of Aident LoadoutSummarize with ChatGPTSummarize with ClaudeSummarize with GeminiSummarize with Perplexity

© Aident Labs, 2024-2026

Pricing
Free
Unified payment
Not currently supported

Inputs

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

Observable output

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

Skills that use this Action

Related use cases

  • Submit an AI product to eligible registriesTurn an official product website into a Product Kit, a campaign sheet, and five to ten verified registry submissions powered by TinyFish.

Official source

Provider source

Skills that use this Action

No published Skills explicitly reference this Action yet.