gws.sheets.append
Append rows to a Google Sheets table after a specified range. New rows insert below the table, preserving existing data and optionally parsing formulas and dates.
Instructions
Append rows to a Google Spreadsheet after the table that overlaps range, without computing the next empty row yourself. range is the table/range to append after (A1 notation, e.g. 'Sheet1!A1:C1' or 'Sheet1'). values is a JSON array of arrays of scalars (strings/numbers/bools/null); each inner array is one new row. Uses InsertDataOption INSERT_ROWS, so new rows are inserted below the detected table and existing data is preserved (additive, never overwrites). value_input_option defaults to 'USER_ENTERED' (formulas and dates are parsed); pass 'RAW' to append values verbatim. Returns the updated range plus the appended row and cell counts.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| range | Yes | A1-notation table/range to append after (e.g., 'Sheet1!A1:C1' or 'Sheet1') | |
| values | Yes | 2D array of cell values (array of row arrays); each row is appended | |
| account | No | Account label or email. Uses default if omitted. | |
| spreadsheet_id | Yes | The spreadsheet ID | |
| value_input_option | No | 'RAW' or 'USER_ENTERED' (default) |