Portfolio demonstration

Telegram intakefor a small studio desk.

LeadFlow Bot collects structured customer requests in Telegram and hands them to an administrator with status, notes, and CSV export. This preview is an interactive model of the Python bot — not paid client work.

Python 3.12 · aiogram 3 · SQLAlchemy 2 · SQLite

09:41
Lf

LeadFlow Bot

demo · not a live client bot

LeadFlow is a request desk for a small service studio. Send a structured brief and the team will follow up using the contact method you prefer.

What it covers

A complete lead path, not a toy /start handler.

Customer conversation

Welcome, menu, five-step brief, confirmation with edit/cancel, human-readable lead numbers, and a personal request list.

Administrator desk

Counts by status, recent leads, full detail, status changes, internal notes, customer notifications, and CSV export.

Admin-only access

Administrator commands and callbacks are gated by Telegram user IDs from the environment. Unknown users never see lead data.

Production-minded defaults

Validation, phone normalisation, HTML escaping, duplicate protection, structured logs, Alembic migrations, tests, and Docker.