Google Sheets integration

Batch Update Values

Perform Batch Update Values through Google Sheets.

View as Markdown

google_sheets_batch_update_values

write

Inputs

spreadsheet_id
expressionrequired
Spreadsheet Id
Required literal value or workflow expression.
data
jsonrequired
Data
Required JSON value.
value_input_option
select
Value Input Option
Optional selected identifier or value.
Default: "RAW"
Options: Raw ("RAW"), User Entered ("USER_ENTERED")
expected_data
json
Expected Data
Optional JSON value.
require_expected_match
boolean
Require Expected Match
Optional true-or-false value.
Default: false
write_enabled
boolean
Write Enabled
Optional true-or-false value.
Default: false

Outputs

successSuccess
submittedSubmitted
write_skippedWrite Skipped
skip_reasonSkip Reason
conflictConflict
conflicting_rangesConflicting Ranges
spreadsheet_idSpreadsheet Id
updated_range_countUpdated Range Count
updated_rowsUpdated Rows
updated_columnsUpdated Columns
updated_cellsUpdated Cells
errorError
error_messageError Message

Output schema completeness: best_effort_declared

Safety

External effect: write
Confirmation recommended: No
Retry safe: No
Dry run supported: No

Schemas

These schemas are first-pass authoring guidance. Runtime validation remains authoritative.

Input schema

{
  "type": "object",
  "required": [
    "spreadsheet_id",
    "data"
  ],
  "properties": {
    "data": {
      "description": "Required JSON value.",
      "x-workflow-field-type": "json"
    },
    "expected_data": {
      "description": "Optional JSON value.",
      "x-workflow-field-type": "json"
    },
    "write_enabled": {
      "type": "boolean",
      "default": false,
      "description": "Optional true-or-false value.",
      "x-workflow-field-type": "boolean"
    },
    "spreadsheet_id": {
      "description": "Required literal value or workflow expression.",
      "x-workflow-field-type": "expression"
    },
    "value_input_option": {
      "enum": [
        "RAW",
        "USER_ENTERED"
      ],
      "type": "string",
      "default": "RAW",
      "description": "Optional selected identifier or value.",
      "x-workflow-field-type": "select"
    },
    "require_expected_match": {
      "type": "boolean",
      "default": false,
      "description": "Optional true-or-false value.",
      "x-workflow-field-type": "boolean"
    }
  },
  "additionalProperties": false
}

Output schema

{
  "type": "object",
  "properties": {
    "error": {},
    "success": {},
    "conflict": {},
    "submitted": {},
    "skip_reason": {},
    "updated_rows": {},
    "error_message": {},
    "updated_cells": {},
    "write_skipped": {},
    "spreadsheet_id": {},
    "updated_columns": {},
    "conflicting_ranges": {},
    "updated_range_count": {}
  },
  "additionalProperties": true
}

View all Google Sheets actions