Import CSV files from filesystem into Postgres
Needs changesWhat this workflow does
This workflow has 4 nodes and runs manually, when you click “Execute workflow”. Along the way it connects Postgres.
How it runs
Trigger: Manually, when you click “Execute workflow”.
- Read From File (Read Binary File): uses Read Binary File
- Convert To Spreadsheet (Spreadsheet File): reads or writes a spreadsheet file (legacy node)
- Postgres: uses Postgres
Services it uses
Before you upgrade to n8n 3.0
1 thing in this workflow is removed in n8n 3.0. Fix it before you upgrade:
- Read Binary File in Read From File: replace with Read/Write Files from Disk.
- Also check Spreadsheet File: Convert to File / Extract from File.
Rather not rewrite it? Many of these flows can be rebuilt in Make (free plan).
| Removed in 3.0 | Replace with |
|---|---|
| Read Binary File Read From File | Read/Write Files from Disk |
Nodes used (4)
- Manual Trigger
n8n-nodes-base.manualTrigger - Read Binary File
n8n-nodes-base.readBinaryFile - Spreadsheet File
n8n-nodes-base.spreadsheetFile - Postgres
n8n-nodes-base.postgres
From the author
-- Disclaimer: This template is mainly made for self-hosted users who can reach CSV files in their file system. For Cloud users, just replace the first few nodes with your file system of choice, like Google Drive or Dropbox -- How to automatically import CSV…