Data & Databases
Read Excel spreadsheets and store data in PostgreSQL database
3 nodes
285
102
Manual trigger
Workflow Description
Workflow that reads spreadsheet files automatically, extracts data, and transfers it to PostgreSQL database for centralized storage and quick queries without manual data entry or copy-paste errors.
How it works
- 1.Manual trigger to start the workflow when needed
- 2.Read spreadsheet file and convert its content into structured data
- 3.Insert extracted data into PostgreSQL tables
Use cases
- Migrate customer data from Excel files to main database
- Regular data synchronization between spreadsheets and database
Requirements
- Valid spreadsheet file in xlsx or csv format
- PostgreSQL database connection credentials
Service Value
Ready-made workflow template for automation delivery and service execution.
Apps Used
Spreadsheet File
Postgres
Details
Trigger
Manual trigger
Nodes
3
Apps
2
Views
285
Downloads
102
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 (3)
Read Binary File
Read Binary File
Spreadsheet File1
Spreadsheet File
Insert Rows1
Postgres