This n8n workflow automates the process of importing data from an Excel spreadsheet into a PostgreSQL database. The goal is to streamline data entry, reduce manual workload, and ensure data consistency by automating the transfer of product information.

The workflow begins with the ‘Read Binary File’ node, which reads an Excel file named ‘spreadsheet.xls’ from the file system. The data from this file is then passed to the ‘Spreadsheet File1’ node, which interprets and parses the spreadsheet content, preparing it for database insertion.

Next, the processed data flows into the ‘Insert Rows1’ PostgreSQL node. This node inserts the parsed data into the ‘product’ table, specifically into the ‘name’ and ‘ean’ columns. Proper database credentials are used for secure access.

The nodes are connected sequentially, ensuring a smooth flow from reading the file to inserting data into the database.

This workflow is particularly useful for businesses that regularly update product information via Excel files and want to automate data entry into their database, saving time and minimizing errors.

Error: Could not read the workflow JSON file from protected location.