Append rows to a Google Sheet
append_to_sheetAdd rows of data to an existing Google Sheet at a specified range. Use with a spreadsheet ID from Hermoso or Drive to keep records updated.
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.
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 |