BazaBot — Telegram bot for cleaning client bases
Number normalization, carrier filtering, and deduplication for CSV/XLSX, all inside Telegram.
- Python
- Telegram Bot API
- Data Cleaning
- p1sms API
BazaBot: prepping client bases inside Telegram
BazaBot is an internal tool for marketers and sales managers who need to quickly turn a messy contact list into something usable for SMS or calling campaigns. I moved the heavy lifting out of spreadsheets into Telegram so it can be done from a phone in under a minute.
The class of problem
Contact bases in Excel are almost always dirty: mixed prefixes (8, 7, +7, none), duplicates, landlines mixed with mobile, invalid rows. Without normalization, budget is spent reaching nobody — and manual cleanup eats hours.
What’s inside
- In-chat file processing. User drops a
.csvor.xlsx, the bot detects the phone column and offers cleanup options. - Normalization to international format. Dedup, common-typo fixes.
- HLR check via p1sms. Bot identifies the actual carrier and flags numbers that cannot receive SMS.
Stack
Python, Aiogram, Pandas/Openpyxl, p1sms API.
What this case shows about me
Sometimes the right interface isn’t a web dashboard — it’s Telegram. I pick the surface based on the audience and scenario, not on portfolio aesthetics. Built and shipped in a day.