Usually 4 to 12 weeks: a simple system is faster, a system with integrations and analytics takes longer. Here the CRM was launched as the first stage, and the bot and scheduling were added the following year.
Case study · German Pro · online German language school
CRM System & Telegram Bot for Language Schools
Students, payments, schedule and requests in one system instead of Excel, chats and notebooks.
1–2 minutes
to answer a request instead of 15–20 minutes
24/7
the Telegram bot accepts requests without a manager
5.0 on Clutch
client rating for quality, schedule and cost
Client
German Pro is an online German language school from Ukraine with 11–50 employees. The school runs groups from A1 to C2, teaches adults, children and teenagers, and was actively growing its number of students and courses.
Before
The number of students was growing, but all of the school's operations were still handled manually.
01
Data in different places
Telegram chats, Excel sheets, Google Forms, separate files and paper notebooks.
02
Lost requests
Information was duplicated or lost, and some requests were not processed on time.
03
Payment errors
There were mistakes in payment and attendance calculations.
04
Time spent searching
Managers spent a lot of time looking for data and updating reports by hand.
How we did it
-
Stage 1 · 2024
Process analysis
We studied how the school works and gathered requirements from administrators, managers and teachers.
-
Stage 1 · 2024
CRM system
We built a CRM for managing users, finances and the learning process. Scattered records disappeared, and the data came together in one place.
-
Stage 2 · 2025
Telegram bot and scheduling
After the CRM launch, the school came back with new tasks. We built a Telegram bot that accepts requests and passes them to the CRM, plus a module for planning courses and schedules.
Key decision
Build the CRM in modules. First the school got its data in order, and once the CRM was running, we added the bot and scheduling without rewriting the system.
The solution on screen
All courses and groups in one list
Each course shows the teacher, price, students and dates. Managers filter courses by level, age and teacher and see which groups need new students.
Group teacher. Each course has an assigned teacher, whose profile opens in one click.
Lesson price. After a lesson, the system deducts the amount from the student's balance on its own.
Teacher pay. The rate per lesson goes into transactions and the teacher's PDF report.
Hide a course. A course that is currently inactive can be hidden from the list.
Payments without spreadsheets
After each lesson, the money is deducted from the student's balance automatically. All top-ups and charges are in one history with filters by date, student, teacher or course, and teachers get PDF reports.
Schedule in a calendar
Group lessons and individual classes are in a calendar with filters by group and teacher. Attendance is marked and lessons are rescheduled right there.
Telegram bot for the school
The bot accepts requests from students and passes them to the CRM, and gives managers quick access to courses and payments. Login requires authorization, and data changes only through the CRM.
Courses and free seats
A manager picks a level and age group and sees how many seats are free, who confirmed and who is waiting to pay.
Invoice and payment
In the bot, a manager can issue a payment for a student's course and mark it as paid with the actual date.
New student in a minute
A manager enters the name, contact and level, and the student appears in the CRM without opening the admin panel.
Reminders and templates
The bot reminds about deadlines and overdue payments, sends a morning digest of tasks and offers ready message templates for students.
Results
The school manages students, payments and schedules in one system, and the CRM and bot took over the routine.
All data together
Student records, payments, balances, schedules and lesson history are stored in one place.
Payments calculate themselves
The CRM records lesson charges, attendance and absences without manual work.
Reply in 1–2 minutes
The bot accepts requests around the clock and notifies a manager right away, so a reply takes 1–2 minutes instead of 15–20.
The system grows in modules
New features and integrations are added without rewriting the project, as happened with the bot.
Client review on Clutch
Used Technologies
To deliver this project, we used a modern technology stack focused on stability and scalability:
-
PHP 8.3
Modern server-side language for fast data processing and site logic.
-
Symfony 6.4 (LTS)
Reliable PHP framework for building complex and scalable web projects.
-
MySQL 8
Popular database management system for secure and efficient data storage.
-
Linux Ubuntu 22.04
Stable OS providing a high-performance and secure server environment.
-
Nginx
High-performance web server for fast content delivery and request handling.
-
Telegram Bot API
Tool for building bots and automating notifications within the messenger.
-
-
From €1,000. The cost depends on the number of modules, roles and integrations, so we give an exact price after analyzing your processes.
-
Yes. Here the bot accepts requests, shows managers courses and free seats, issues and marks payments, and all data is stored in the CRM.
-
A student tops up their balance, and after each lesson the money is deducted automatically. The full payment history can be filtered by date, student, teacher or course.
-
Yes. The client in this case is an online school, and the system also fits other schools and online learning platforms.
-
Yes. The system is modular: in 2025 we added the bot and course scheduling without rewriting the CRM.
Does your school also track students in spreadsheets and chats?
About custom CRM developmentGreat!
We will contact you shortly