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

Description

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. An n8n automation workflow template by David Schreiber.

Categories

Tags

Capabilities

• 2 nodes
• 38 views