{"product_id":"missed-call-auto-reply-with-twilio-n8n-gmail-google-sheets","title":"Missed Call Auto-Reply with Twilio, n8n, Gmail \u0026 Google Sheets","description":"\u003ch3\u003eNever Miss a Caller Again: Auto-Reply to Missed Calls with Twilio + n8n\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow listens for \u003cstrong\u003eTwilio call status webhooks\u003c\/strong\u003e, detects \u003cstrong\u003emissed inbound calls\u003c\/strong\u003e, and automatically sends the caller an \u003cstrong\u003eSMS auto-reply\u003c\/strong\u003e. It also \u003cstrong\u003elogs every missed call to Google Sheets\u003c\/strong\u003e and can optionally \u003cstrong\u003enotify you via Gmail\u003c\/strong\u003e.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eReceives a Twilio webhook\u003c\/strong\u003e (HTTP POST) containing the outcome of a phone call.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eFilters calls\u003c\/strong\u003e to identify missed inbound calls only (e.g., \u003cem\u003eno-answer\u003c\/em\u003e, \u003cem\u003ebusy\u003c\/em\u003e, or \u003cem\u003efailed\u003c\/em\u003e), while ignoring answered or outbound calls.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eChecks your schedule\u003c\/strong\u003e by calculating whether the call occurred during configured working days and opening hours in your selected timezone.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSends an in-hours or out-of-hours SMS\u003c\/strong\u003e using Twilio—so callers get a relevant message immediately (the workflow continues even if SMS delivery fails).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eLogs details to Google Sheets\u003c\/strong\u003e, appending a record with: \u003cem\u003eTime, Caller, Number called, Call status, In hours, Reply text, Call SID\u003c\/em\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eEmails an alert via Gmail\u003c\/strong\u003e to notify the owner with the call details and the exact text message that was sent.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eSmall businesses that want callers to receive a clear “we’ll respond during business hours” message.\u003c\/li\u003e\n  \u003cli\u003eSaaS operators handling inbound support lines and tracking missed calls in a lightweight spreadsheet.\u003c\/li\u003e\n  \u003cli\u003eTeams who need visibility into call outcomes (busy\/no-answer) without manual follow-up.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eTwilio\u003c\/strong\u003e: configure “Call status changes” webhook to the workflow’s \u003ccode\u003e\/missed-call\u003c\/code\u003e production URL\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003en8n nodes\u003c\/strong\u003e: \u003ccode\u003ewebhook\u003c\/code\u003e, \u003ccode\u003etwilio\u003c\/code\u003e, \u003ccode\u003ecode\u003c\/code\u003e, \u003ccode\u003egoogle sheets\u003c\/code\u003e, \u003ccode\u003egmail\u003c\/code\u003e, plus a \u003ccode\u003esticky note\u003c\/code\u003e for guidance\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e: OAuth connection; create required headers (Time, Caller, Number called, Call status, In hours, Reply text, Call SID)\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGmail\u003c\/strong\u003e: OAuth connection for owner notification (or remove the email step)\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45830405619891,"sku":"N8N-18233","price":47.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/89smPT0yOegfZOXJig1Bm_62eJxIXO.png?v=1786698473","url":"https:\/\/buyflowscripts.com\/products\/missed-call-auto-reply-with-twilio-n8n-gmail-google-sheets","provider":"N8N Commerce","version":"1.0","type":"link"}