Data synchronization from API to Postgres and CSV

• Automate data retrieval from external APIs for regular updates.
• Store and manage data efficiently in a Postgres database.
• Export data in CSV format for reporting or analysis.

Fetch data from an external API using an HTTP request. Process and structure the data with a set node. Store the processed data in a Postgres database. Export the stored data to a CSV file for easy access.

1. 1
   Import the workflow template into your n8n instance.
2. 2
   Configure the API URL in the HTTP request node.
3. 3
   Set up the Postgres connection details.
4. 4
   Adjust any necessary parameters in the set node.
5. 5
   Run the workflow to initiate data synchronization.