Expose workflow output to public URL

Questions
1

Hello everyone, :smiley:

I’m currently spending a lot of time manually exporting and importing CSVs from my N8N workflows. I’m wondering if there’s a more efficient way to handle this process.

I’m looking for a method to expose a direct link to an N8N workflow output as a CSV, without having to upload the data to an external service (AWS, google sheets, etc.).

Ideally, I’m envisioning something like an “Expose” node that would generate a public URL that can be queried at any time to retrieve the latest CSV output from the workflow.

Does anyone know if such a feature exists in N8N, or if there’s a workaround to achieve this functionality? Perhaps there’s a way to set up an endpoint that serves the workflow output directly as a CSV?

Thanks in advance for your help! :pray:
Joachim

2

It looks like your topic is missing some important information. Could you provide the following if applicable.

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

hello @Joachim_Brindeau

you can set a Webhook that will respond with the binary file. So if someone tries to open the url, it will download the content from that file. Example is below

4

Thank you @barn4k
If I understand correctly, I would need to run the workflow every time I want to query the file? Is there any way to avoid this?

Thanks a lot

5

n8n does not store files anywhere, so it’s completely up to you how you will store them and where :slight_smile:

if you have a self-hosted instance, the easiest way is to store them locally and retrieve with the webhook once required

6

I do have a self-hosted instance. Could you please elaborate a bit on how to get a file locally with a webhook ?

7

to save data in the local file:

to retrieve it via webhook:

2 Likes
8

Awesome, thank you!!

9

you can also set a some kind of web form to download a desired file from the list, but that one is a little tricky

1 Like
10

Thank you for your help.
I have successfully implemented it, very happy with the solution, thanks again.

11

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.