Keyflow

Search Keyflow

Find a shortcut, workflow, MCP server or skill

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

n8n template #357
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 credentials A Twilio account and credentials 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.

Hand off to your agent

Prompt

Help me set up the n8n workflow "Send SMS alerts based on database queries (Twilio and Postgres)" (https://n8n.io/workflows/357). It uses: Postgres, Twilio. Import the template JSON into my n8n instance, list every credential I need to create, and walk me through testing it.

Paste into Claude Code and it will do the rest.

Apps and nodes

Similar workflows

NameViews
  1. Generate Instagram Content from Top Trends with AI Image Generation72K
  2. Handling Appointment Leads and Follow-up With Twilio, Cal.com and AI23K
  3. AI Agent for realtime insights on meetings16K
  4. Automate Lead Qualification with RetellAI Phone Agent, OpenAI GPT & Google Sheet14K
  5. Insert Excel data to Postgres12K
  6. WordPress - AI Chatbot to enhance user experience - with Supabase and OpenAI11K
  7. 🤖 Advanced Slackbot with n8n9,377
  8. Enhance Customer Chat by Buffering Messages with Twilio and Redis9,239
Buy me a coffee