@mcp-z/mcp-sheets
Preparing search index...
mcp
toolFactories
rowsAppend
Function rowsAppend
rowsAppend
()
:
{
config
:
{
description
:
"Add new rows to the bottom of an existing sheet with smart header handling and optional deduplication. BEST FOR: Structured database operations where spreadsheet has headers defining schema and rows represent records."
;
inputSchema
:
ZodObject
<
{
deduplicateBy
:
ZodOptional
<
ZodArray
<
ZodString
>
>
;
gid
:
ZodCoercedString
<
unknown
>
;
headers
:
ZodOptional
<
ZodArray
<
ZodString
>
>
;
id
:
ZodString
;
rows
:
ZodArray
<
ZodArray
<
ZodUnion
<
readonly
[
ZodString
,
ZodNumber
,
ZodBoolean
,
ZodNull
]
>
,
>
,
>
;
}
,
$strip
,
>
;
outputSchema
:
ZodObject
<
{
result
:
ZodDiscriminatedUnion
<
[
ZodObject
<
{
gid
:
ZodString
;
id
:
ZodString
;
rowsSkipped
:
ZodOptional
<
ZodNumber
>
;
sheetTitle
:
ZodString
;
sheetUrl
:
ZodOptional
<
ZodString
>
;
type
:
ZodLiteral
<
"success"
>
;
updatedRows
:
ZodNumber
;
}
,
$strip
,
>
,
ZodObject
<
{}
,
$strip
>
,
]
,
"type"
,
>
;
}
,
$strip
,
>
;
}
;
handler
:
(
__namedParameters
:
{
deduplicateBy
?:
string
[]
;
gid
:
string
;
headers
?:
string
[]
;
id
:
string
;
rows
:
(
string
|
number
|
boolean
)
[]
[]
;
}
,
extra
:
EnrichedExtra
,
)
=>
Promise
<
{
[
key
:
string
]:
unknown
}
>
;
name
:
string
;
}
Returns
{
config
:
{
description
:
"Add new rows to the bottom of an existing sheet with smart header handling and optional deduplication. BEST FOR: Structured database operations where spreadsheet has headers defining schema and rows represent records."
;
inputSchema
:
ZodObject
<
{
deduplicateBy
:
ZodOptional
<
ZodArray
<
ZodString
>
>
;
gid
:
ZodCoercedString
<
unknown
>
;
headers
:
ZodOptional
<
ZodArray
<
ZodString
>
>
;
id
:
ZodString
;
rows
:
ZodArray
<
ZodArray
<
ZodUnion
<
readonly
[
ZodString
,
ZodNumber
,
ZodBoolean
,
ZodNull
]
>
,
>
,
>
;
}
,
$strip
,
>
;
outputSchema
:
ZodObject
<
{
result
:
ZodDiscriminatedUnion
<
[
ZodObject
<
{
gid
:
ZodString
;
id
:
ZodString
;
rowsSkipped
:
ZodOptional
<
ZodNumber
>
;
sheetTitle
:
ZodString
;
sheetUrl
:
ZodOptional
<
ZodString
>
;
type
:
ZodLiteral
<
"success"
>
;
updatedRows
:
ZodNumber
;
}
,
$strip
,
>
,
ZodObject
<
{}
,
$strip
>
,
]
,
"type"
,
>
;
}
,
$strip
,
>
;
}
;
handler
:
(
__namedParameters
:
{
deduplicateBy
?:
string
[]
;
gid
:
string
;
headers
?:
string
[]
;
id
:
string
;
rows
:
(
string
|
number
|
boolean
)
[]
[]
;
}
,
extra
:
EnrichedExtra
,
)
=>
Promise
<
{
[
key
:
string
]:
unknown
}
>
;
name
:
string
;
}
Settings
Member Visibility
Protected
Inherited
Theme
OS
Light
Dark
@mcp-z/mcp-sheets
Loading...