Twilio'siz uchrashuv eslatmalarini qanday sozlash mumkin

O'tkazib yuborilgan uchrashuvlar xizmat ko'rsatish korxonalariga har yili minglab dollarga tushadi. Bir kun oldin yuborilgan oddiy SMS eslatma kelmay qolish holatlarini 30-50% ga kamaytirishi mumkin. Ammo buning uchun Twilio'ni sozlash ortiqcha ko'rinadi — va xarajatlar ko'payib boradi.

Mana, o'z telefoningizni SMS shlyuzi sifatida ishlatib, juda oddiy uchrashuv eslatma tizimini qanday qurish mumkin.

Nega shunchaki Twilio'dan foydalanmaslik kerak?

Oyiga 200 ta eslatma yuboradigan kichik klinika yoki salon uchun Twilio xarajatlari:

• Xabarlar: 200 × $0.0079 = $1.58
• Operator qo'shimcha to'lovlari: 200 × $0.003 = $0.60
• Telefon raqami: $1.15/oy
• 10DLC ro'yxatdan o'tish: $2/oy + $15 bir martalik
• Sozlash vaqti: 1-2 soat (SDK, verifikatsiya, ro'yxatdan o'tish)

Jami: ~$5.33/oy + sozlash muammosi. Va agar ro'yxatdan o'tish rad etilsa (kichik bizneslar uchun tez-tez uchraydi), siz qiyin ahvolda qolasiz.

MySMSGate bilan: 200 × $0.03 = $6.00/oy. Ro'yxatdan o'tish shart emas, sozlash muammosi yo'q, 5 daqiqada ishga tushadi. Mijozlaringiz tasodifiy Twilio raqamini emas, balki sizning haqiqiy telefon raqamingizni ko'rishadi.

1-variant: Google Sheets + Apps Script (Kodsiz)

Eng oddiy yondashuv — agar siz uchrashuvlarni allaqachon elektron jadvalda kuzatib borsangiz, mukammal yechim.

Jadvalingizni sozlang

Quyidagi ustunlar bilan Google Sheet yarating:

Skriptni qo'shing

Kengaytmalar (Extensions) → Apps Script bo'limiga o'ting, ushbu kodni joylashtiring:

function sendReminders() {
  var sheet = SpreadsheetApp.getActiveSheet();
  var data = sheet.getDataRange().getValues();
  var tomorrow = new Date();
  tomorrow.setDate(tomorrow.getDate() + 1);
  var tomorrowStr = Utilities.formatDate(tomorrow, "GMT", "yyyy-MM-dd");

  for (var i = 1; i < data.length; i++) {
    var name = data[i][0];
    var phone = data[i][1];
    var date = Utilities.formatDate(new Date(data[i][2]), "GMT", "yyyy-MM-dd");
    var time = data[i][3];
    var reminded = data[i][4];

    if (date === tomorrowStr && !reminded) {
      var message = "Hi " + name + ", reminder: your appointment is tomorrow at " + time + ". Reply YES to confirm or call to reschedule.";

      UrlFetchApp.fetch("https://mysmsgate.net/api/v1/send", {
        method: "post",
        headers: {
          "Authorization": "Bearer YOUR_API_KEY",
          "Content-Type": "application/json"
        },
        payload: JSON.stringify({to: phone, message: message})
      });

      sheet.getRange(i + 1, 5).setValue("Yes");
    }
  }
}

Rejalashtirish

Apps Script'da Triggers → Trigger qo'shish (Add Trigger) bo'limiga o'ting:

• Funksiya: sendReminders
• Hodisa: Vaqtga asoslangan (Time-driven) → Kunlik taymer (Day timer) → 9am–10am

Tayyor. Har kuni ertalab skript ertangi uchrashuvlarni tekshiradi va avtomatik ravishda eslatmalar yuboradi.

2-variant: Python skripti (Dasturchi)

Agar sizda ma'lumotlar bazasi bilan bron qilish tizimi bo'lsa:

import requests
import sqlite3
from datetime import date, timedelta

API_KEY = "YOUR_API_KEY"
tomorrow = date.today() + timedelta(days=1)

db = sqlite3.connect("bookings.db")
appointments = db.execute(
    "SELECT name, phone, time FROM appointments WHERE date = ? AND reminded = 0",
    (tomorrow.isoformat(),)
).fetchall()

for name, phone, time in appointments:
    message = f"Hi {name}, reminder: your appointment is tomorrow at {time}. Reply YES to confirm."

    response = requests.post(
        "https://mysmsgate.net/api/v1/send",
        headers={"Authorization": f"Bearer {API_KEY}"},
        json={"to": phone, "message": message}
    )

    if response.json().get("success"):
        db.execute("UPDATE appointments SET reminded = 1 WHERE phone = ? AND date = ?",
                   (phone, tomorrow.isoformat()))

db.commit()

Cron bilan ishga tushiring: 0 9 * * * python3 /path/to/reminders.py

3-variant: Zapier / Make (Kodsiz)

Agar siz Calendly, Google Calendar yoki Zapier integratsiyasiga ega boshqa biror bron qilish vositasidan foydalansangiz:

1. Trigger: "Google Calendar'da yangi hodisa" (yoki Calendly, Acuity va h.k.)
2. Harakat: Hodisadan 1 kun oldin kechiktirish
3. Harakat: Zapier orqali Webhooks → https://mysmsgate.net/api/v1/send manziliga POST so'rovi

Sarlavhalarni sozlang (Set headers): Authorization: Bearer YOUR_API_KEY

Tana qismini sozlang (Set body): {"to": "{{phone}}", "message": "Hi {{name}}, reminder: your appointment is tomorrow at {{time}}."}

Samarali eslatmalar uchun maslahatlar

• 24 soat oldin yuboring — mijozlarga qayta rejalashtirish uchun vaqt beradi
• Vaqtni kiriting — "ertaga soat 3 da" "ertaga" dan yaxshiroq
• Tasdiqlashni so'rang — "Tasdiqlash uchun HA deb javob bering" jalb qilishni oshiradi
• Qisqa tuting — 1 ta SMS segmenti (160 belgi) idealdir
• Biznesingiz nomidan foydalaning — mijozlar sizning raqamingizni tanishadi, chunki bu sizning raqamingizdir

Bepul boshlang — eslatmalarni 10 daqiqadan kamroq vaqt ichida sozlang.