Sheets Append
sheets_appendAppend new rows to the end of a Google Sheet table. Specify sheet name and row data to add.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| range | Yes | A1 notation range to append after (e.g., "Sheet1!A1") | |
| values | Yes | Array of rows to append | |
| spreadsheet_id | Yes | Spreadsheet ID | |
| value_input_option | No | How to interpret input. USER_ENTERED (default) parses formulas/dates/numbers. RAW stores literal strings. |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| error | No | Error code if connection required | |
| message | No | Error message if connection required | |
| updatedRows | No | Number of rows appended | |
| updatedCells | No | Total number of cells appended | |
| updatedRange | No | Range where data was appended | |
| spreadsheetId | No | Spreadsheet ID appended to | |
| updatedColumns | No | Number of columns updated |