mcp-gsheetsTools Reference
sheets_append_values
Append rows to a table
sheets_append_values
Append rows to a table in a spreadsheet.
Parameters
| Parameter | Type | Required | Description |
|---|---|---|---|
spreadsheetId | string | Yes | The spreadsheet ID |
range | string | Yes | A1 notation range (table location) |
values | array[][] | Yes | 2D array of values to append |
valueInputOption | string | No | RAW or USER_ENTERED (default) |
insertDataOption | string | No | OVERWRITE (default) or INSERT_ROWS |
Example
{
"tool": "sheets_append_values",
"arguments": {
"spreadsheetId": "1BxiMVs0XRA5nFMdKvBdBZjgmUUqptlbs74OgvE2upms",
"range": "Sheet1!A:C",
"values": [["New Entry", 42, "2024-01-15"]],
"insertDataOption": "INSERT_ROWS"
}
}Insert Data Options
OVERWRITE- Overwrite existing data (default)INSERT_ROWS- Insert new rows for the data