Tech Stack

Technologies & Architecture

Pythonpython-telegram-botGoogle Sheets APIgspreadOAuth2python-dotenv

Results & Impact

Verified Project Results

Automates guided order submission and auto-generated order IDs

Uses Google Sheets as inventory, orders, admin RBAC, and payment-ledger storage

Supports manual BTC, ETH, and USDT payment workflows without storing private keys

Detailed Case Study

Overview

This Telegram bot combines guided order submission with manual crypto-payment tracking for Telegram-based storefronts. It uses Google Sheets as a lightweight operational backend instead of requiring a traditional database.

Engineering approach

Python and python-telegram-bot for the conversational workflow.
Google Sheets API and gspread for inventory, order, admin, and payment-ledger data.
Role-based administration with root and admin controls.
Live menu display, order IDs, admin notifications, and state-safe conversation handling.

Security model

The bot deliberately does not store blockchain private keys. Payments are manually verified and access is controlled through administrator records in Google Sheets.

Why it matters

The project shows how a lightweight automation layer can create a practical storefront workflow for businesses operating primarily through Telegram.