@mcp-z/mcp-sheets
Preparing search index...
mcp
toolFactories
cellsMetadataGet
Function cellsMetadataGet
cellsMetadataGet
()
:
{
config
:
{
annotations
:
{
readOnlyHint
:
true
}
;
description
:
"Read notes, data validation rules, pivot table and data-source table definitions in required finite ranges on one sheet. Preserves sparse row/column offsets. Excludes cell values, formulas and direct formatting. DATA_SOURCE and OBJECT sheets are unsupported."
;
inputSchema
:
ZodObject
<
{
gid
:
ZodPipe
<
ZodUnion
<
readonly
[
ZodString
,
ZodNumber
]
>
,
ZodTransform
<
string
,
string
|
number
>
,
>
;
id
:
ZodString
;
ranges
:
ZodArray
<
ZodString
>
;
}
,
$strict
,
>
;
outputSchema
:
ZodObject
<
{
result
:
ZodDiscriminatedUnion
<
[
ZodObject
<
{
fieldMask
:
ZodString
;
gid
:
ZodString
;
id
:
ZodString
;
metadata
:
ZodObject
<
{
sheets
:
ZodOptional
<
(...)
>
;
spreadsheetId
:
ZodString
}
,
$loose
,
>
;
requestedRanges
:
ZodArray
<
ZodString
>
;
type
:
ZodLiteral
<
"success"
>
;
}
,
$strip
,
>
,
ZodObject
<
{}
,
$strip
>
,
]
,
"type"
,
>
;
}
,
$strip
,
>
;
}
;
handler
:
(
input
:
{
gid
:
string
;
id
:
string
;
ranges
:
string
[]
}
,
extra
:
EnrichedExtra
,
)
=>
Promise
<
{
[
key
:
string
]:
unknown
}
>
;
name
:
string
;
}
Returns
{
config
:
{
annotations
:
{
readOnlyHint
:
true
}
;
description
:
"Read notes, data validation rules, pivot table and data-source table definitions in required finite ranges on one sheet. Preserves sparse row/column offsets. Excludes cell values, formulas and direct formatting. DATA_SOURCE and OBJECT sheets are unsupported."
;
inputSchema
:
ZodObject
<
{
gid
:
ZodPipe
<
ZodUnion
<
readonly
[
ZodString
,
ZodNumber
]
>
,
ZodTransform
<
string
,
string
|
number
>
,
>
;
id
:
ZodString
;
ranges
:
ZodArray
<
ZodString
>
;
}
,
$strict
,
>
;
outputSchema
:
ZodObject
<
{
result
:
ZodDiscriminatedUnion
<
[
ZodObject
<
{
fieldMask
:
ZodString
;
gid
:
ZodString
;
id
:
ZodString
;
metadata
:
ZodObject
<
{
sheets
:
ZodOptional
<
(...)
>
;
spreadsheetId
:
ZodString
}
,
$loose
,
>
;
requestedRanges
:
ZodArray
<
ZodString
>
;
type
:
ZodLiteral
<
"success"
>
;
}
,
$strip
,
>
,
ZodObject
<
{}
,
$strip
>
,
]
,
"type"
,
>
;
}
,
$strip
,
>
;
}
;
handler
:
(
input
:
{
gid
:
string
;
id
:
string
;
ranges
:
string
[]
}
,
extra
:
EnrichedExtra
,
)
=>
Promise
<
{
[
key
:
string
]:
unknown
}
>
;
name
:
string
;
}
Settings
Member Visibility
Protected
Inherited
Theme
OS
Light
Dark
@mcp-z/mcp-sheets
Loading...