# Automatically import product data from Excel to PostgreSQL
This automation template streamlines the regular and accurate import of product data from Excel files into a PostgreSQL database, eliminating manual entry and reducing human error. Ideal for teams managing inventory, supplier data, and product catalogs.
## Who it´s for
- Warehouse staff importing product data from Excel
- Product managers synchronizing catalog with database
- System administrators automating spreadsheet-based data loads
## What the automation does
- Reads the binary file `spreadsheet.xls` from the local file system
- Parses data as a spreadsheet using the Spreadsheet File node in n8n
- Processes rows one by one, extracting `name` and `ean` values
- Inserts records into the `product` table in PostgreSQL
- Can be triggered manually or on schedule for recurring syncs
## What´s included
- Ready-to-use n8n workflow
- Trigger and handler logic
- Integrations with PostgreSQL and Local File System (via Spreadsheet File node)
- Basic textual guide for setup and adaptation
## Requirements for setup
- Access to an n8n instance
- PostgreSQL database with a `product` table containing `name` and `ean` columns
- The `spreadsheet.xls` file available in a known directory
## Benefits and outcomes
- Eliminates manual data entry from Excel
- Reduces errors during import
- Enables regular product catalog updates
- Speeds up synchronization with suppliers
- Ensures consistent and repeatable import logic
## Important: template only
Important: you are purchasing a ready-made automation workflow template only. Rollout into your infrastructure, connecting specific accounts and services, 1:1 setup help, custom adjustments for non-standard stacks and any consulting support are provided as a separate paid service at an individual rate. To discuss custom work or 1:1 help, contact via chat
No feedback yet