Append to spreadsheet
google_sheets_appendAdd new rows to a Google Sheet below existing data. Specify the spreadsheet, range, and values to append.
Instructions
Append rows below the existing data in a sheet.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| range | Yes | A1 range of the table to append to, e.g. Sheet1!A1. | |
| values | Yes | Rows of values to append. | |
| account | No | Account nickname to use. | |
| spreadsheetId | Yes | Spreadsheet ID. | |
| valueInputOption | No | How to interpret values (default USER_ENTERED). |