Telegram CRM bot for water delivery service

A fully functional Telegram bot has been implemented for managing water delivery orders. The bot provides automated interaction with the user, allowing them to order water, track the status of orders, and manage delivery addresses without the need for manual control.

The bot offers a convenient and interactive interface in Telegram, supporting multi-step processes through FSM and integration with Google Sheets for data storage.

Key features:

User registration — collection of full name, phone number, and delivery address

Order placement — support for a multi-step process for ordering water (19L)

Automatic address suggestion — for repeat customers, the address is suggested automatically

Viewing own orders — the user can check the status of their requests

Support for donations via Telegram Stars — the ability to support the service

User blocking — middleware for a blacklist has been implemented

Asynchronous operation — efficient processing of user requests

Integration with Google Sheets — storage of data about customers, orders, and the blacklist

Technology stack:

#Python — main logic of the project

#Aiogram 3 — implementation of the Telegram bot and FSM for step-by-step interaction

#Google Sheets (gspread) — storage and processing of customer and order data

#Asyncio — asynchronous operation with the bot and Google Sheets

#Telegram Payments (Stars) — implementation of donations

Stable and scalable architecture, modular structure

The project has been developed with a focus on reliability, user-friendliness, and the potential for further scaling. The solution is suitable for individual use or a commercial water delivery service.