Append rows to a Google Sheet
append_to_sheetAppend rows of data to an existing Google Sheet by spreadsheet ID, whether it was created in Hermoso or picked from Drive, with an optional range targeting a specific sheet.
Instructions
Append rows to a Google Sheet Hermoso can reach — one it created (pass the spreadsheetId from create_sheet) or one the user handed over with the Google file picker in the app (find its id with list_drive_files). rows = array of row arrays.
Tool call template
Replace each placeholder with a value matching the input schema. Only required parameters are included; add optional parameters as needed.
{
"id": 1,
"jsonrpc": "2.0",
"method": "tools/call",
"params": {
"arguments": {
"spreadsheetId": "<spreadsheetId>",
"rows": "<rows>"
},
"name": "append_to_sheet"
}
}Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| rows | Yes | rows to append — array of row arrays | |
| range | No | range to append at (default A1 / first sheet) | |
| spreadsheetId | Yes | the spreadsheet id from create_sheet |