Generate & Insert Sensor Data into Postgres DB - n8n Workflow | Neura Market
Generate & Insert Sensor Data into Postgres DB
Automates periodic generation of fake sensor data (e.g., humidity) and inserts it into a Postgres database for testing or monitoring.
This n8n workflow simulates sensor data ingestion by running every minute via a Cron node, generating randomized humidity readings with timestamps using a Function node, and inserting them into a Postgres table. It requires a Postgres database with a predefined table (n8n: id SERIAL, sensor_id VARCHAR, value INT, time_stamp TIMESTAMP, notification BOOLEAN). Ideal for blog tutorials on database monitoring.
Benefits include easy setup for testing data pipelines, alerting systems, or time-series d
Platform
n8n
Category
Media & Entertainment
Price
$4.99
Creator
Bryce Yu
postgres
database
cron
function
data-ingestion
sensor-data
automation
iot-simulation
monitoring
sql
How to import this workflow into n8n
1Purchase or download the workflow to get the n8n workflow JSON file.
2In your n8n instance, open Workflows and choose "Import from File" (or paste the JSON with Ctrl+V on the canvas).
3Open each node marked with a credential warning and connect your own accounts and API keys.
4Run the workflow once manually to verify the data flow, then toggle it to Active.