What it does
An n8n workflow that runs every minute and queries a Postgres database for outlier readings that have not triggered an alert yet. For each one, it sends an SMS through Twilio and then marks the reading as notified, so it is not sent twice. It is the second workflow in a database monitoring tutorial.
Use cases
- 01Get an SMS when a sensor reading is an outlier
- 02Send each alert once and mark it as notified
- 03Monitor a Postgres table every minute
Connects
Postgres · Twilio