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.

3
Nodes
3
Services
2
Categories
Manual
Type

Get This Workflow

Free n8n workflow template ready to import

Share on social

File Details

Filename
0822_Cron_Postgres_Automation_Scheduled.json
Category
Cron
Updated
09/04/2025

Services & Integrations

Cron
Function
Postgres

Interactive Workflow Diagram

Official n8n visualization • Click and drag to explore

Loading workflow visualization...

Official n8n visualization

How to Use This Workflow

1

Download the Workflow

Click the "Download Workflow" button above to get the JSON file.

2

Import to n8n

In your n8n instance, go to Workflows → Import and select the JSON file.

3

Configure Credentials

Set up your Cron and other service credentials in n8n.

4

Activate & Test

Activate the workflow and test it to ensure everything works correctly.

Tags

#cron
#cron
#function
#postgres
#manual
#cron
#workflow-automation

Related Workflows

Ready to transform your business?