Append Spreadsheet Values
sheets_append_valuesAppend rows of data to a Google Spreadsheet table. Specify the spreadsheet ID, range, and values to add new rows.
Instructions
Append rows of data to the end of a table in a Google Spreadsheet.
Args:
spreadsheet_id (string): The ID of the Google Spreadsheet
range (string): The A1 notation range defining the table to append to (e.g., 'Sheet1!A:D')
values (array): 2D array of values to append (rows of cells)
value_input_option ('RAW' | 'USER_ENTERED'): How to interpret input (default: 'USER_ENTERED')
insert_data_option ('OVERWRITE' | 'INSERT_ROWS'): How to insert data (default: 'INSERT_ROWS')
Returns: { "spreadsheetId": string, "tableRange": string, "updates": { "updatedRange": string, "updatedRows": number, "updatedCells": number } }
Examples:
Append rows: range="Sheet1!A:D", values=[["Alice", 30, "Engineer", "NYC"]]
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| spreadsheet_id | Yes | The ID of the Google Spreadsheet | |
| range | Yes | The A1 notation range to append to (e.g., 'Sheet1!A:D') | |
| values | Yes | 2D array of values to append (rows of cells) | |
| value_input_option | No | How to interpret input: 'RAW' for literal values, 'USER_ENTERED' to parse formulas | USER_ENTERED |
| insert_data_option | No | How to insert: 'INSERT_ROWS' adds new rows, 'OVERWRITE' overwrites existing | INSERT_ROWS |