Background

Before reaching out to us, the language school was actively expanding the number of students and training programs, but all operational work remained in “manual mode.”

The data was stored in different places:

  • Telegram chats with managers and teachers;
  • Excel spreadsheets with student records and payments;
  • Google Forms and separate files;
  • paper notebooks and handwritten notes.

As a result, typical challenges emerged: information was duplicated or lost, some requests were not processed in time, and there were mistakes in payment and attendance records. Managers spent a lot of time searching for data and manually updating reports.

The school realized that further growth required a centralized system that would take over routine operations, store all data in one place, and enable scaling without chaos.

Project Stages

The client approached us with a request to fully automate the school’s operational processes. We analyzed the existing workflow, gathered requirements from administration, managers, and teachers, and delivered the first phase of the solution. After the successful launch of the CRM system, the client came back with new needs — and we began the second phase to expand functionality.

  • 2024

    CRM System

    At the first stage, a CRM system was developed to centralize the management of users, finances, and learning processes. This made it possible to eliminate scattered records, bring order to the data, and create a unified digital environment for school administration.

  • 2025

    Telegram Bot & Scheduling Module

    At the second stage, we expanded the system by developing a Telegram bot that automatically receives requests and transfers them to the CRM. We also integrated a course and schedule planning module to optimize group enrollment and the organization of the learning process.

Main Project Goals

  • Automate all key school processes

    1

    The goal is to eliminate manual data entry, reduce the number of errors, and ensure a stable learning process without excessive administrative workload.

  • Reduce manual work for staff

    2

    The CRM takes over routine operations: processing payments, recording students, updating schedules, and managing attendance. This allows staff to focus on teaching and working with clients.

  • Centralize all data in one system

    3

    All information — student records, payments, balances, schedules, and lesson history — is stored within a single environment, eliminating chaos from Excel files, chats, and paper notes.

  • Ensure accurate tracking of lessons, payments & attendance

    4

    The CRM automatically records financial operations, lesson usage, student presence and absence, creating a transparent control system without constant manual intervention.

  • Speed up request processing via Telegram bot

    5

    The bot accepts applications 24/7, structures them, and instantly sends them to the CRM. The manager receives immediate notifications, reducing response time from 15–20 minutes to 1–2 minutes.

  • Build a scalable CRM that can be expanded

    6

    The system is designed modularly: new features, integrations, analytics, sections for online courses, or mobile solutions can be added when needed — without rewriting the entire project.

CRM Functionality

The system is built on the principle of modularity — each component solves specific business tasks on its own, while together they ensure a seamless and manageable educational process. Below are the main CRM modules:

  • Course Planning
  • Users
  • Finance
  • Learning
  • The module is responsible for forming new study groups and moving students between levels. The system allows filtering courses by proficiency level, age group, teacher, and required date range to quickly identify which groups continue their studies and which require new enrollment. A manager can select students for a new course, assign a teacher, and instantly generate the schedule. The module displays real-time group capacity — how many seats are confirmed, who is still deciding, and how many spots remain open — helping to plan the next academic period without chaos.

  • This module contains all information about participants of the learning process. The system stores student data — their contacts, courses, groups, balances, payment history, and attendance; teacher data — their workload, schedule, and completed lessons; as well as information about administrators and managers with different access levels. The module enables quick user search with filters, role and access assignment, editing of user profiles, and adding new users.

  • The finance module completely replaces manual accounting in spreadsheets. Funds are automatically deducted from a student’s balance after each completed lesson, while all top-ups and charges are recorded in a single payment history with filtering by date, student, teacher, or course. The system also generates PDF reports for teachers for a selected period, allowing management to see the real financial situation in just a few clicks.

  • The learning module manages all educational processes: creating and editing courses, managing groups and individual lessons, and displaying schedules in an interactive calendar with filters by teachers and groups. The system tracks student attendance and absences, and enables flexible editing or rescheduling of lessons according to changes in the timetable.

Banner Background

Telegram Bot

The bot is the first point of interaction between a student and the school. It automates the intake of inquiries, tracks their status, and transfers all information to the CRM — without any involvement from the manager.

  • General Requirements for the Bot
  • Course Information
  • Creating a Payment
  • Canceling a Payment
  • Creating a Student
  • Notifications
  • Message Templates
  • The Telegram bot works in read-only mode and does not modify data directly — it only initiates the creation or update of records inside the CRM. All information must be synchronized automatically with the CRM and displayed in real time. Authorization is restricted to managers only, and all interaction flows must remain intuitive and fast for daily operations.

  • The bot allows managers to instantly receive up-to-date information about courses. They can filter courses by proficiency level (A1, A2, B1, etc.) and age category (adults or children). After selecting a course, the bot displays the number of confirmed students, pending students, and remaining available seats — helping managers make quick decisions on recruitment. All data shown in the bot is always synchronized with the CRM.

  • The manager can initiate the creation of a payment directly in the bot for a specific student enrolled in a specific course. In the bot, the course is selected first, then the student from the course list. After that, the system generates a transaction with the status “Invoice Created”. All data is recorded in the CRM automatically, without the possibility of editing it in the bot.

  • When a student makes a payment, the manager can quickly record it through the Telegram bot. The manager selects the transaction from the list of payments that are waiting to be confirmed and changes the status to “Paid”, while the actual payment details are stored and tracked in the CRM.

  • The bot allows the manager to quickly add a new student to the CRM without opening the admin panel. The manager enters the student's name, contact details, assigned manager, and current skill level. After submission, the data is automatically created in the system.

  • The bot automatically reminds the manager about important events: payment deadlines, course completion dates, missed lessons, and overdue payments. In addition to notifications in the chat, the bot also sends daily digest messages with a short Status summary, showing all tasks and upcoming actions that require the manager’s attention.

  • Pre-defined message templates for communication with students are created in the admin panel. In the bot, the manager has access to a list of these templates and can choose the one needed to copy or send directly to the chat. Templates cannot be edited inside the bot — only displayed.

Banner Background

Results

The implementation of the CRM system and Telegram bot enabled the school to fully automate student management, reduce the workload for managers, and accelerate the processing of new requests. Significant improvements were achieved already during the early stages of using the platform.

  • 80 %

    Reduction of manual work for managers

  • 90 %

    Increase in conversion from inquiry → course enrollment

  • 100 %

    All student data stored in a single system

  • +25 %

    Growth in the number of students in the first academic period

  • 0 %

    Lost inquiries or missed contacts

Used Technologies

To deliver this project, we used a modern technology stack focused on stability and scalability:

  • Backend

    PHP 8.3, фреймворк Symfony 6.4 (LTS)

  • Backend

    MySQL 8

  • Server Infrastructure

    Linux Ubuntu 22.04

  • Web Server

    Nginx

  • Integrations

    Telegram Bot API

  • Integrations

    RabbitMQ

  • Server Infrastructure

    Redis

  • Security Infrastructure

    Cloudflare

Support

Skylex is the official technical partner of the project, responsible for the full development cycle, technical support, and further platform scalability. We ensure stable system performance, implementation of new functionality, and prompt response to business needs.

Fill out the form to receive a free consultation

Enter your name in Cyrillic or English
Enter your phone number
By clicking the button, you consent to the processing of personal data