Sheets find replace

sheets__find_replace

Access

Requires a project integration connection for sheets.

Call type: Can change resources.

Arguments

FieldTypeRequiredDescription and constraints
spreadsheetIdstringYesGoogle Sheets spreadsheet ID
requestsobject[]YesProvide one or more request values.

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__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

json
{
  "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."
}