workspace_append_sheet
Append rows to a Google Sheets table by specifying the spreadsheet ID, range, and values as a JSON 2D array.
Instructions
Append rows to a Google Sheets table (POST — adds rows after the last row in the table)
Input Schema
TableJSON Schema
| Name | Required | Description | Default |
|---|---|---|---|
| spreadsheetId | Yes | Spreadsheet ID (from URL: docs.google.com/spreadsheets/d/{id}) | |
| range | Yes | A1 notation range to detect table (e.g. "Sheet1!A:C") | |
| values | Yes | Rows to append as JSON string 2D array | |
| valueInputOption | No | How values are interpreted: USER_ENTERED parses dates/numbers, RAW stores as-is | USER_ENTERED |
| insertDataOption | No | INSERT_ROWS shifts existing data down; OVERWRITE replaces data below the table | INSERT_ROWS |