sheets_append_values
Append rows of data to the end of a table in Google Sheets, either overwriting empty cells or inserting new rows.
Instructions
Append values to the end of a table in a Google Sheets spreadsheet. IMPORTANT: By default, this will OVERWRITE existing empty cells. To INSERT new rows instead, set insertDataOption to "INSERT_ROWS".
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| range | Yes | The A1 notation range of the table to append to (e.g., "Sheet1!A:B") | |
| values | Yes | A 2D array of values to append, where each inner array represents a row | |
| spreadsheetId | Yes | The ID of the spreadsheet (found in the URL after /d/) | |
| insertDataOption | No | How the input data should be inserted (default: OVERWRITE) | |
| valueInputOption | No | How the input data should be interpreted (default: USER_ENTERED) |