Missed Call Auto-Reply with Twilio, n8n, Gmail & Google Sheets

Never Miss a Caller Again: Auto-Reply to Missed Calls with Twilio + n8n

This n8n workflow listens for Twilio call status webhooks, detects missed inbound calls, and automatically sends the caller an SMS auto-reply. It also logs every missed call to Google Sheets and can optionally notify you via Gmail.

What this workflow does

• Receives a Twilio webhook (HTTP POST) containing the outcome of a phone call.
• Filters calls to identify missed inbound calls only (e.g., no-answer, busy, or failed), while ignoring answered or outbound calls.
• Checks your schedule by calculating whether the call occurred during configured working days and opening hours in your selected timezone.
• Sends an in-hours or out-of-hours SMS using Twilio—so callers get a relevant message immediately (the workflow continues even if SMS delivery fails).
• Logs details to Google Sheets, appending a record with: Time, Caller, Number called, Call status, In hours, Reply text, Call SID.
• Emails an alert via Gmail to notify the owner with the call details and the exact text message that was sent.

Use cases

• Small businesses that want callers to receive a clear “we’ll respond during business hours” message.
• SaaS operators handling inbound support lines and tracking missed calls in a lightweight spreadsheet.
• Teams who need visibility into call outcomes (busy/no-answer) without manual follow-up.

Technical details

• Twilio: configure “Call status changes” webhook to the workflow’s /missed-call production URL
• n8n nodes: webhook, twilio, code, google sheets, gmail, plus a sticky note for guidance
• Google Sheets: OAuth connection; create required headers (Time, Caller, Number called, Call status, In hours, Reply text, Call SID)
• Gmail: OAuth connection for owner notification (or remove the email step)