NextCloud SearchInstall

Summary

Search specified columns in a Nextcloud-hosted spreadsheet (worksheet or named table) for values and return corresponding values from other columns as new fields in each item.

Inputs

• Source Type (required) — Choose whether to search within a worksheet (sheet) or a named Excel table (table).
• From (required) — Specify the spreadsheet file by selecting from a folder and file list or by providing a file path expression.
• Folder — Select folder to filter files when choosing file from a list (used if 'From' is set to 'From List').
• File — Select the spreadsheet file from the filtered list, used if 'From' is 'From List'.
• File Path — Specify the exact file path as an expression, used if 'From' is 'By Path (Expression)'.
• Header Row — For worksheet source type, specify which row contains column headers (default is 1).
• Sheet — For worksheet source type, select the worksheet by listing, by name expression, or use the first sheet.
• Table — For table source type, select the named table from the workbook by list or name expression.
• Lookups (required) — Configure one or multiple lookups specifying the search column, the search value (supports expressions), the return column whose value to write, and the output field name to add in the output JSON.
• Options — Configure case sensitivity of search, behavior if no match is found (set output field to null or throw error), and whether to include original input data in the output.

Output shape

a list of JSON items

Each output item corresponds to an input item. Original input data is included as-is if 'Pass Through Original Data' is enabled. For each configured lookup, a new field is added to each output item with the lookup result value or null if no match is found (depending on options). An error is thrown per item if no match is found and 'If Not Found' is set to 'Throw Error'.

Links

• n8n community nodes installation guide