Problem: Leads Lost In Chat Threads
A 6-person B2B sales team received leads from 4 sources: website, WhatsApp, email, and phone. Managers tracked them in Google Sheets but often forgot to update statuses. Up to 20% of leads were lost or processed with 2+ hour delays.
“We couldn't tell how many real leads we had or what stage each one was at.” — Head of Sales
Solution: Telegram Bot With Auto-Statuses
We built a bot in 3 days. Here's what it does:
- Captures leads from website forms and email (inbound parsing)
- Assigns status: New, In Progress, Waiting Reply, Closed
- Alerts managers in Telegram when a new lead arrives
- Reminds if a lead sits without response for over 1 hour
- Sends daily report to the team lead: new leads, closed, avg response time
First Month Results
-80%lost leads
15 hrssaved per week
12 minavg response (was 47)
Tech Stack
Python + aiogram for the bot, SQLite for lead storage, FastAPI for website webhooks. Total project cost: ~$150, delivered in 3 working days.
Key takeaway: if leads come from multiple sources and are handled manually, a Telegram bot with a database and statuses solves 80% of problems in the first week.