Back to Projects

Conversational Business Automation

Telegram Inventory & Profit Bot

A Telegram-based assistant for boutique businesses to record purchases and sales, manage stock, and check profit or loss through simple conversational commands.

Telegramn8nDatabaseAPIsBusiness Logic

Inventory Bot

Chat commands

Telegram

Live activity

Live

Stock

Chat

Entries

Instant

P&L

Telegram
n8n
Database
APIs
Business Logic

Section 01

The Problem

Notebook bookkeeping

Purchases and sales are written down and reconciled at the end of the day.

Spreadsheet drift

Stock counts in a sheet stop matching what is actually on the shelf.

Profit is guesswork

Working out margin means adding up receipts by hand.

No time for software

Shop owners will not open a dashboard mid-sale to log a transaction.

Section 02

The Solution

Record Purchases

New stock is logged in one short message.

Record Sales

Sales are captured the moment they happen.

Automatic Inventory Updates

Stock adjusts itself after every transaction.

Stock Level Tracking

Current quantities are always one question away.

Revenue Calculation

Takings are totalled without a spreadsheet.

Profit / Loss

Margin is calculated from real purchase and sale data.

Conversational Queries

Ask the business a question in plain Telegram chat.

Section 03

How It Works

Telegram MessageStep 1
Interpret ActionStep 2
Update DatabaseStep 3
Recalculate InventoryStep 4
Calculate Profit / LossStep 5
Send ResponseStep 6

Section 04

System Architecture

Telegram

The only interface the owner needs

n8n

Parses the message and runs the flow

Business Logic

Stock, revenue and margin rules

Database

Transactions and inventory records

Telegram Response

Confirmation or answer sent back

Business logic layer

Every message resolves to an action — buy, sell or query — and the same rules recalculate stock, revenue and profit before the reply is sent.

StockRevenueMargin

Section 05

Tech Stack

Telegram

Conversational interface

n8n

Workflow orchestration

Database

Inventory and transactions

APIs

System integrations

Business Logic

Profit and stock calculations

Section 06

What This Project Demonstrates

Conversational Interfaces

Chat as a complete business UI.

Business Automation

Daily operations handled without admin work.

Database Integration

Reliable reads and writes behind a chat.

Workflow Logic

Branching rules that stay consistent.

Let's build

Want something like this for your business?

I build custom AI and automation systems around real business workflows.