@mcp-z/mcp-sheets
Preparing search index...
mcp
toolFactories
dimensionsBatchUpdate
Function dimensionsBatchUpdate
dimensionsBatchUpdate
()
:
{
config
:
{
description
:
"Batch update sheet dimensions by inserting, deleting, or appending rows/columns. Operations are atomic (all succeed or all fail) and execute in optimal order automatically."
;
inputSchema
:
ZodObject
<
{
gid
:
ZodCoercedString
<
unknown
>
;
id
:
ZodString
;
requests
:
ZodArray
<
ZodObject
<
{
dimension
:
ZodEnum
<
{
COLUMNS
:
"COLUMNS"
;
ROWS
:
"ROWS"
}
>
;
endIndex
:
ZodOptional
<
ZodNumber
>
;
inheritFromBefore
:
ZodOptional
<
ZodBoolean
>
;
operation
:
ZodEnum
<
{
appendDimension
:
"appendDimension"
;
deleteDimension
:
"deleteDimension"
;
insertDimension
:
"insertDimension"
;
}
,
>
;
startIndex
:
ZodNumber
;
}
,
$strip
,
>
,
>
;
}
,
$strip
,
>
;
outputSchema
:
ZodObject
<
{
result
:
ZodDiscriminatedUnion
<
[
ZodObject
<
{
gid
:
ZodString
;
id
:
ZodString
;
operationResults
:
ZodArray
<
ZodObject
<
{
affectedCount
:
...
;
dimension
:
...
;
endIndex
:
...
;
operation
:
...
;
startIndex
:
...
;
}
,
$strip
,
>
,
>
;
sheetTitle
:
ZodString
;
sheetUrl
:
ZodString
;
spreadsheetTitle
:
ZodString
;
spreadsheetUrl
:
ZodString
;
totalOperations
:
ZodNumber
;
type
:
ZodLiteral
<
"success"
>
;
updatedDimensions
:
ZodObject
<
{
columns
:
ZodNumber
;
rows
:
ZodNumber
}
,
$strip
,
>
;
}
,
$strip
,
>
,
ZodObject
<
{}
,
$strip
>
,
]
,
"type"
,
>
;
}
,
$strip
,
>
;
}
;
handler
:
(
__namedParameters
:
{
gid
:
string
;
id
:
string
;
requests
:
{
dimension
:
"ROWS"
|
"COLUMNS"
;
endIndex
?:
number
;
inheritFromBefore
?:
boolean
;
operation
:
"insertDimension"
|
"deleteDimension"
|
"appendDimension"
;
startIndex
:
number
;
}
[]
;
}
,
extra
:
EnrichedExtra
,
)
=>
Promise
<
{
[
key
:
string
]:
unknown
}
>
;
name
:
string
;
}
Returns
{
config
:
{
description
:
"Batch update sheet dimensions by inserting, deleting, or appending rows/columns. Operations are atomic (all succeed or all fail) and execute in optimal order automatically."
;
inputSchema
:
ZodObject
<
{
gid
:
ZodCoercedString
<
unknown
>
;
id
:
ZodString
;
requests
:
ZodArray
<
ZodObject
<
{
dimension
:
ZodEnum
<
{
COLUMNS
:
"COLUMNS"
;
ROWS
:
"ROWS"
}
>
;
endIndex
:
ZodOptional
<
ZodNumber
>
;
inheritFromBefore
:
ZodOptional
<
ZodBoolean
>
;
operation
:
ZodEnum
<
{
appendDimension
:
"appendDimension"
;
deleteDimension
:
"deleteDimension"
;
insertDimension
:
"insertDimension"
;
}
,
>
;
startIndex
:
ZodNumber
;
}
,
$strip
,
>
,
>
;
}
,
$strip
,
>
;
outputSchema
:
ZodObject
<
{
result
:
ZodDiscriminatedUnion
<
[
ZodObject
<
{
gid
:
ZodString
;
id
:
ZodString
;
operationResults
:
ZodArray
<
ZodObject
<
{
affectedCount
:
...
;
dimension
:
...
;
endIndex
:
...
;
operation
:
...
;
startIndex
:
...
;
}
,
$strip
,
>
,
>
;
sheetTitle
:
ZodString
;
sheetUrl
:
ZodString
;
spreadsheetTitle
:
ZodString
;
spreadsheetUrl
:
ZodString
;
totalOperations
:
ZodNumber
;
type
:
ZodLiteral
<
"success"
>
;
updatedDimensions
:
ZodObject
<
{
columns
:
ZodNumber
;
rows
:
ZodNumber
}
,
$strip
,
>
;
}
,
$strip
,
>
,
ZodObject
<
{}
,
$strip
>
,
]
,
"type"
,
>
;
}
,
$strip
,
>
;
}
;
handler
:
(
__namedParameters
:
{
gid
:
string
;
id
:
string
;
requests
:
{
dimension
:
"ROWS"
|
"COLUMNS"
;
endIndex
?:
number
;
inheritFromBefore
?:
boolean
;
operation
:
"insertDimension"
|
"deleteDimension"
|
"appendDimension"
;
startIndex
:
number
;
}
[]
;
}
,
extra
:
EnrichedExtra
,
)
=>
Promise
<
{
[
key
:
string
]:
unknown
}
>
;
name
:
string
;
}
Settings
Member Visibility
Protected
Inherited
Theme
OS
Light
Dark
@mcp-z/mcp-sheets
Loading...