2025 · Backend / Automation Developer
Chatbot & Daily-Report Automation (WhatsApp/Telegram)
WhatsApp and Telegram daily-report automation and a chatbot that answers managers' performance questions.
Private build
Problem
Managers wanted an assistant that could answer questions about the daily report, and the report itself had to reach them every afternoon on WhatsApp, by hand.
Role & constraints
Solo backend and automation work from August to December 2025, on a freelance engagement. The code is private.
Approach
I automated the afternoon report push to WhatsApp and built a question-answering chatbot over the same report data. The chatbot is limited to a fixed list of phone numbers, and the prompt is tuned so the model understands the manager's context. Data is queried from PostgreSQL and the flows run on n8n, with KNIME in the analysis step.
Result
Managers can see each area's performance quickly instead of waiting for a manual recap. Used by managers for two to three months.
Lessons
Meta's rules do not allow a bot to message anyone at will, so the audience had to be explicit and opt-in.