Sheets Batch Update Values

Immutable Catalog Entry

This descriptor comes from the active versioned Portal catalog.

DESTRUCTIVEgoogle.sheets_batch_update_values

• Contract tier: agent_ready
• Risk: destructive
• Catalog version: google-2026.07.12.2
• Descriptor hash: 500b6b0eed515bbd1ea4441486fabe35fedf2c27dde7d4ea24ada5bf64d66761

Write multiple Google Sheets ranges in one values batchUpdate. It can overwrite, send, move, remove, or permanently delete Google data. Use it only after preview and the manifest-defined confirmation; it requires per-request Google OAuth.

Request Body

{
  "jsonrpc": "2.0",
  "id": "google-sheets-batch-update-values-example",
  "method": "tools/call",
  "params": {
    "name": "google.sheets_batch_update_values",
    "arguments": {
      "spreadsheet_id": "spreadsheet_id_123",
      "data": [],
      "confirm": false,
      "value_input_option": "RAW"
    }
  }
}

Arguments Schema

{
  "type": "object",
  "title": "sheets_batch_update_valuesArguments",
  "required": [
    "spreadsheet_id",
    "data"
  ],
  "properties": {
    "data": {
      "type": "array",
      "items": {
        "type": "object",
        "additionalProperties": true
      },
      "title": "Data",
      "description": "Google Sheets values batch update data entries."
    },
    "confirm": {
      "type": "boolean",
      "title": "Confirm",
      "default": false,
      "description": "Required true for high-risk operations when confirmation is enforced."
    },
    "spreadsheet_id": {
      "type": "string",
      "title": "Spreadsheet Id",
      "description": "Google Sheets spreadsheet ID."
    },
    "value_input_option": {
      "enum": [
        "RAW",
        "USER_ENTERED"
      ],
      "type": "string",
      "title": "Value Input Option",
      "default": "RAW",
      "description": "How Google Sheets should interpret written values."
    }
  },
  "additionalProperties": false
}

Output Schema

{
  "type": "object",
  "required": [
    "ok",
    "data",
    "error",
    "meta"
  ],
  "properties": {
    "ok": {
      "type": "boolean",
      "description": "Whether the local or Google provider operation completed successfully."
    },
    "data": {
      "anyOf": [
        {
          "type": "object",
          "additionalProperties": true
        },
        {
          "type": "array",
          "items": {}
        },
        {
          "type": "string"
        },
        {
          "type": "number"
        },
        {
          "type": "boolean"
        },
        {
          "type": "null"
        }
      ],
      "description": "Bounded local navigation or Google provider result when ok is true."
    },
    "meta": {
      "type": "object",
      "description": "Safe timing, pagination, cache, request, and truncation metadata.",
      "additionalProperties": true
    },
    "error": {
      "anyOf": [
        {
          "type": "object",
          "additionalProperties": true
        },
        {
          "type": "null"
        }
      ],
      "description": "Safe structured error when ok is false."
    }
  },
  "description": "Google MCP normalized operation envelope.",
  "additionalProperties": false
}

Code Examples

cURL

curl -X POST 'https://portal.madpanda3d.com/api/mcp' \
  -H 'Authorization: Bearer mad_live_***' \
  -H 'Content-Type: application/json' \
  -d '{
  "jsonrpc": "2.0",
  "id": "google-sheets-batch-update-values-example",
  "method": "tools/call",
  "params": {
    "name": "google.sheets_batch_update_values",
    "arguments": {
      "spreadsheet_id": "spreadsheet_id_123",
      "data": [],
      "confirm": false,
      "value_input_option": "RAW"
    }
  }
}'

Node.js

const response = await fetch('https://portal.madpanda3d.com/api/mcp', {
  method: 'POST',
  headers: {
    Authorization: 'Bearer mad_live_***',
    'Content-Type': 'application/json',
  },
  body: JSON.stringify({
  "jsonrpc": "2.0",
  "id": "google-sheets-batch-update-values-example",
  "method": "tools/call",
  "params": {
    "name": "google.sheets_batch_update_values",
    "arguments": {
      "spreadsheet_id": "spreadsheet_id_123",
      "data": [],
      "confirm": false,
      "value_input_option": "RAW"
    }
  }
}),
});
const data = await response.json();
console.log(data);

Python

import requests

url = 'https://portal.madpanda3d.com/api/mcp'
headers = {
    'Authorization': 'Bearer mad_live_***',
    'Content-Type': 'application/json',
}
payload = {
  "jsonrpc": "2.0",
  "id": "google-sheets-batch-update-values-example",
  "method": "tools/call",
  "params": {
    "name": "google.sheets_batch_update_values",
    "arguments": {
      "spreadsheet_id": "spreadsheet_id_123",
      "data": [],
      "confirm": false,
      "value_input_option": "RAW"
    }
  }
}
response = requests.post(url, headers=headers, json=payload, timeout=60)
print(response.json())

Example Responses

200 Success

{
  "ok": true,
  "message": "Tool google.sheets_batch_update_values executed successfully.",
  "note": "Response shape varies by MCP tool. Inspect live responses for exact fields."
}

502 Upstream Error

{
  "ok": false,
  "classification": "upstream_http_error",
  "message": "Upstream MCP returned a non-success status."
}