Actions14
- Sheet Actions
- Table Actions
- Workbook Actions
Sheet → Append Row
AI-generatedSummary
Append a new row to a worksheet in a Nextcloud-hosted spreadsheet file by specifying the file and sheet, then providing values for one or more columns.
Inputs
- filePathMode (required) — Choose how to specify the spreadsheet file: select from a folder's file list or provide a file path expression.
- folderPath — If selecting file from list, choose the folder to list files from (default is root).
- filePathFromList — If selecting file from list, pick the spreadsheet file in the chosen folder.
- filePath — If specifying file by path, provide the full file path (expression supported).
- sheetHeaderRow — Row number containing the column headers, default is 1.
- sheetMode (required) — Select the worksheet to append the row to: from list, by name expression, or the first sheet.
- sheetFromList — If selecting sheet from list, choose the worksheet.
- sheetName — If specifying sheet by name, provide its name.
- columnValues (required) — Define one or more column name/value pairs for the new row to be appended.
Output shape
a single JSON object indicating success, operation details, and the appended row data
Returns a JSON object containing success status, operation name ('appendRow'), the sheet name, the appended row data, and the header row number used. Throws an error if file or sheet is not found, or if no file path is specified.
Examples
Example 1: Append a row to a spreadsheet sheet by selecting file and sheet from lists and providing column values.
filePathMode: 'list', folderPath: '/', filePathFromList: 'data.xlsx', sheetHeaderRow: 1, sheetMode: 'list', sheetFromList: 'Sheet1', columnValues: [{name: 'ColumnA', value: 'Value1'}, {name: 'ColumnB', value: 'Value2'}]