Sheets read range

sheets__read_range

Access

Requires a project integration connection for sheets.

Call type: Can read or manage credentials.

Arguments

FieldTypeRequiredDescription and constraints
spreadsheetIdstringYesGoogle Sheets spreadsheet ID
rangestringYesA1 notation range to read
majorDimensionstringNoMajor dimension for returned values
valueRenderOptionstringNoHow values should be rendered

Example request

Send this JSON-RPC request through an initialized MCP client. Replace sample identifiers and values before calling the tool. See MCP client setup.

json
{
  "jsonrpc": "2.0",
  "id": 1,
  "method": "tools/call",
  "params": {
    "name": "sheets__read_range",
    "arguments": {
      "spreadsheetId": "example",
      "range": "example"
    }
  }
}

Result

No output schema is published for this tool. The input contract does not define its return fields. Inspect the MCP response content and isError; do not assume a fixed object shape. See the sheets integration reference for provider setup and tool context.

Full schemas

json
{
  "type": "object",
  "properties": {
    "spreadsheetId": {
      "type": "string",
      "description": "Google Sheets spreadsheet ID"
    },
    "range": {
      "type": "string",
      "description": "A1 notation range to read"
    },
    "majorDimension": {
      "type": "string",
      "description": "Major dimension for returned values"
    },
    "valueRenderOption": {
      "type": "string",
      "description": "How values should be rendered"
    }
  },
  "required": [
    "spreadsheetId",
    "range"
  ],
  "description": "Arguments for the sheets__read_range tool."
}