# Monitor sensor data in PostgreSQL and send SMS via Twilio on threshold exceed
This automation monitors critical sensor readings from a PostgreSQL database and instantly notifies responsible personnel via SMS when a threshold is exceeded. Designed for technical teams requiring real-time alerts without manual oversight.
## Who it´s for
- Technical specialists monitoring sensor data in real time
- Equipment maintenance engineers with automated alerting needs
- Monitoring system administrators using SMS for urgent notifications
## What the automation does
- Triggered on schedule via Cron
- Queries the `n8n` table in PostgreSQL for records where value > 70 and notification flag is false
- Sends an SMS alert via Twilio with sensor ID and value details
- Updates the notification flag in the database to prevent duplicates
- Ensures no repeated alerts by marking events as processed
## What´s included
- Ready-to-use n8n workflow
- Trigger and conditional logic structure
- Integrations with PostgreSQL and Twilio
- Basic text guide for setup and adaptation
## Requirements for setup
- Access to a running n8n instance
- PostgreSQL account with sensor data table
- Twilio account configured for SMS sending
- API credentials and connection details for both services
## Benefits and outcomes
- Faster response to critical system conditions
- Elimination of manual monitoring routines
- Reduced risk of human oversight
- Reliable alert delivery even during internet outages (via SMS)
- Clear logic to avoid duplicate notifications
## Important: template only
Important: you are purchasing a ready-made automation workflow template only. Rollout into your infrastructure, connecting specific accounts and services, 1:1 setup help, custom adjustments for non-standard stacks and any consulting support are provided as a separate paid service at an individual rate. To discuss custom work or 1:1 help, contact via chat
No feedback yet