// Case study
AI study assistant in Telegram
You write "hand in English homework by Saturday" — the bot works out the date, saves the task to a sheet and shows what is still unfinished on request.
ROLEDesign and development
TYPEAI LAB training project
YEAR2026
// Task
Tasks scattered across chats and notes
Homework and deadlines come from different places, and entering each task into a form with a date is inconvenient, so they get lost.
// Solution
One message and the task is on the list
AI first detects the intent: add a task or show what is unfinished. For a new task it extracts the name, deadline and status, turning "tomorrow" or "next week" into an exact date.
The task goes into Google Sheets, and when asked "what haven't I done?" the bot lists open tasks with deadlines.
- Intent detection: add or list
- Deadlines in words → exact date
- Google Sheets as the task base
- Open tasks in a single message
// Architecture
How it works
TELEGRAMMessagetask in plain language
OPENAIIntentadd / list
OPENAIDataname, deadline, status
SHEETSListsave or query
// Result
The outcome
// Want the same?
Need an assistant bot?
Team tasks, requests, reminders — describe the process and I'll show how to simplify it.