Sheets batch update

sheets__batch_update

Access

Requires a project integration connection for sheets.

Call type: Can change resources.

Arguments

FieldTypeRequiredDescription and constraints
spreadsheetIdstringYesGoogle Sheets spreadsheet ID
requestsvalue[]YesGoogle Sheets API batchUpdate request objects
includeSpreadsheetInResponsebooleanNoWhether to include the updated spreadsheet in the response

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__batch_update",
    "arguments": {
      "spreadsheetId": "example",
      "requests": []
    }
  }
}

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"
    },
    "requests": {
      "type": "array",
      "description": "Google Sheets API batchUpdate request objects"
    },
    "includeSpreadsheetInResponse": {
      "type": "boolean",
      "description": "Whether to include the updated spreadsheet in the response"
    }
  },
  "required": [
    "spreadsheetId",
    "requests"
  ],
  "description": "Arguments for the sheets__batch_update tool."
}