Telegram bot For processing returns from the mail
Goal
Create a Telegram bot to automate the acceptance of returns for Nova Poshta: tracking locations by waybills, scanning without responses, storing the entire history, and generating reports.
The project goal is to create a Telegram bot through which an operator can simply scan parcels, without distraction from the screen, and all information will be:
automatically compared with the uploaded registry,
recorded in the database (with date, time, and user),
stored in history for possible reconciliation,
generate daily reports,
keep track of undelivered and "unknown" parcels.
The bot should operate as autonomously as possible, not interfering with the operator — running in the background. All acceptance results (reports, shortages, deviations) should be automatically sent to management and the owner via Telegram.
Features
1. /start
Input return date ("18.05.2025")
A registry session is created
2. Upload Excel
Format:
.xlsxwith columnsTTN,PlacesTTN— base number (14 digits),Places— number of placesData is imported into the
registriestable
3. Scan TTN
The operator scans TTN+place (e.g.,
2045...001)The bot:
Extracts
base_ttn(first 14 digits)Searches in current/past registries
If not found — records in
unknown_ttnSaves
full_ttninscans+event_log
No messages are sent in Telegram, except for errors:
not_found,duplicate,resolved,old_registry
4. Report after completion
Command
/zavershit:Statistics: successful, duplicates, old, errors
Excel report
List of shortages
List of unknown TTN
The report is sent privately to the owner + to the management group
📊 List of shortages
Table: missing_list
TTN (
base_ttn)first_registry_datelast_seen_registry_datestatus: active / resolvedresolved_at
Logic:
If fewer places arrived than
places— record inmissing_listIf TTN arrived later —
status = resolvedSeparation into old and new
📂 Unknown TTN
Table: unknown_ttn
full_ttn,base_ttnscanned_at,scanned_bystatus: active / resolvedresolved_at
Logic:
If TTN is not in the registry and not in past — record in unknown_ttn
/neopoznannye— display all active/podtverdit <TTN>— mark as resolved, remove frommissing_listif present
⚖️ Technologies
Python 3.10+
aiogramsqlite3pandas(Excel)
📆 Structure
project/
├── main.py
├── db.py
├── config.py
├── missing.py
├── unknown.py
├── reports/
├── samples/
├── requirements.txt
└── README.md🔧 Requirements
Separation of logic
Implement all commands:
/start,/zavershit,/ostatok,/otchet_excel,/neopoznannye,/podtverdit <TTN>
README: installation, launch, Excel format
-
5 days223 USD
127 1 0 5 days223 USD
Good day!
Ready to undertake the development of a Telegram bot for automating NPL returns. I have experience working with Python, aiogram, sqlite3, pandas, as well as building structured projects with clear separation of logic.
🔧 I guarantee:
• Full implementation of the declared functionality;
• Convenience for the operator (the bot operates without unnecessary messages);
• Preservation of history, Excel reports, error tracking, and shortages;
… I can start soon. I look forward to collaborating!
-
5 days111 USD
873 11 0 5 days111 USD
I have extensive experience in developing bots, scripts, parsers in Python
my stack: MySQL, PostgreSQL, working with APIs, parsing, payment systems, web admin panels, working with large volumes of data
I will do everything qualitatively, you can see examples in my profile and on GitHub
I will be waiting for your message to learn more about some details and discuss the technical assignment.
-
5 days178 USD
757 8 0 5 days178 USD
Good day. I have 3 years of experience in developing Telegram bots in Python. The task is clear, ready to cooperate. Write to me.
-
12 days490 USD
1315 7 0 12 days490 USD
Good day.
Ready to take on your project.
I can develop a Telegram integration with Nova Poshta API for you using no-code/low-code tools.
Write to me privately, we will discuss all the details and choose the best solution for you.
-
14 days178 USD
2318 8 0 14 days178 USD
Hello!
I am ready to undertake the development of a Telegram bot for your tasks. I have experience creating similar solutions using Python with aiogram, sqlite, pandas, as well as integrating Excel spreadsheets and the Telegram API.
Write to me — we will discuss the details, deadlines, and start working.
Thank you!
-
1 day191 USD
337 1 day191 USD
Good day!
My name is Lyubov, I am a Python developer specializing in creating Telegram bots and automating business processes. I am familiar with the technical task, it is clear and interesting from an implementation perspective.
Even though I have not previously developed such projects for logistics, I have the necessary knowledge and experience to implement the described functionality:
aiogram 3.x — the main library I work with
SQLite — lightweight embedded database for storing history, scans, shortages, and unidentified TTN
…
pandas — processing Excel files, comparing with the registry, generating reports
Clear project structure: logic divided into modules, understandable and clean code
I also will implement:
All commands: /start, /zavershit, /ostatok, /otchet_excel, /neopoznannye, /potverdit
Full event logging with user, date, time
Reports in the form of Excel files with automatic sending in Telegram
Documentation (README) for launching and configuring
What I can guarantee:
Punctuality
Thorough testing
Communication at every stage
Readiness for feedback and revisions
I am ready to start immediately after agreeing on the details. Thank you for the opportunity to apply for your project!
Best regards,
Lyubov
-
5 days178 USD
4975 41 4 1 5 days178 USD
Good afternoon, Maxim!
I professionally develop bots for Telegram and web applications in Python.
I have experience working with Excel spreadsheets.
I am ready to create such a bot for you + deploy it on a server.
Write to me in private messages, let's clarify the details.
-
3 days223 USD
571 3 0 3 days223 USD
Good afternoon, I have experience in creating Telegram bots, ready to start implementing the task as soon as possible
-
20 days334 USD
316 6 0 20 days334 USD
I am proficient in the specified technologies, I have already made bots using pandas, ready to work.
-
3 days223 USD
286 3 days223 USD
Good day, I am ready to take on such a bot, let's message in private to discuss the details
-
7 days401 USD
96691 1276 1 10 7 days401 USD
Hello. I have extensive experience in developing Telegram bots. Ready to cooperate
-
6 days211 USD
1654 8 0 6 days211 USD
Good day, my name is Roman, we have already communicated with you about the scanner. I have experience in developing solutions for optimizing business processes, especially in working with TTHs.
I will wait for you in personal messages to discuss all the details.
Attaching my portfolio: https://telebots.site/
-
1 day22 USD
9927 117 0 1 day22 USD
Hello.
I am developing bots for Telegram on NodeJS. Ready to take on the task. Write to me, let's discuss.
-
Вітаю, сканувати ТТН оператор має з допомогою сканера? чи можна просто вводити цифри?
-
Maksym Yakovenko Хозмаркет
Добрый вечер, сканером, так как их много
-
Зрозумів, ваш сканер підключений як клавіатура? типу якщо, наприклад, відкрити чат в телеграмі і відсканувати ТТН то в поле для вводу вставиться код? Питаю бо є дуже багато видів сканерів і це потрібно чітко розуміти.
-
Maksym Yakovenko Хозмаркет
Да, будет всталено как обычный текст
есть возможность настроить сканер что бы после ввода каждого номера нажимался ввод -
Дякую, мені все зрозуміло, роблю ставку і чекатиму вас в особистих для детальнішого обговорення проекту)
-
Current freelance projects in the category Bot Development
Telegram bot
53 USD
I need code for a Telegram bot that will take messages from one channel, modify them to fit my design, and post them in two other channels. In one channel, from 1 to 6 posts, and in the other channel, all posts. Bot Development ∙ 7 hours 17 minutes back ∙ 40 proposals |
Tik Tok Live node.je
16 USD
It is necessary to write a mini program based on the TT-live-connector library, so that when launched, it reads the Gifts being sent and displays a smooth and beautiful animation through a regular web page. 3D Modeling, Bot Development ∙ 7 hours 54 minutes back ∙ 15 proposals |
I am looking for a strong specialist in trading bots and agents.
250 USD
It is important to start - TODAY I need a person who has experience in writing trading bots on DEXs (needed on the BSC network) with an understanding of transaction costs, gas, etc. I want to test several trading strategies on a real trading agent I need to quickly… Cryptocurrency & Blockchain, Bot Development ∙ 1 day 4 hours back ∙ 24 proposals |
Creation of a TikTok farm with income generation
601 USD
Looking for a person who can write software for a TikTok farm, so we can generate traffic and earn income. We are seeking a ready-made solution with a full cycle. Python, Bot Development ∙ 2 days 6 hours back ∙ 16 proposals |
Pocket Option trading bot
71 USD
I need a bot and your expertise who has already been able to create a similar bot when the bets are correct, they are read from Pocket Option I am interested in Brent Oil I do not need a beginner or someone who will just write code for the sake of it I need someone who knows… AI & Machine Learning, Bot Development ∙ 3 days 7 hours back ∙ 19 proposals |
Mykolaiv