@mcp-z/mcp-sheets
Preparing search index...
mcp
toolFactories
sheetCopy
Function sheetCopy
sheetCopy
()
:
{
config
:
{
description
:
"Copy a sheet/tab within the same spreadsheet. Supports batch copying: create multiple copies from a single source sheet (e.g., create 12 monthly sheets from a template). Copies all data, formatting, charts, and conditional formatting verbatim."
;
inputSchema
:
ZodObject
<
{
copies
:
ZodArray
<
ZodObject
<
{
insertIndex
:
ZodOptional
<
ZodNumber
>
;
newTitle
:
ZodCoercedString
<
unknown
>
;
}
,
$strip
,
>
,
>
;
gid
:
ZodCoercedString
<
unknown
>
;
id
:
ZodString
;
}
,
$strip
,
>
;
outputSchema
:
ZodObject
<
{
result
:
ZodDiscriminatedUnion
<
[
ZodObject
<
{
completedAt
:
ZodString
;
failures
:
ZodOptional
<
ZodArray
<
ZodObject
<
(...)
,
(...)
>
>
>
;
id
:
ZodString
;
items
:
ZodArray
<
ZodObject
<
{
gid
:
...
;
sheetUrl
:
...
;
title
:
...
}
,
$strip
>
,
>
;
itemsChanged
:
ZodNumber
;
itemsProcessed
:
ZodNumber
;
operationSummary
:
ZodString
;
sourceGid
:
ZodString
;
sourceTitle
:
ZodString
;
type
:
ZodLiteral
<
"success"
>
;
}
,
$strip
,
>
,
ZodObject
<
{}
,
$strip
>
,
]
,
"type"
,
>
;
}
,
$strip
,
>
;
}
;
handler
:
(
__namedParameters
:
{
copies
:
{
insertIndex
?:
number
;
newTitle
:
string
}
[]
;
gid
:
string
;
id
:
string
;
}
,
extra
:
EnrichedExtra
,
)
=>
Promise
<
{
[
key
:
string
]:
unknown
}
>
;
name
:
string
;
}
Returns
{
config
:
{
description
:
"Copy a sheet/tab within the same spreadsheet. Supports batch copying: create multiple copies from a single source sheet (e.g., create 12 monthly sheets from a template). Copies all data, formatting, charts, and conditional formatting verbatim."
;
inputSchema
:
ZodObject
<
{
copies
:
ZodArray
<
ZodObject
<
{
insertIndex
:
ZodOptional
<
ZodNumber
>
;
newTitle
:
ZodCoercedString
<
unknown
>
;
}
,
$strip
,
>
,
>
;
gid
:
ZodCoercedString
<
unknown
>
;
id
:
ZodString
;
}
,
$strip
,
>
;
outputSchema
:
ZodObject
<
{
result
:
ZodDiscriminatedUnion
<
[
ZodObject
<
{
completedAt
:
ZodString
;
failures
:
ZodOptional
<
ZodArray
<
ZodObject
<
(...)
,
(...)
>
>
>
;
id
:
ZodString
;
items
:
ZodArray
<
ZodObject
<
{
gid
:
...
;
sheetUrl
:
...
;
title
:
...
}
,
$strip
>
,
>
;
itemsChanged
:
ZodNumber
;
itemsProcessed
:
ZodNumber
;
operationSummary
:
ZodString
;
sourceGid
:
ZodString
;
sourceTitle
:
ZodString
;
type
:
ZodLiteral
<
"success"
>
;
}
,
$strip
,
>
,
ZodObject
<
{}
,
$strip
>
,
]
,
"type"
,
>
;
}
,
$strip
,
>
;
}
;
handler
:
(
__namedParameters
:
{
copies
:
{
insertIndex
?:
number
;
newTitle
:
string
}
[]
;
gid
:
string
;
id
:
string
;
}
,
extra
:
EnrichedExtra
,
)
=>
Promise
<
{
[
key
:
string
]:
unknown
}
>
;
name
:
string
;
}
Settings
Member Visibility
Protected
Inherited
Theme
OS
Light
Dark
@mcp-z/mcp-sheets
Loading...