I am reading a binary file using the spreadsheet plugin. There is a value that is on a separate sheet, but I would like to add it to every item output from the other sheet. Unfortunately, there is no value that I can use to link them, other than the files that they are read from.
I am looking to use something like the
pairedItem however it seems that this is just incrementing per item and is not related to the item for the spreadsheet.
I have tried using a loop and batch size of 1, but this takes hours in terms of execution time and is not sustainable.
- n8n version: 1.14.2
- Database (default: SQLite): SQLite
- n8n EXECUTIONS_PROCESS setting (default: own, main): N8N_PAYLOAD_MAX_SIZE=1024
- Running n8n via (Docker, npm, n8n cloud, desktop app): npm
- Operating system: Windows