// Case study

Order bot for an air-conditioning installer

A manager types or dictates an order by voice. The bot adds it to the spreadsheet and calendar, sends crews their plan for tomorrow and gives the owner a report without phone calls.

CLIENTcondi-KI, AC installation and service
ROLEDesign and development
YEAR2026
MAKE.COMOPENAITELEGRAM BOT APIGOOGLE SHEETSGOOGLE CALENDAR
TELEGRAMManagertext or voice
OPENAIOrder parsingclient, address, date, price
SHEETS + CALENDARRecordsheet row + event
TELEGRAMCrews and ownertomorrow's plan, reports
40–60 mina day freed up for managers (estimate at 8–10 orders)
1–2 minto log an order instead of 5–7 min by hand
19:00every day: tomorrow's plan for each crew
1 tapowner report: today, week, month

// Task

Orders lived in chats and notebooks

Managers took orders in messengers and by phone, then copied them by hand into a spreadsheet and a calendar and forwarded them to crews separately. Some orders got lost and dates got mixed up.

The owner had no overview: how many orders, for how much, who goes where. Finding out meant calling the managers.

// Solution

One message from a manager, and the order is everywhere it needs to be

A manager writes the order to the bot in plain words or dictates it by voice. AI picks out the client, phone, address, district, date, job and price. The manager checks the card and taps "Save": the order goes into the Google Sheet and the calendar, and the managers' group gets a notification.

The manager then assigns a crew with a button and can edit an order by simply replying to its card. In the evening the bot reminds what's on for tomorrow and, with one tap, sends each crew its list in their work group.

  • Orders by text or voice: AI understands natural language
  • The spreadsheet and calendar fill themselves, no copying by hand
  • Crew, status, pause or cancel — with buttons
  • Every evening, tomorrow's plan goes to each crew's group
  • Owner report: count and total for today, the week and the month
  • Access for company managers only; owner and managers see different menus

// Result

The outcome

Forecast at launch: data is entered once, so no lost orders or date mix-ups, and the owner sees the numbers without a single call.

// Leave a review

RATING *

The review appears on the site after a check, usually within a day.

// Want the same?

Still taking orders by hand?

Installation, repairs, delivery, cleaning — the logic is the same. Tell me how an order travels from the first call to the job today.

Telegram Send a request
Message on Telegram