n8n Twilio Missed Call Text Back + Log to Google Sheets

Auto-SMS back missed callers with Twilio—and log every no-answer to Google Sheets

This n8n workflow listens for Twilio Voice webhook call status updates, detects missed call outcomes, automatically texts the caller back, alerts you by SMS, and records each missed call in Google Sheets for tracking and reporting.

What this workflow does

• Receives a Twilio POST webhook after a Dial attempt completes and immediately returns empty TwiML so the call flow isn’t held open.
• Filters call outcomes by checking the Twilio DialCallStatus and continuing only for: no-answer, busy, failed, or canceled.
• Text-back SMS to the caller using Twilio from your configured business number with a predefined “missed call” reply message.
• Owner alert SMS to your configured mobile number, including the caller’s number and—if present—the caller’s city.
• Logs each missed call by appending a new row to Google Sheets with: caller, called number, outcome, CallSid, timestamp, and a “texted back” flag.

Use cases

• Missed-call follow-up for small businesses: respond instantly to inbound callers who were unavailable.
• Operational alerts for reception/answering coverage: get an SMS notice when Twilio reports no-answer, busy, failed, or canceled outcomes.
• Call tracking for SaaS operators: maintain a spreadsheet of missed calls with CallSid and timestamps for auditing and process improvement.

Technical details

• Twilio integration for Voice webhook handling and SMS sending.
• Webhook trigger node to receive Twilio call status updates and respond with empty TwiML.
• if / set / no op logic to filter missed outcomes and manage message/values.
• Google Sheets credentials to append missed call records to a sheet named “Missed calls”.
• Includes workflow notes (e.g., sticky note) to guide setup.

Setup requirements

You’ll need a Twilio account with SMS capability, a Twilio phone number configured to forward calls to your real phone, and Google Sheets credentials with a target spreadsheet document ID containing a “Missed calls” sheet.