Mikhail IvanovAll case studies / AI Assistants & Agents
A bot sends the shop owner a daily summary, while AI finds discrepancies in the numbers
Industry: Auto repair shopScale: 4 mechanics and a service advisor, records kept in ExcelTimeline: first stage in 7 days, running since MayCategory: AI assistants and agents
every daydaily summary for the owner and mechanic workload in the morning
Telegram + MAXreports arrive in both messengers
since Mayrunning, client extended it for a year
Package based on this case study: AI Assistant and Voice Bot for Customer Booking · from $1,500
Before
- Records were kept in Excel: the service advisor filled out the file every day
- The owner needed a daily summary without manually collecting the numbers
- The owner needed to see mechanic workload and remaining oil inventory
What we built
- In the evening, the bot receives the daily Excel file and checks it against the plan
- It sends the owner revenue, cash balance, daily and monthly targets, cars in the parking lot, and oil inventory with thresholds
- In the morning, it sends mechanic workload from Google Calendar to the work group
- AI analyzes anomalies, such as billed labor hours that do not match workload, and provides conclusions
- The owner asks his ChatGPT questions about the numbers: the bot's data is connected to it
How it works
Daily Excel filefrom the service advisor
→
Check against planPostgreSQL database
→
AI analysisanomalies and conclusions
→
Owner reportTelegram and MAX, text and dashboard
Result
- The first stage was delivered in 7 days and paid for
- The client continued the project and paid for the next stages and a year of server hosting
- The server is in Russia, the database is backed up daily, and a watchdog sends an alert if the service goes down
Technology
What matters in a project like this. A small business owner does not need another dashboard to open. He needs a short report in a messenger at the same time every day. Everything else he can ask the AI in plain language.
Have a similar project?
Describe it in two lines in Telegram. We'll explain how we'd approach it, how long it would take, and what it would cost.
Similar case studies
Auto parts marketplace
LLM parts search audit cuts query cost by 16.7% without losing accuracy
−16.7%cost per query: $0.1353 → $0.1128
SaaS for local businesses: review responses
SaaS collects reviews from 8 platforms and drafts AI responses for each business niche
8 platformsreviews collected from them
Education startup (EdTech)
MVP platform where AI creates teaching materials, with a quality judge and data isolation
550+ testsindependent verifier run, types passed without errors