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.

Results
Course list in the school CRM: teacher, lesson price, teacher pay and course dates

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

Two stages: the CRM in 2024, the bot and scheduling in 2025.

  1. Stage 1 · 2024

    Process analysis

    We studied how the school works and gathered requirements from administrators, managers and teachers.

  2. 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.

  3. 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.

Course list in the school CRM: teacher, lesson price, teacher pay and course dates

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.

Student transactions in the school CRM: charges, amounts, dates and filters

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.

Lesson calendar in the school CRM with group filter and month, week and day views

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

CRM System Dev for Online German Language School

The Project
  • CRM Consulting and SI, CRM Customer Support, Other CRM focus, CRM Social Relationship Management
  • Less than $10,000
  • January 2024
Project Summary

Skylex developed a CRM system for an online German language school. The team implemented a scheduling tool, student management feature, progress tracker, payment automation, and payroll management capabilities.

5
★★★★★
★★★★★
Quality5
Schedule5
Cost5
Willing to Refer5
The Review

"The company worked very efficiently and at a high level, delivering a top-quality product."

Jan 23, 2025
Feedback Summary

Skylex delivered a high-quality CRM system that optimized the client's operations and streamlined the work of their manager and accountant. The team delivered outputs on time and always responded to the client's needs. They also explained technical concepts well and offered solutions to challenges.

The Reviewer
SEO Specialist, German Pro
Zlata Radchuk
  • Education
  • Ukraine
  • 11-50 Employees
  • Online Review

Used Technologies

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

  • PHP 8.3

    PHP 8.3

    Modern server-side language for fast data processing and site logic.

  • Symfony 6.4 (LTS)

    Symfony 6.4 (LTS)

    Reliable PHP framework for building complex and scalable web projects.

  • MySQL 8

    MySQL 8

    Popular database management system for secure and efficient data storage.

  • Linux Ubuntu 22.04

    Linux Ubuntu 22.04

    Stable OS providing a high-performance and secure server environment.

  • Nginx

    Nginx

    High-performance web server for fast content delivery and request handling.

  • Telegram Bot API

    Telegram Bot API

    Tool for building bots and automating notifications within the messenger.

Frequently asked questions
  • 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.

  • 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 development
Enter your phone number

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