BazaBot: Streamlining Client Databases via Telegram

BazaBot is a specialized tool for marketers and sales managers who need to quickly prepare “dirty” contact lists for SMS campaigns or cold calls.

🔴 The Problem

Managing databases in Excel often becomes a bottleneck:

Inconsistent Formats: Numbers starting with different prefixes (8, 7, +7) or missing country codes.
Junk Data: Duplicates, landline numbers mixed with mobile ones, and invalid entries.
Inefficiency: Wasting budget on messages sent to non-existent numbers or wrong carriers.

⚡️ The Solution: A Mobile Data Processor

We moved complex spreadsheet processing logic into the familiar Telegram interface.

1. On-the-Fly File Processing

The user simply sends a .csv or .xlsx file to the bot. It reads the data, identifies phone columns, and offers cleaning options.

2. Deep Normalization

The system standardizes all numbers to international formats, removes duplicates, and fixes common typing errors.

3. p1sms API Integration

The bot verifies numbers via API: it identifies the current carrier (HLR lookups) and marks numbers that cannot receive SMS.

🛠 Tech Stack

Python: Core development language.
Aiogram: Modern framework for Telegram bots.
Pandas/Openpyxl: Robust tools for spreadsheet manipulation.
p1sms API: External service for number status verification.

Insights: For B2B products, a Telegram interface is often more efficient than a web dashboard, allowing data processing in “two clicks” directly from a mobile device.