NextCloud SpreadsheetInstall

Summary

Update a specific data row in a worksheet (sheet) within a spreadsheet file stored on Nextcloud.

Inputs

• From (required) — Choose how to specify the spreadsheet file: either select from a list or provide a path expression.
• Folder — If selecting from list, choose the folder to filter spreadsheet files.
• File — If selecting from list, choose the spreadsheet file within the selected folder.
• File Path — If specifying by path, provide the full path to the spreadsheet file.
• Header Row — Specify the row number which contains the column headers (default is 1). Adjust if headers are not in the first row.
• Sheet (required) — Select the worksheet to update within the spreadsheet, either from a list, by name expression, or choose the first sheet.
• Row Number (required) — Specify the data row number to update, where 1 corresponds to the first row below the header.
• Column Values (required) — Specify the columns to update and their corresponding new values.

Output shape

a list of JSON objects, each indicating success and details for each processed item

Processes multiple input items; for each input, returns a success object with operation details including the sheet name, row number, updated data, and header row number. Throws errors if file path or sheet not found. Can continue on failure if configured.

Links

• n8n community nodes installation guide