Sheets Update Values

Snapshot Catalog Entry

This page is generated from broker tools/list snapshot data.

POSTgoogle.sheets_update_values

Write values to a Google Sheet range.

Request Body

{
  "jsonrpc": "2.0",
  "id": "google-sheets-update-values-example",
  "method": "tools/call",
  "params": {
    "name": "google.sheets_update_values",
    "arguments": {
      "spreadsheet_id": "spreadsheet_id_123",
      "range_a1": "range_a1_example",
      "values": [],
      "value_input_option": "value_input_option_example"
    }
  }
}

Arguments Schema

{
  "properties": {
    "spreadsheet_id": {
      "type": "string"
    },
    "range_a1": {
      "type": "string"
    },
    "values": {
      "items": {
        "items": {
          "anyOf": [
            {
              "type": "string"
            },
            {
              "type": "integer"
            },
            {
              "type": "number"
            },
            {
              "type": "boolean"
            },
            {
              "type": "null"
            }
          ]
        },
        "type": "array"
      },
      "type": "array"
    },
    "value_input_option": {
      "type": "string"
    }
  },
  "required": [
    "spreadsheet_id",
    "range_a1",
    "values"
  ],
  "type": "object"
}

Code Examples

cURL

curl -X POST 'https://madpanda3d.com/lab/mad-mcps/portal/api/mcp' \
  -H 'Authorization: Bearer mad_live_***' \
  -H 'Content-Type: application/json' \
  -d '{
  "jsonrpc": "2.0",
  "id": "google-sheets-update-values-example",
  "method": "tools/call",
  "params": {
    "name": "google.sheets_update_values",
    "arguments": {
      "spreadsheet_id": "spreadsheet_id_123",
      "range_a1": "range_a1_example",
      "values": [],
      "value_input_option": "value_input_option_example"
    }
  }
}'

Node.js

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

Python

import requests

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

Example Responses

200 Success

{
  "ok": true,
  "message": "Tool google.sheets_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."
}