Data & Databases
Extract PostgreSQL data and save to spreadsheet file
3 nodes
125
75
Manual trigger
Workflow Description
A workflow that retrieves data from your PostgreSQL database and exports it directly to a downloadable spreadsheet file. Triggered manually whenever you need to generate reports, create backups, or share data with your team in a structured format.
How it works
- 1.Initiate the manual trigger and specify data extraction criteria
- 2.Connect to PostgreSQL and query the required data
- 3.Convert results to spreadsheet format and save the file
Use cases
- Generate periodic data reports in Excel format
- Create automated backups of database tables
- Share database records with team members via spreadsheet
Requirements
- PostgreSQL connection details (host, database, credentials)
- File write permissions on your system
Service Value
Ready-made workflow template for automation delivery and service execution.
Apps Used
Postgres
Spreadsheet File
Details
Trigger
Manual trigger
Nodes
3
Apps
2
Views
125
Downloads
75
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)
Run Query
Postgres
Spreadsheet File
Spreadsheet File
Write Binary File
Write Binary File