Read/Write files from Disk

Questions
1

Describe the problem/error/question

I’m trying to read an excel file from my OneDrive folder with the Read/Write Files from Disk node. I’ve entered the path of the file and the node executes successfully but there’s no output.

What is the error message (if any)?

No error, it says the node executed successfully but there’s no output.

Please share your workflow

Share the output returned by the last node

The last node is supposed to create a new excel file with multiple worksheets but it does not create the file. However, when I execute the workflow, it says workflow executed successfully. I don’t think the first read/write node is pulling the file to be read and therefore, there is nothing for the code node or the last read/write node to do.

Information on your n8n setup

  • n8n version:
  • Database (default: SQLite):
  • n8n EXECUTIONS_PROCESS setting (default: own, main):
  • Running n8n via (Docker, npm, n8n cloud, desktop app):
  • Operating system:
2

Hey, how are you running n8n? Docker? Npm? If Npm, what OS is it running on?

The patch you provided should exist inside the container or inside the directory from which n8n operates. If not, you need to provide an absolute path, for example this one in Mac/Linux:

/home/node/.n8n/files/insight.xlsx
3

Hi,

I’m running it in the cloud so I don’t believe the read/write node is going to work. I’ve also tried the Microsoft OneDrive node but it’s asking for a file id. Everything I’ve tried for the id has not worked. Is there a way to upload the file manually to n8n?

4

Hello @sheupel,

If you want to send the file manually, you can use the form trigger as the file receiver:

But if you want to use Microsoft OneDrive, you need to review the access credential settings.

OneDrive credential configuration

Example of a flow using the OneDrive connector with a search by file name:

If this has helped you, mark the answer as the solution.

I hope I was able to help with your question.