Back to Workflows

Send SMS alerts based on database queries (Twilio and Postgres)

Apps in this workflow

Postgres
Twilio

Categories

DevOps & IT

Created by

Share

Details

Created 3 years ago by tanay1337
eye 1151 views
Description

This workflow automatically queries a Postgres database to find outlier readings for which SMS notifications have not been sent.
This is Workflow 2 in the blog tutorial Database activity monitoring and alerting.

Prerequisites

Nodes

  • Cron node triggers the workflow every minute, so the database is queried at regular intervals.
  • Postgres nodes extract values from, and update values in the database.
  • Twilio node sends an alert SMS about the outlier reading to a specified phone number.
  • Set node sets the notification value to true.

Implement complex processes faster with n8n

red icon yellow icon red icon yellow icon