💬 Track two-way SMS appointment reminders and confirmations with VoxiSMS and PostgreSQL
⚡ 0 views · 💬 Support Chatbots
Description
Quick overview
For salons and service businesses: send appointment reminders from your Android number, track SMS confirmations against the right booking, and give staff a queue for cancellation requests, unclear replies and uncertain sends.
How it works
- Authenticated booking webhooks update PostgreSQL with appointment time, timezone, phone number, consent and source update timestamps.
- Every five minutes, identify due appointments within local sending hours, respecting consent and persistent STOP opt-outs.
- Process appointments one at a time and atomically reserve one reminder attempt per booking revision, including overlapping runs.
- Send authorized reminders through VoxiSMS with an appointment reference and a custom message ID for reconciliation.
- Record API acceptance separately from delivery. Keep uncertain sends in the staff queue without automatic SMS retries.
- Verify incoming SMS signatures and match sender, receiving line and reference. YES confirms; CANCEL and RESCHEDULE create staff requests; STOP suppresses reminders. Ambiguous replies go to staff and repeated events cannot repeat state changes.
Setup
- Follow the setup guide and install the SQL schema once in PostgreSQL 15+.
- Add a business row and select a PostgreSQL credential with verified TLS on all six database nodes.
- Install the verified VoxiSMS node and choose credentials on both SMS nodes. Configure the account ID and actual SIM line separately.
- Set Header Auth on booking intake. Map booking fields from the guide and use international phone numbers and timestamps with offsets.
- Set businessId in all three configuration nodes. Keep dryRun true and database live_enabled false during setup; complete controlled tests and assign staff queue monitoring before activation.
Requirements
- PostgreSQL 15+ with verified TLS, a webhook-capable booking system, the verified VoxiSMS node and an Android phone with an active SMS line. Supports self-hosted n8n and n8n Cloud where verified community nodes are enabled. Supabase is optional. Service and carrier charges may apply.
Customization
- Adjust reminder windows and local sending hours in the business configuration. Connect the SQL staff queue to your preferred internal dashboard or notification channel.
Additional info
Staff must process cancellation and rescheduling in the booking system, then send its authenticated update. API acceptance is not handset delivery. Monitor failed executions as well as the staff queue. The complete setup package includes sample payloads and a rollback-only preview. The public export has no credentials or pinned customer data.
🔗 Nodes Used
Postgres, Webhook, Schedule Trigger
📥 Import
Download workflow.json and import into n8n:
Workflow menu → Import from File