@mcp-z/mcp-sheets
Preparing search index...
mcp
toolFactories
valuesReplace
Function valuesReplace
valuesReplace
()
:
{
config
:
{
description
:
"Find and replace text across a spreadsheet. Searches all sheets by default, or limit with gid/range. Supports regex with capture groups ($1, $2)."
;
inputSchema
:
ZodObject
<
{
find
:
ZodString
;
gid
:
ZodOptional
<
ZodCoercedString
<
unknown
>
>
;
id
:
ZodString
;
includeFormulas
:
ZodOptional
<
ZodBoolean
>
;
matchCase
:
ZodOptional
<
ZodBoolean
>
;
matchEntireCell
:
ZodOptional
<
ZodBoolean
>
;
range
:
ZodOptional
<
ZodString
>
;
replacement
:
ZodString
;
searchByRegex
:
ZodOptional
<
ZodBoolean
>
;
}
,
$strip
,
>
;
outputSchema
:
ZodObject
<
{
result
:
ZodDiscriminatedUnion
<
[
ZodObject
<
{
formulasChanged
:
ZodNumber
;
id
:
ZodString
;
occurrencesChanged
:
ZodNumber
;
rowsChanged
:
ZodNumber
;
sheetsChanged
:
ZodNumber
;
spreadsheetUrl
:
ZodString
;
type
:
ZodLiteral
<
"success"
>
;
valuesChanged
:
ZodNumber
;
}
,
$strip
,
>
,
ZodObject
<
{}
,
$strip
>
,
]
,
"type"
,
>
;
}
,
$strip
,
>
;
}
;
handler
:
(
__namedParameters
:
{
find
:
string
;
gid
?:
string
;
id
:
string
;
includeFormulas
?:
boolean
;
matchCase
?:
boolean
;
matchEntireCell
?:
boolean
;
range
?:
string
;
replacement
:
string
;
searchByRegex
?:
boolean
;
}
,
extra
:
EnrichedExtra
,
)
=>
Promise
<
{
[
key
:
string
]:
unknown
}
>
;
name
:
string
;
}
Returns
{
config
:
{
description
:
"Find and replace text across a spreadsheet. Searches all sheets by default, or limit with gid/range. Supports regex with capture groups ($1, $2)."
;
inputSchema
:
ZodObject
<
{
find
:
ZodString
;
gid
:
ZodOptional
<
ZodCoercedString
<
unknown
>
>
;
id
:
ZodString
;
includeFormulas
:
ZodOptional
<
ZodBoolean
>
;
matchCase
:
ZodOptional
<
ZodBoolean
>
;
matchEntireCell
:
ZodOptional
<
ZodBoolean
>
;
range
:
ZodOptional
<
ZodString
>
;
replacement
:
ZodString
;
searchByRegex
:
ZodOptional
<
ZodBoolean
>
;
}
,
$strip
,
>
;
outputSchema
:
ZodObject
<
{
result
:
ZodDiscriminatedUnion
<
[
ZodObject
<
{
formulasChanged
:
ZodNumber
;
id
:
ZodString
;
occurrencesChanged
:
ZodNumber
;
rowsChanged
:
ZodNumber
;
sheetsChanged
:
ZodNumber
;
spreadsheetUrl
:
ZodString
;
type
:
ZodLiteral
<
"success"
>
;
valuesChanged
:
ZodNumber
;
}
,
$strip
,
>
,
ZodObject
<
{}
,
$strip
>
,
]
,
"type"
,
>
;
}
,
$strip
,
>
;
}
;
handler
:
(
__namedParameters
:
{
find
:
string
;
gid
?:
string
;
id
:
string
;
includeFormulas
?:
boolean
;
matchCase
?:
boolean
;
matchEntireCell
?:
boolean
;
range
?:
string
;
replacement
:
string
;
searchByRegex
?:
boolean
;
}
,
extra
:
EnrichedExtra
,
)
=>
Promise
<
{
[
key
:
string
]:
unknown
}
>
;
name
:
string
;
}
Settings
Member Visibility
Protected
Inherited
Theme
OS
Light
Dark
@mcp-z/mcp-sheets
Loading...