Automated SMS Alerts for Postgres Outlier Data via Twilio - n8n Workflow | Neura Market
Automated SMS Alerts for Postgres Outlier Data via Twilio
This workflow queries a Postgres database every minute for outlier readings without notifications, sends SMS alerts via Twilio, and marks them as notified.
This n8n workflow automates database monitoring and alerting by running a Cron trigger every minute to query a Postgres database for records where a value exceeds 70 and no notification has been sent (notification = false). Upon detecting such outliers, it immediately sends an SMS alert via Twilio to a specified phone number, including details like sensor ID and value. Finally, it updates the database record using a Set node to mark the notification as sent (true), preventing duplicate alerts.
Platform
n8n
Category
Finance
Price
$12.99
Creator
Jose Maurino
monitoring
alerting
postgres
twilio
sms
cron
database
automation
outliers
notifications
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.