Twilio Missed Call Reply Workflow: Webhook to Google Sheets

Turn Twilio missed calls into instant SMS replies—and log every lead to Google Sheets

This n8n workflow listens for Twilio call-status webhooks, automatically texts missed callers back with a predefined message, records the lead in Google Sheets, and emails you a quick notification summary.

What this workflow does

• Receives a POST webhook when your phone provider sends a call-status event after a call ends.
• Checks the call status and only continues when the call is not marked as completed—answered calls are ignored.
• Builds the SMS reply payload using the caller number, your business number, and a predefined reply message.
• Sends an SMS back to the missed caller using Twilio.
• Appends a new row to Google Sheets with the time, caller number, source, and a default follow-up status.
• Sends an email summary to the owner (plain-text) via SMTP after logging the lead.

Use cases

• Missed-call lead capture: Send an immediate “sorry we missed you” SMS and create a lead record for follow-up.
• Small business response automation: Reduce missed opportunities by replying instantly while keeping owner visibility via email.
• Call center / appointment lines: Log every missed attempt with consistent follow-up status for the next action.

Technical details

• n8n webhook trigger to receive call-status POST requests.
• if node to filter out completed calls.
• set node to assemble SMS payload details.
• Twilio node to send the missed-call SMS reply.
• Google Sheets append step to store lead information (time, caller number, source, follow-up status).
• email send node to notify the owner via SMTP.
• Includes a sticky note for workflow guidance.

Setup requirements

You’ll need an n8n instance reachable from the internet for the webhook, a Twilio account with an SMS-capable number, Google access for Sheets, and SMTP/Gmail credentials for email notifications.