!-- Hey! To help you find a solution faster, please follow the template below. Skip the questions that are not relevant to you. →
Describe the problem/error/question
I have a Spreadsheet File node followed by a Read Binary node. However, I’m encountering a problem where the spreadsheet file is not retrieving any data from the Read binary node.
What is the error message (if any)?
Please share your workflow
(Select the nodes on your canvas and use the keyboard shortcuts CMD+C/CTRL+C and CMD+V/CTRL+V to copy and paste the workflow.)
Rather than autodetect can you try setting it to can to see if that helps? If your file is not using a standard , to separate files you may need to add that as an option as well.
You are also on an older version so it could be that the ( ) in the node name is causing an issue so I would also try removing those or update n8n.
I have tried with different files, but the same problem keeps occurring. Every time I open the file and save it before executing the workflow, after that workflow works perfectly
Sadly to have a solution we will need to find a way to reproduce it, Can you try the workflow below that downloads a random CSV file and let me know if that works.
When you also say that you need to open the file and save it the workflow then works what do you actually mean there? I am wondering if maybe the file is the issue or the way it is being created / loaded.
When I download the file from the portal and try to use it through the workflow, it doesn’t work; it gives an error. However, after I open the file and save it without making changes, the workflow works perfectly
so, my question is why workflow is not working at first time?
I went for a CSV as your first post shows a CSV with the same issue, The workflow at the bottom is using an xlsx file can you also test that one.
I don’t know why it is failing on the first run but if you are doing something outside of n8n to get it working in n8n then it would suggest the issue is something with the file itself.
It sounds like there is potentially something different with your file, Are you able to make a file with mock data that has the same issue so we can investigate further?
