# Batch Update Values

> Perform Batch Update Values through Google Sheets.

Source: [https://genhealth.ai/docs/workflows/integrations/google-sheets/google_sheets_batch_update_values](https://genhealth.ai/docs/workflows/integrations/google-sheets/google_sheets_batch_update_values)

Integration: [Google Sheets](https://genhealth.ai/docs/workflows/integrations/google-sheets.md)

- Handler: `google_sheets_batch_update_values`

## Inputs

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

## Outputs

- `success` — Success
- `submitted` — Submitted
- `write_skipped` — Write Skipped
- `skip_reason` — Skip Reason
- `conflict` — Conflict
- `conflicting_ranges` — Conflicting Ranges
- `spreadsheet_id` — Spreadsheet Id
- `updated_range_count` — Updated Range Count
- `updated_rows` — Updated Rows
- `updated_columns` — Updated Columns
- `updated_cells` — Updated Cells
- `error` — Error
- `error_message` — Error 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

```json
{
  "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

```json
{
  "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
}
```