Community Contributed Unverified Spreadsheet
detail.loadingPreview
Generates a spreadsheet of products from the database.
🚀Ready to Deploy This Workflow?
About This Workflow
Overview
This workflow retrieves product data (name and EAN) from a PostgreSQL database and exports it to a spreadsheet file (XLS format). It's designed as a community-contributed template for unverified use.
Key Features
- Connects to PostgreSQL database.
- Executes a custom SQL query.
- Exports query results to a spreadsheet file.
- Includes basic error handling.
How To Use
- Configure PostgreSQL Credentials: Ensure your PostgreSQL database connection details are correctly set up in n8n.
- Update SQL Query: Modify the
SELECT name, ean FROM productquery in the 'Run Query' node if you need different data. - Adjust File Name: Change the
fileNameparameter in the 'Spreadsheet File' and 'Write Binary File' nodes if needed. - Execute Workflow: Trigger the workflow manually. The output will be a
spreadsheet.xlsfile.
Apps Used
Workflow JSON
{
"id": "54e6300a-a9c5-4984-bcb5-17a3d2652cb1",
"name": "Community Contributed Unverified Spreadsheet",
"nodes": 0,
"category": "Data Export",
"status": "active",
"version": "1.0.0"
}Note: This is a sample preview. The full workflow JSON contains node configurations, credentials placeholders, and execution logic.
Get This Workflow
ID: 54e6300a-a9c5...
About the Author
Crypto_Watcher
Web3 Developer
Automated trading bots and blockchain monitoring workflows.
Statistics
Verification Info
Related Integrations
- Postgres + Schedule Trigger(39 workflows)
- Execute Workflow Trigger + Postgres(27 workflows)
- Execute Workflow Trigger + Execution Data(22 workflows)
- Postgres + Slack(17 workflows)
- Postgres + Postgres Tool(16 workflows)
- Postgres + Supabase(16 workflows)
- Execution Data + Split Out(15 workflows)
- Execute Workflow Trigger + Postgres Tool(14 workflows)
- Google Sheets + Postgres(14 workflows)
- Postgres + Split Out(12 workflows)
Related Workflows
Discover more workflows you might like
WordPress Posts to CSV
Export all posts from a WordPress site to a CSV file.
Webhook to Spreadsheet Export
Receives data via webhook and exports it as an XLSX spreadsheet.
Snowflake CSV Export
Export data from Snowflake to a CSV file.
Save MySQL Table as XLSX
Exports data from a specified MySQL table into an XLSX file.
PostgreSQL Export to CSV
Exports data from a PostgreSQL table to a CSV file.
Save SQL Table as CSV
This workflow retrieves data from an SQL table and saves it as a CSV file.