{"product_id":"n8n-missed-call-sms-auto-reply-twilio-gpt-slack","title":"n8n Missed Call SMS Auto-Reply: Twilio + GPT + Slack","description":"\u003ch3\u003eTurn missed Twilio calls into instant SMS follow-ups—automatically\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow listens for \u003cstrong\u003eTwilio call status callbacks\u003c\/strong\u003e, detects \u003cstrong\u003emissed inbound calls\u003c\/strong\u003e, looks up the caller in your \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e customers list, and uses \u003cstrong\u003eOpenAI (GPT-5.6)\u003c\/strong\u003e to generate a short, context-aware SMS auto-reply—then sends it via \u003cstrong\u003eTwilio\u003c\/strong\u003e and alerts \u003cstrong\u003eSlack\u003c\/strong\u003e.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eReceives a \u003cstrong\u003ePOST webhook\u003c\/strong\u003e from Twilio when a call ends and normalizes the payload while calculating whether the call was missed and whether it occurred within opening hours.\u003c\/li\u003e\n  \u003cli\u003eFilters to \u003cstrong\u003emissed inbound calls only\u003c\/strong\u003e (busy, no-answer, failed, or canceled) and stops if the caller actually answered.\u003c\/li\u003e\n  \u003cli\u003eLooks up the caller’s phone number in the \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e “Customers” sheet and checks an \u003cstrong\u003en8n Data Table\u003c\/strong\u003e to ensure no SMS is sent within the configured quiet period.\u003c\/li\u003e\n  \u003cli\u003eClassifies the caller as an \u003cstrong\u003eexisting customer\u003c\/strong\u003e, a \u003cstrong\u003enew lead\u003c\/strong\u003e, or \u003cstrong\u003eafter-hours\u003c\/strong\u003e, and proceeds only when a reply should be sent.\u003c\/li\u003e\n  \u003cli\u003eUses \u003cstrong\u003eOpenAI (GPT-5.6)\u003c\/strong\u003e to draft a concise SMS reply, then cleans the text and applies an SMS length\/segment estimate.\u003c\/li\u003e\n  \u003cli\u003eSends the SMS via \u003cstrong\u003eTwilio\u003c\/strong\u003e, upserts a \u003cstrong\u003emissed_calls\u003c\/strong\u003e record to prevent repeat texts, and posts a tailored notification to a \u003cstrong\u003eSlack\u003c\/strong\u003e channel.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSales follow-up:\u003c\/strong\u003e A missed call from a new lead triggers an SMS reply immediately, without spamming during quiet hours.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCustomer service:\u003c\/strong\u003e Missed calls from existing customers get an automated acknowledgment and next-step message.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAfter-hours handling:\u003c\/strong\u003e Calls outside opening hours receive an appropriate SMS template and Slack alerts for visibility.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eIntegrations: \u003cstrong\u003eTwilio\u003c\/strong\u003e (status callback + SMS), \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e, \u003cstrong\u003eSlack\u003c\/strong\u003e, and \u003cstrong\u003eOpenAI (GPT-5.6)\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003eWorkflow logic: \u003cstrong\u003eif\u003c\/strong\u003e, \u003cstrong\u003eswitch\u003c\/strong\u003e, \u003cstrong\u003ecode\u003c\/strong\u003e (payload normalization, limits\/segment estimation), \u003cstrong\u003eset\u003c\/strong\u003e, \u003cstrong\u003eno op\u003c\/strong\u003e, plus n8n Data Table upsert\/deduping.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45899949277363,"sku":"N8N-18714","price":16.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/kv7bZPLMSk0jQ_QUt-gPs_qNWlk6Eq.png?v=1787735202","url":"https:\/\/buyflowscripts.com\/products\/n8n-missed-call-sms-auto-reply-twilio-gpt-slack","provider":"N8N Commerce","version":"1.0","type":"link"}