sheets__find_replace
Access
Requires a project integration connection for sheets.
Call type: Can change resources.
Arguments
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.
{
"jsonrpc": "2.0",
"id": 1,
"method": "tools/call",
"params": {
"name": "sheets__find_replace",
"arguments": {
"spreadsheetId": "example",
"requests": [
{
"findReplace": {
"find": "example",
"replacement": "example",
"range": {
"sheetId": 0
}
}
}
]
}
}
}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
{
"type": "object",
"properties": {
"spreadsheetId": {
"type": "string",
"description": "Google Sheets spreadsheet ID"
},
"requests": {
"type": "array",
"minItems": 1,
"items": {
"type": "object",
"required": [
"findReplace"
],
"additionalProperties": false,
"properties": {
"findReplace": {
"type": "object",
"required": [
"find",
"replacement"
],
"properties": {
"find": {
"type": "string",
"description": "Provide the find."
},
"replacement": {
"type": "string",
"description": "Provide the replacement."
},
"allSheets": {
"type": "boolean",
"const": true,
"description": "Provide the all sheets."
},
"sheetId": {
"type": "integer",
"minimum": 0,
"description": "Provide the sheet id."
},
"matchCase": {
"type": "boolean",
"description": "Provide the match case."
},
"matchEntireCell": {
"type": "boolean",
"description": "Provide the match entire cell."
},
"searchByRegex": {
"type": "boolean",
"description": "Provide the search by regex."
},
"includeFormulas": {
"type": "boolean",
"description": "Provide the include formulas."
},
"range": {
"type": "object",
"description": "Grid range with the actual sheet ID from spreadsheet metadata and zero-based, end-exclusive indexes.",
"required": [
"sheetId"
],
"properties": {
"sheetId": {
"type": "integer",
"minimum": 0,
"description": "Provide the sheet id."
},
"startRowIndex": {
"type": "integer",
"minimum": 0,
"description": "Provide the start row index."
},
"endRowIndex": {
"type": "integer",
"minimum": 0,
"description": "Provide the end row index."
},
"startColumnIndex": {
"type": "integer",
"minimum": 0,
"description": "Provide the start column index."
},
"endColumnIndex": {
"type": "integer",
"minimum": 0,
"description": "Provide the end column index."
}
},
"additionalProperties": false
}
},
"oneOf": [
{
"properties": {
"range": {
"description": "Provide the range."
}
},
"required": [
"range"
],
"description": "Provide the find replace."
},
{
"properties": {
"sheetId": {
"description": "Provide the sheet id."
}
},
"required": [
"sheetId"
],
"description": "Provide the find replace."
},
{
"properties": {
"allSheets": {
"description": "Provide the all sheets."
}
},
"required": [
"allSheets"
],
"description": "Provide the find replace."
}
],
"additionalProperties": false,
"description": "Structured find replace details used by the tool."
}
},
"description": "One request item supplied to the tool."
},
"description": "Provide one or more request values."
}
},
"required": [
"spreadsheetId",
"requests"
],
"description": "Arguments for the sheets__find_replace tool."
}