Postgres to Excel Data Export

This workflow automates the extraction of data from a Postgres database by executing a simple SQL query ('SELECT name, ean FROM product'). The fetched data is then transformed into an Excel (XLS) spreadsheet using n8n's Spreadsheet File node, and finally written to a binary file on disk named 'spreadsheet.xls'.

Benefits include eliminating manual data export processes, reducing errors from copy-pasting, and enabling scheduled or triggered exports for real-time reporting. It's lightweight with only three nodes, making it fast and reliable for personal or small-scale use.

Ideal use cases: Generating inventory reports for e-commerce, backing up product catalogs, preparing data for sales teams, or integrating into larger workflows for document management. Customize the query for any table and adjust the output filename for flexibility.

As created by n8n's founder, it exemplifies core n8n strengths in database-to-file conversions without complex setup.