Transfer Data from Postgres to Excel

This n8n workflow automates the process of extracting data from a PostgreSQL database and converting it into an Excel spreadsheet file. The generated Excel file can then be saved locally or further processed.

What it does

This workflow performs the following key steps:

1. Starts the workflow: Initiates the automation process.
2. Queries PostgreSQL: Connects to a PostgreSQL database and retrieves data.
3. Converts to Spreadsheet: Takes the data retrieved from PostgreSQL and converts it into a spreadsheet file format (e.g., Excel XLSX).
4. Writes Binary File: Saves the generated spreadsheet file as a binary file. This step typically saves the file to a local disk or a specified file system.

Prerequisites/Requirements

To use this workflow, you will need:

• n8n Instance: A running instance of n8n.
• PostgreSQL Database: Access to a PostgreSQL database with the necessary credentials.
• PostgreSQL Credential in n8n: A configured PostgreSQL credential within your n8n instance.

Setup/Usage

1. Import the Workflow: Import the provided JSON into your n8n instance.
2. Configure PostgreSQL Node:
   • Open the "Postgres" node.
   • Select your pre-configured PostgreSQL credential.
   • Configure the "Operation" (e.g., "Read") and specify the "Table" or provide a custom SQL query to fetch the desired data.
3. Configure Spreadsheet File Node:
   • The "Spreadsheet File" node will automatically receive the data from the "Postgres" node.
   • You can adjust the "File Type" (e.g., xlsx for Excel, csv) and other options if needed.
4. Configure Write Binary File Node:
   • Open the "Write Binary File" node.
   • Specify the "File Name" (e.g., my_data.xlsx).
   • Choose the "File System" where you want to save the file (e.g., "Local" to save on the n8n host, or other configured file systems).
   • Set the "Path" within the chosen file system where the file should be saved.
5. Activate the Workflow: Once configured, activate the workflow to enable it.
6. Execute the Workflow: You can manually execute the workflow by clicking "Execute Workflow" in the n8n editor, or set up a trigger (e.g., a schedule) to run it automatically.