Templates / Log Twilio SMS delivery statuses to Google Sheets and alert Slack on failures

Log Twilio SMS delivery statuses to Google Sheets and alert Slack on failures

Ready for 3.0

by Kevin Yu ✓ · 5 views · created 2026-07-21 · Ticket Management

Ready for 3.0. This template uses no nodes that n8n 3.0 removes. No removed nodes, versions or helpers found. Static check, last run 2026-10-19.

What this workflow does

This workflow has 7 nodes and runs when an HTTP POST request hits its webhook URL. Along the way it connects Google Sheets and Slack.

How it runs

Trigger: When an HTTP POST request hits its webhook URL.

  1. Load Twilio Error Code Map (Edit Fields (Set)): sets 1 field: error_map
  2. Decode Status And Error Reason (Edit Fields (Set)): sets 6 fields: received_at, message_sid, to_number…
  3. Append Delivery Ledger Row (Google Sheets): append
  4. Check For Failed Delivery (If): checks a condition and branches into true / false
  5. Post Failure Alert To Slack (Slack): uses Slack
  6. Return 200 To Twilio (Respond to Webhook): sends the response back to the webhook caller

Services it uses

Google SheetsSlack

Before you upgrade to n8n 3.0

Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.

Nodes used (6)

From the author

Quick overview This workflow receives Twilio SMS status callbacks, logs each delivery status (including decoded error reasons) to Google Sheets, and posts an alert to Slack when a message is marked failed or undelivered. How it works 1. Receives a POST…

Excerpt from Kevin Yu's description on n8n.io.

View the original on n8n.io → Check your own copy

Get the weekly “what broke” email

New templates, newly broken ones, and n8n release changes. One short email a week.

Form not loading? Subscribe here.