Send SMS alerts based on database queries (Twilio and Postgres)
Needs changesNeeds changes. This template uses 1 thing(s) that n8n 3.0 removes: Cron. 1 breaking item(s) found. Static check, last run 2026-10-19.
What this workflow does
This workflow has 5 nodes and runs on a schedule (legacy Cron node). Along the way it connects Postgres and Twilio.
How it runs
Trigger: On a schedule (legacy Cron node).
- Postgres: run a query
- Twilio: uses Twilio
- Set (Edit Fields (Set)): sets or maps fields
- Postgres: update
Services it uses
Before you upgrade to n8n 3.0
1 thing in this workflow is removed in n8n 3.0. Fix it before you upgrade:
- Cron: replace with Schedule Trigger.
Rather not rewrite it? Many of these flows can be rebuilt in Make (free plan).
| Removed in 3.0 | Replace with |
|---|---|
| Cron Cron | Schedule Trigger |
Nodes used (4)
- Cron
n8n-nodes-base.cron - Postgres
n8n-nodes-base.postgres - Twilio
n8n-nodes-base.twilio - Edit Fields (Set)
n8n-nodes-base.set
From the author
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 - A Postgres database set up and…