Automated Minute-by-Minute Sensor Data Ingestion to Postgres

Cron

Manual Trigger

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.