Telegram chatbot with voice recognition and message batching using OpenAI
This Telegram workflow batches rapid-fire messages from the same user into one prompt (20–30s debounce), then sends a single AI reply.
It uses **two Google Sheets**:
- **Message Retention** (`date | user_id | message`) — queues incoming messages.
- **Message Checkup** (`user_id | is_waiting | last_updated`) — debounces per user.
Flow per message:
1. Log to **Message Retention**.
2. Read **Message Checkup** for that `user_id`. If empty, synthesize `{ is_waiting:false }`.
3. IF (**OR**):
- `last_updated` is **older than 30s**, **or**
- `is_waiting` is **false**
→ Start wait window: set `is_waiting=true`, update `last_updated`, **Wait** (e.g., 30s).
4. After Wait: fetch all queued messages for the user, merge them, delete those rows, send one AI answer to Telegram, then clear the Waiting row.
5. If a new message arrives while waiting, we only refresh `last_updated` (extend the window) — we do **not** start another wait.
Copy/paste:
- Older-than-30s: `{{ new Date(Date.now() - 30000).toISOString() }}`
- “No Rows” normalizer (Code node) ensures the IF always has data to check.
Supports text and voice (voice via Whisper). Works reliably on Telegram once the webhook is registered and Sheets are shared with the service account.