Sheets get spreadsheet

sheets__get_spreadsheet

Access

Requires a project integration connection for sheets.

Call type: Can read or manage credentials.

Arguments

FieldTypeRequiredDescription and constraints
spreadsheetIdstringYesGoogle Sheets spreadsheet ID
includeGridDatabooleanNoWhether to include grid data
rangesstring[]NoRanges to include when includeGridData is true

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__get_spreadsheet",
    "arguments": {
      "spreadsheetId": "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"
    },
    "includeGridData": {
      "type": "boolean",
      "description": "Whether to include grid data"
    },
    "ranges": {
      "type": "array",
      "items": {
        "type": "string",
        "description": "One range item supplied to the tool."
      },
      "description": "Ranges to include when includeGridData is true"
    }
  },
  "required": [
    "spreadsheetId"
  ],
  "description": "Arguments for the sheets__get_spreadsheet tool."
}