@mcp-z/mcp-sheets
Preparing search index...
mcp
toolFactories
spreadsheetMetadataGet
Function spreadsheetMetadataGet
spreadsheetMetadataGet
()
:
{
config
:
{
annotations
:
{
readOnlyHint
:
true
}
;
description
:
"Read full workbook and sheet properties plus charts, named ranges, protections, conditional formats, tables, filters, banded ranges, merges, slicers, developer metadata, data sources and schedules. Returns all sheets without grid data, values or direct cell formatting."
;
inputSchema
:
ZodObject
<
{
id
:
ZodString
}
,
$strict
>
;
outputSchema
:
ZodObject
<
{
result
:
ZodDiscriminatedUnion
<
[
ZodObject
<
{
fieldMask
:
ZodString
;
id
:
ZodString
;
metadata
:
ZodObject
<
{
properties
:
ZodOptional
<
(...)
>
;
sheets
:
ZodOptional
<
(...)
>
;
spreadsheetId
:
ZodString
;
}
,
$loose
,
>
;
type
:
ZodLiteral
<
"success"
>
;
}
,
$strip
,
>
,
ZodObject
<
{}
,
$strip
>
,
]
,
"type"
,
>
;
}
,
$strip
,
>
;
}
;
handler
:
(
__namedParameters
:
{
id
:
string
}
,
extra
:
EnrichedExtra
,
)
=>
Promise
<
{
[
key
:
string
]:
unknown
}
>
;
name
:
string
;
}
Returns
{
config
:
{
annotations
:
{
readOnlyHint
:
true
}
;
description
:
"Read full workbook and sheet properties plus charts, named ranges, protections, conditional formats, tables, filters, banded ranges, merges, slicers, developer metadata, data sources and schedules. Returns all sheets without grid data, values or direct cell formatting."
;
inputSchema
:
ZodObject
<
{
id
:
ZodString
}
,
$strict
>
;
outputSchema
:
ZodObject
<
{
result
:
ZodDiscriminatedUnion
<
[
ZodObject
<
{
fieldMask
:
ZodString
;
id
:
ZodString
;
metadata
:
ZodObject
<
{
properties
:
ZodOptional
<
(...)
>
;
sheets
:
ZodOptional
<
(...)
>
;
spreadsheetId
:
ZodString
;
}
,
$loose
,
>
;
type
:
ZodLiteral
<
"success"
>
;
}
,
$strip
,
>
,
ZodObject
<
{}
,
$strip
>
,
]
,
"type"
,
>
;
}
,
$strip
,
>
;
}
;
handler
:
(
__namedParameters
:
{
id
:
string
}
,
extra
:
EnrichedExtra
,
)
=>
Promise
<
{
[
key
:
string
]:
unknown
}
>
;
name
:
string
;
}
Settings
Member Visibility
Protected
Inherited
Theme
OS
Light
Dark
@mcp-z/mcp-sheets
Loading...