Bot that collects reports from 10 targetologists and creates polished client reports
Reads reports from the team chat via LLM parsing, creates weekly reports, tracks KPI in Google Sheets and helps managers compile client reports in one click.
Context
A marketing agency with a team of more than 10 targetologists. Each targetologist writes reports on their clients in a shared Telegram work chat.
Task
Managers manually collected reports to send to clients. Chat reports were in free form, hard to systematize. Hours spent on weekly reporting.
Solution
- Bot reads all reports from the Telegram work chat
- LLM parsing extracts structured data: client, metrics, completed tasks
- Generates weekly reports in a readable format
- Pushes KPI to Google Sheets with automatic updates
- On one request, a manager gets a ready period report for a client
Result
The project focused on a practical business task: removing manual routine, reducing errors and giving the team a clear tool for everyday work. The main effect is reflected in the metric: ~12 h/wk — of management time freed from reporting per week.
Project gallery
Click an image to open a larger view
Result
KPIWant something similar? Free audit
Tell us about your task — we'll figure out what and how to automate in one call.