NextCloud Spreadsheet icon

NextCloud Spreadsheet

Read and write spreadsheet files (.xlsx, .ods, .csv) stored on Nextcloud — includes named Excel table support

Actions14

Sheet → Get Rows

AI-generated

Summary

Retrieve rows from a specified worksheet within a spreadsheet file stored on Nextcloud, returning the data as individual n8n items.

Inputs

  • From (required) — Choose between selecting the spreadsheet file from a list (in a specified folder) or by providing a file path expression.
  • Folder — Specify the folder path to filter spreadsheet files when selecting from a list. Defaults to root ('/').
  • File — Select the spreadsheet file from the available files in the specified folder when choosing 'From List' mode.
  • File Path — Provide the full file path to the spreadsheet when choosing 'By Path (Expression)' mode.
  • Header Row (required) — Specify which row number contains the column headers (default is 1). Adjust if headers are not in the first row.
  • Sheet (required) — Select the worksheet by picking from the sheet list, providing its name directly via expression, or using the first sheet in the workbook.
  • Options — Configure options such as limiting the number of rows returned to the last N rows (0 means all rows) and starting from a specific column position.
  • Column Names or IDs — Optionally specify which columns to include in the output by name or ID. Leaving it empty returns all columns.

Output shape

a list of items, each representing a row from the selected worksheet containing key-value pairs of column names and cell values

If specific columns are selected, only those columns appear in each item. The option to return only the last N rows is supported. The first row used as headers determines the keys for output objects.

Examples

Example 1: Retrieve all rows from the 'Employees' sheet in a spreadsheet selected from a folder

Set 'From' to 'From List', select the 'Folder' and 'File' containing the spreadsheet, choose the 'Sheet' by list selecting 'Employees', and leave 'Return Columns' empty.

Example 2: Fetch only the last 5 rows from the first sheet using a specified file path

Set 'From' to 'By Path (Expression)', provide the 'File Path', choose 'Sheet' mode as 'First Sheet', set 'Return Last N Rows' option to 5.

Links

Discussion