Sheets Batch Get Values

Snapshot Catalog Entry

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

POSTgoogle.sheets_batch_get_values

Read values from multiple ranges in a Google Sheet.

Request Body

{
  "jsonrpc": "2.0",
  "id": "google-sheets-batch-get-values-example",
  "method": "tools/call",
  "params": {
    "name": "google.sheets_batch_get_values",
    "arguments": {
      "spreadsheet_id": "spreadsheet_id_123",
      "ranges": [],
      "value_render_option": "value_render_option_example",
      "date_time_render_option": "date_time_render_option_example",
      "major_dimension": "major_dimension_example"
    }
  }
}

Arguments Schema

{
  "properties": {
    "spreadsheet_id": {
      "type": "string"
    },
    "ranges": {
      "items": {
        "type": "string"
      },
      "type": "array"
    },
    "value_render_option": {
      "type": "string"
    },
    "date_time_render_option": {
      "type": "string"
    },
    "major_dimension": {
      "type": "string"
    }
  },
  "required": [
    "spreadsheet_id",
    "ranges"
  ],
  "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-batch-get-values-example",
  "method": "tools/call",
  "params": {
    "name": "google.sheets_batch_get_values",
    "arguments": {
      "spreadsheet_id": "spreadsheet_id_123",
      "ranges": [],
      "value_render_option": "value_render_option_example",
      "date_time_render_option": "date_time_render_option_example",
      "major_dimension": "major_dimension_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-batch-get-values-example",
  "method": "tools/call",
  "params": {
    "name": "google.sheets_batch_get_values",
    "arguments": {
      "spreadsheet_id": "spreadsheet_id_123",
      "ranges": [],
      "value_render_option": "value_render_option_example",
      "date_time_render_option": "date_time_render_option_example",
      "major_dimension": "major_dimension_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-batch-get-values-example",
  "method": "tools/call",
  "params": {
    "name": "google.sheets_batch_get_values",
    "arguments": {
      "spreadsheet_id": "spreadsheet_id_123",
      "ranges": [],
      "value_render_option": "value_render_option_example",
      "date_time_render_option": "date_time_render_option_example",
      "major_dimension": "major_dimension_example"
    }
  }
}
response = requests.post(url, headers=headers, json=payload, timeout=60)
print(response.json())

Example Responses

200 Success

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