See llms.txt for all machine-readable content.

Back to Templates

Send appointment SMS follow-ups with Typeform, Twilio, and Google Sheets

How it works

  • πŸ“‹ Customer submits your Typeform β†’ instant personalised welcome SMS fires via Twilio
  • πŸ“Š Submission logged to Google Sheets with name, phone, timestamp, and nudge tracking
  • πŸ’¬ Twilio listens 24/7 for replies β†’ marks customer as responded, stops all future nudges
  • ⏰ Scheduler runs every 6 hours β†’ finds non-responders and sends up to 2 follow-up nudges
  • πŸ›‘ System stops contacting anyone who replies or hits the 2-nudge limit

The three branches

Branch Trigger What it does
🟒 New Submission Typeform form submit Welcome SMS + log to Sheets
πŸ”΅ Reply Handler Incoming Twilio SMS Mark replied, stop nudges
🟑 Nudge Engine Schedule every 6hrs Nudge 1 at 24h, Nudge 2 at 48h

Why this matters

Metric Manual This workflow
⚑ Speed to lead Hours or days Under 10 seconds
πŸ” Follow-up consistency Whoever remembers 100% automated
πŸ“‰ Lead drop-off High β€” people go cold fast Nudges catch non-responders
🧠 Staff time per lead 5–15 min Zero
πŸ’Έ Revenue at risk Every ignored inquiry Recovered automatically

Studies show leads contacted within 5 minutes are 9x more likely to convert. This workflow makes that the default β€” not the exception.

What you need

Tool Cost Why
Typeform Free tier works Intake/booking form
Twilio ~$1/mo + $0.0075/SMS Send and receive SMS
Google Sheets Free Track submissions and nudge state

⚠️ A2P 10DLC notice: Twilio requires business registration for production SMS in the US. Allow 2-4 weeks. Your signup form needs opt-in language, terms, and a privacy policy.

Set up steps

  • Takes about 15 minutes
  • Create a Google Sheet with columns: customerName Β· customerPhone Β· submittedAt Β· repliedAt Β· nudgeCount Β· lastNudgeAt
  • Branch 1 β€” connect Typeform, select your form, connect Twilio + Google Sheets
  • Branch 2 β€” connect Twilio trigger for inbound SMS, connect Google Sheets to mark replied
  • Branch 3 β€” connect Google Sheets to read non-responders, connect Twilio to send nudges
  • Verify Typeform field names match the Extract node exactly (case-sensitive)
  • Submit a test entry with your own phone, reply to it, confirm Sheets updates correctly
  • Toggle workflow Active

Learn more at SMB Excel