Data & Databases
Automatically import CSV files into PostgreSQL database
4 nodes
321
109
Automatic trigger
Workflow Description
This automation reads CSV files, parses tabular data, and inserts records directly into PostgreSQL without manual steps. Eliminates repetitive data entry, ensures consistency, and scales to handle large imports efficiently.
How it works
- 1.Trigger automation when CSV file is uploaded or manually initiated
- 2.Read binary file content and decode it properly
- 3.Extract rows from spreadsheet and map columns to database fields
- 4.Insert parsed data into PostgreSQL tables in batch
Use cases
- Import customer records from CSV exports into transactional database
- Sync product and inventory updates from supplier reports
- Migrate historical data from legacy systems to PostgreSQL
Requirements
- PostgreSQL connection credentials and target table schema configured
- CSV files with consistent formatting and predefined column structure
Service Value
Ready-made workflow template for automation delivery and service execution.
Apps Used
Spreadsheet File
Postgres
Details
Trigger
Automatic trigger
Nodes
4
Apps
2
Views
321
Downloads
109
How to Use
- 1.Click "Download Template"
- 2.Open your n8n dashboard
- 3.Go to Workflows > Import from File
- 4.Select downloaded file and configure credentials
Nodes Used (4)
On clicking 'execute'
Manual Trigger
Read From File
Read Binary File
Convert To Spreadsheet
Spreadsheet File
Postgres
Postgres