Sheets Batch Get Values

Immutable Catalog Entry

This descriptor comes from the active versioned Portal catalog.

READgoogle.sheets_batch_get_values

• Contract tier: agent_ready
• Risk: read
• Catalog version: google-2026.07.12.2
• Descriptor hash: 2d272fefb1d5e56f341066ed8ae23d1739356ec43c4f95577bcf58c6650885c3

Use this read-only Google Sheets values tool to read multiple A1 ranges in one call. Returns range values and render metadata. It reads the configured user's Google data through per-request OAuth, does not mutate provider state, and returns a normalized bounded envelope.

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": [],
      "major_dimension": "major_dimension_example",
      "value_render_option": "value_render_option_example",
      "date_time_render_option": "date_time_render_option_example"
    }
  }
}

Arguments Schema

{
  "type": "object",
  "title": "sheets_batch_get_valuesArguments",
  "required": [
    "spreadsheet_id",
    "ranges"
  ],
  "properties": {
    "ranges": {
      "type": "array",
      "items": {
        "type": "string"
      },
      "title": "Ranges",
      "description": "List of A1 notation ranges."
    },
    "spreadsheet_id": {
      "type": "string",
      "title": "Spreadsheet Id",
      "description": "Google Sheets spreadsheet ID."
    },
    "major_dimension": {
      "type": "string",
      "title": "Major Dimension",
      "default": "",
      "description": "Google Sheets major dimension."
    },
    "value_render_option": {
      "type": "string",
      "title": "Value Render Option",
      "default": "",
      "description": "Google Sheets value render option."
    },
    "date_time_render_option": {
      "type": "string",
      "title": "Date Time Render Option",
      "default": "",
      "description": "Google Sheets date/time render option."
    }
  },
  "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-get-values-example",
  "method": "tools/call",
  "params": {
    "name": "google.sheets_batch_get_values",
    "arguments": {
      "spreadsheet_id": "spreadsheet_id_123",
      "ranges": [],
      "major_dimension": "major_dimension_example",
      "value_render_option": "value_render_option_example",
      "date_time_render_option": "date_time_render_option_example"
    }
  }
}'

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-get-values-example",
  "method": "tools/call",
  "params": {
    "name": "google.sheets_batch_get_values",
    "arguments": {
      "spreadsheet_id": "spreadsheet_id_123",
      "ranges": [],
      "major_dimension": "major_dimension_example",
      "value_render_option": "value_render_option_example",
      "date_time_render_option": "date_time_render_option_example"
    }
  }
}),
});
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-get-values-example",
  "method": "tools/call",
  "params": {
    "name": "google.sheets_batch_get_values",
    "arguments": {
      "spreadsheet_id": "spreadsheet_id_123",
      "ranges": [],
      "major_dimension": "major_dimension_example",
      "value_render_option": "value_render_option_example",
      "date_time_render_option": "date_time_render_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_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."
}