Библиотека / Календарь и планирование
Календарь и планирование
Двусторонние SMS-напоминания о записях с VoxiSMS и PostgreSQL
Сохраняет записи в PostgreSQL из вебхуков, отправляет SMS-напоминания через VoxiSMS в разрешённые часы с учётом правил согласия и обрабатывает ответы YES, CANCEL, RESCHEDULE и STOP.
Что делает
## Two-way appointment reminders and confirmation tracking ### Who is this for? Salons and service businesses that need SMS confirmations and a staff queue for booking requests. ### How it works Authenticated booking webhooks update PostgreSQL. Every five minutes, the workflow checks local sending hours, consent and opt-outs, then reserves one reminder attempt per booking revision before sending through VoxiSMS. YES with a reference confirms; CANCEL and RESCHEDULE create staff requests. STOP suppresses future reminders. Bare replies match only one eligible appointment; ambiguous replies go to staff. Event deduplication and atomic reservations protect against repeated processing and overlapping runs. ### Setup and requirements Follow the setup guide and install the SQL schema. Select PostgreSQL credentials on all six database nodes, VoxiSMS credentials on both SMS nodes, and Header Auth on booking intake. Requires PostgreSQL 15+ with verified TLS, the verified VoxiSMS node, and an Android SMS line. Supports self-hosted n8n and n8n Cloud where verified community nodes are enabled. Database, n8n, VoxiSMS and carrier charges may apply. ### Customize and launch Set businessId in all three configuration nodes; adjust database reminder windows and sending hours. Start in dry run, complete the guide’s controlled tests, and assign staff to monitor the queue before activation. Staff must process cancellation/rescheduling in the booking system. API acceptance is not delivery; uncertain sends are held without automatic retries.
Шаги
- Booking intake
- Booking configuration
- Validate and store booking
- Return booking result
- Every five minutes
- Run reminder check
- Reminder configuration
- Plan reminders and flag exceptions
- One appointment at a time
- Reserve one reminder
- Send authorized
- Send VoxiSMS reminder
- Record API acceptance
- Flag uncertain send
Всего шагов: 20.
Похожие автоматизации
Синхронизация данных и ETLЭкспорт таблицы PostgreSQL в файл CSVШагов: 4Синхронизация данных и ETLЭкспорт таблицы PostgreSQL в файл CSVШагов: 6CRM и воронка продажОценка риска оттока клиентов по данным PostgreSQL и оповещения в Slack с GeminiШагов: 17Мониторинг, эксплуатация и инцидентыТриаж блокирующих сессий PostgreSQL с Ollama и одобрением в TelegramШагов: 15