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