{"product_id":"n8n-missed-call-text-back-workflow-with-twilio-email-alerts","title":"n8n Missed Call Text-Back Workflow with Twilio \u0026 Email Alerts","description":"\u003ch3\u003eAuto-text missed callers with Twilio—plus approvals and audit logs\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow instantly handles missed-call webhook events, looks up the caller in your n8n Data Table, and sends a Twilio SMS “text-back” message—while logging outcomes and notifying a dispatcher by email (with approval required for after-hours calls).\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cb\u003eReceives missed call events via Webhook:\u003c\/b\u003e accepts a POST request containing the caller details.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eNormalizes and validates the caller number:\u003c\/b\u003e standardizes the incoming phone number, sets the call timestamp, and determines whether it happened after business hours.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eRejects invalid\/missing numbers safely:\u003c\/b\u003e if the phone number is missing or invalid, it responds with \u003cb\u003eHTTP 400\u003c\/b\u003e, records the rejected event in an n8n Data Table, and emails the dispatcher.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eResponds immediately for valid events:\u003c\/b\u003e for valid numbers, it responds with \u003cb\u003eHTTP 202\u003c\/b\u003e and proceeds without delaying the webhook response.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eLooks up callers in an n8n Data Table:\u003c\/b\u003e checks \u003cb\u003edemo_contacts\u003c\/b\u003e to decide whether the caller is a known customer or a first-time caller.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eAfter-hours approval gate:\u003c\/b\u003e if the call is outside business hours, it emails an approval request to the dispatcher and only sends the text-back after approval.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eSends different SMS content:\u003c\/b\u003e builds a tailored Twilio SMS for known customers vs. first-time callers and sends it back to the caller.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eLogs results and escalates on failure:\u003c\/b\u003e writes the SMS result to \u003cb\u003edemo_missed_calls\u003c\/b\u003e and emails the dispatcher with either a confirmation (sent) or an action-required alert (failed).\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eCustomer support lines that need an immediate missed-call text-back with the right messaging per caller type.\u003c\/li\u003e\n  \u003cli\u003eOperations teams requiring dispatcher oversight for after-hours outreach.\u003c\/li\u003e\n  \u003cli\u003eTeams that want traceability by logging each call and SMS outcome to n8n Data Tables.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cb\u003eNodes\/stack:\u003c\/b\u003e Webhook, if, set, Twilio, Data Table, Email Send.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eRequired Data Tables:\u003c\/b\u003e \u003ccode\u003edemo_contacts\u003c\/code\u003e (phone, name) and \u003ccode\u003edemo_missed_calls\u003c\/code\u003e (phone, caller_type, status, detail, called_at).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eTwilio setup:\u003c\/b\u003e add Twilio credentials, provision\/verify the sending phone number, and configure the workflow’s Twilio “from” number.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46153946235059,"sku":"N8N-20319","price":62.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/Qqk8OWnRObxLzG0MBcMyt_5vLj1eX1.png?v=1790931891","url":"https:\/\/buyflowscripts.com\/products\/n8n-missed-call-text-back-workflow-with-twilio-email-alerts","provider":"N8N Commerce","version":"1.0","type":"link"}