Read Spreadsheet and Insert into PostgreSQL

Name: Read Spreadsheet and Insert into PostgreSQL
Rating: 2.0 (1 reviews)
Author: Free N8N

Beginner

0 nodes connected

detail.loadingPreview

Free N8N Temples

12 views

0 downloads

Data Integrationautomationdatabaseexcelimportpostgresreadbinaryfilespreadsheet

Reads data from a local spreadsheet file and inserts it into a PostgreSQL table.

🚀Ready to Deploy This Workflow?

⚡Deploy on Zeabur 🎁Get $200 Credit on DigitalOcean

About This Workflow

Overview

This workflow automates the process of reading data from a local spreadsheet file (e.g., .xls) and then inserts the parsed data into a specified PostgreSQL table. It includes basic error handling.

Key Features

Reads data from a local binary spreadsheet file.
Parses spreadsheet data for processing.
Inserts data into a PostgreSQL database.
Basic error handling to stop execution on failure.

How To Use

Configure Read Binary File node: Ensure the filePath parameter points to your spreadsheet file.
Configure Spreadsheet File node: This node will automatically parse the binary data from the previous node.
Configure PostgreSQL node: Provide your PostgreSQL credentials and specify the target table and columns for insertion.
Set up Error Handler: Customize the error message if needed.

Apps Used

automation

database

excel

import

postgres

readbinaryfile

spreadsheet

Workflow JSON

{
  "id": "027c013c-b6df-4906-860b-fb5502820afd",
  "name": "Read Spreadsheet and Insert into PostgreSQL",
  "nodes": 0,
  "category": "Data Integration",
  "status": "active",
  "version": "1.0.0"
}

Note: This is a sample preview. The full workflow JSON contains node configurations, credentials placeholders, and execution logic.