This n8n workflow automates the ingestion of data into a PostgreSQL database on a continuous, minute-by-minute schedule. Utilizing a Cron node, the workflow is triggered every 60 seconds. Following the trigger, a Function node dynamically generates a current timestamp, capturing the year, month, day, hour, minute, and second. This timestamp, along with an inferred `sensor_id` (suggesting data from an external sensor or system), forms the core data payload. The prepared data is then passed to a PostgreSQL node (implied by the workflow's name and services), where it is inserted as a new record. This setup is ideal for real-time monitoring and logging applications, ensuring that a consistent stream of time-stamped sensor or event data is captured and stored for analysis or historical tracking. It provides a robust and automated solution for continuous data collection.
Free n8n workflow template ready to import
Official n8n visualization • Click and drag to explore
Loading workflow visualization...
Click the "Download Workflow" button above to get the JSON file.
In your n8n instance, go to Workflows → Import and select the JSON file.
Set up your Cron and other service credentials in n8n.
Activate the workflow and test it to ensure everything works correctly.
Get a custom n8n workflow built specifically for your business needs.
Ready to transform your business?