Telegram bot for automatic data transfer from the "Spillage" group to Google Sheets
112 USD Goal: automation of recording the results of beer pouring in the "brew passports" tables for loss control and reconciliation with HACCP forms.
1. General description
It is necessary to create a Telegram bot that:
* reads messages from the Telegram working group ("Pouring");
* recognizes the format of beer pouring reports (manually entered by operators);
* determines the type of container (bottle 0.33 / can 0.33 / can 0.5 / keg 25 l / 27 l / 30 l / 50 l);
* transfers the received data to the corresponding cells in Google Sheets;
* keeps a log of all events (who sent, when, what volume);
* has a flexible system for selecting the required sheet (brews);
* does not change formulas in the HACCP table (only adds values to the column “Total (pcs)”).
2. Input data
The client provides:
* Access to the working Google Sheets file (link to the document);
* Example of the pouring template;
* Example messages from the Telegram group “Pouring”.
3. Expected result
* The Telegram bot works successfully in a real chat.
* Data is automatically added to the corresponding cells of different sheets.
* HACCP formulas are not damaged.
* Event log is created.
* Code is commented and structured.
* The client is provided with:
* source code
* brief instructions for updating the token and changing cells
* example of the working result (video or GIF recording).
4. Estimated budget and deadlines
* Budget: 2000 UAH
* Deadline: up to 7 days
Additionally
* Add auto-check for losses: if in the table the formula “% losses” > 4 %, the bot sends a warning in the chat.
* Ability to reset data “by date” (for example, at the start of a new day).
* Add the command /export → sends a brief summary of the day from all sheets to the chat.
Applications 3
Client's review of cooperation with Roman P.
Telegram bot for automatic data transfer from the "Spillage" group to Google SheetsEverything is great, the project was completed on time, if any questions arise, they are resolved quickly. The work was done well.
Freelancer's review of cooperation with Dariia Bandura
Telegram bot for automatic data transfer from the "Spillage" group to Google SheetsWe discussed the bot's technical specifications in detail and considered various options. Daria is always in touch, pleasant to communicate with, and showed understanding regarding the delay due to power outages. There were no problems in the work.
I recommend collaborating!
-
1 day45 USD
1 day45 USD
Good day! I already have a bot with a similar function in Excel. I am ready to redo it according to your specifications in Google Sheets. I am ready to start working right now and finish it today!
-
1 day45 USD
1 day45 USD
Hello, I worked on a Telegram bot for automatic data entry into Google Sheets - processing over 5 messages daily, automated 3 types of data.
How do you plan to identify the type of tariff in the messages if the format will vary slightly?
I suggest we get in touch, I will provide you with free technical consultation and we will create a development plan + I will tell you about my team!
-
15 days223 USD
4532 11 0 15 days223 USD
I am ready to implement a Telegram bot.
But in the best case, you need not only the bot but also a data storage base.
If necessary, I would create a personal application for data management.
If this vision meets your requirements, I will start developing the project structure and a detailed technical plan with files and modularity.
-
3 days45 USD
446 10 0 3 days45 USD
Good day!
I have over 4 years of experience in developing Telegram bots of various complexity (examples in the portfolio and completed works). I have already implemented a similar bot with Google Sheets integration — there will be no issues. I will develop the bot in 3-4 days and am also ready to complete additional points.
I can also assist with bot configuration and adding new functionality in the future.
I look forward to collaborating!
-
1 day89 USD
148 1 1 1 day89 USD
Ready to complete this project. I have extensive experience in developing various applications.
-
1 day89 USD
1002 5 1 1 day89 USD
Good afternoon, a budget of 2 is a bit low, especially considering that without AI, a strict sequence and proper parsing will need to be done. I can do it for 4 without AI; with AI, I can do it for 2, and it’s better for you since AI will understand even the most inadequate messages correctly. The costs for AI are small, and you will also need to pay for hosting $5 monthly.
It's up to you; I set it at 4 without AI.
Overall, I can implement it in a day; I need access to the spreadsheet. In Google Console, you need to create an APP for working with Google Sheets, preferably from this account, then we will immediately access the spreadsheet without setting up a script in the spreadsheet.
-
5 days446 USD
291 5 days446 USD
Good day
I am engaged in professional website development on
-OpenCart
-WP
-Laravel
Also creating Telegram bots
Applications
Professional SEO promotion, audits
I perform any work
… -Over 10 years of experience, there are many reviews and successful cases
-
3 days45 USD
656 9 0 3 days45 USD
Good day, Daria!
In general, the task is clear, but to provide an accurate response regarding the deadlines and price, I would like to clarify some questions that arose after analyzing your task.
Please write in private messages – we will discuss the details and your wishes.
-
2 days45 USD
1822 10 0 2 days45 USD
Good day, I have experience working with Telegram bots and Python, I can complete the task quickly and efficiently, write to discuss the details.
-
2 days45 USD
9927 117 0 2 days45 USD
Hello!
I am developing bots for Telegram using NodeJS. I have experience with Google Sheets. I am ready to take on the project. Write to me, we will discuss.
-
3 days67 USD
1945 7 0 3 days67 USD
Hello! 👋 I see a task that fits your production perfectly: the bot reads reports from the “Filling” chat, recognizes the container/quantity, and safely enters the data into the “brew passport” in Google Sheets (without touching the HACCP formulas), plus the event log and service commands. Ready to do it.
What I will implement
• ✅ Message parser from the working group: “bottle 0.33 – 1458 pcs”, “defect/breakage”, etc.; support for multiple recording formats.
• ✅ Container recognition: bottle 0.33 / can 0.33 / 0.5 / kegs 25/27/30/50 l; mapping to the required cells of the sheets.
• ✅ Sheet selection (brew): via inline menu or from a keyword in the message.
• ✅ Formula protection: recording only in “Total (pcs)” and other “safe” columns.
• ✅ Event log: who sent, when, what was entered (log in a separate tab or CSV).
• ✅ Commands:
… • /export — brief summary of the day from all sheets in the chat,
• auto-warning if % loss > 4%.
• ✅ Instruction + video demo, code with comments, deployment (VPS/Render).
How it works (in simple words)
1. The operator writes a report in the “Filling” group.
2. The bot “reads” the text, finds the container/quantity/defect/breakage.
3. It determines the required brew (sheet) and enters only numbers into the correct cells, without changing the formulas.
4. Logs and, if necessary, warnings in the chat. Command /export — summary of the day.
-
2 days45 USD
2208 18 3 2 days45 USD
Good day, Daria. I am engaged in the development and configuration of Telegram bots, automation in Python. I have experience in developing similar bots for collecting and generating statistics in production. I can develop a bot for you with the necessary functionality, stack: python, aiogram, gspread & gspread-oauth. I will provide all instructions for setup and usage, and if needed, I will set it up and install it on VPS for you for free. If you are interested - write to me, I will gladly discuss all the details and help you.
-
7 days446 USD
97052 1277 1 10 7 days446 USD
Hello. I have extensive experience in developing Telegram bots. I am ready to collaborate.
-
4 days45 USD
201 1 1 4 days45 USD
Good day, I have created similar bots that monitor chats and keep logs, I am ready to take your order, we can discuss the details in private messages.
-
3 days67 USD
1600 8 0 3 days67 USD
Hello! I would be happy to complete this project for you. I just need to clarify some details.
I suggest discussing the details of the bot in private messages. I will create a convenient solution for you with a pleasant and understandable interface (layout, inline keys, menu). I have a few similar cases that I can share in private.
My portfolio
Freelancehunt
-
2 days45 USD
2937 73 4 2 2 days45 USD
Hello! I can create such a bot in Python!!!!!!!!!!!!!!!!
-
3 days45 USD
1100 8 1 3 days45 USD
Good day! I recently completed a similar project for a brewery involving the automation of fermentation reporting. I will create a Telegram bot in Python that will recognize messages about bottling and automatically fill in Google Sheets. I will use python-telegram-bot for chat interaction and gspread for working with spreadsheets, adding a loss check function and data export. The code will be structured with comments, and I will also provide a setup guide. I am ready to start working immediately after the order is confirmed.
Current freelance projects in the category Bot Development
Set up an AI bot in ManyChat for Instagram and Facebook MessengerSet up ManyChat Pro + OpenAI API (model gpt-4o-mini, but you can suggest something niche). Without Make/Zapier, if it can be implemented with ManyChat's internal tools, or with them if you justify the need.Bot operation logic:Triggered by any incoming message from a new client… AI & Machine Learning, Bot Development ∙ 13 hours 49 seconds back ∙ 23 proposals |
Telegram Bot + Send PulseI am looking for a freelancer who can help set up a Telegram bot for a simple mini course. Please send your portfolio along with the price. Thank you Bot Development ∙ 15 hours 3 minutes back ∙ 60 proposals |
Payment bot
223 USD
Connecting payment for a closed club in Telegram. It is necessary to set up a payment format where the user pays with a card from any country, and the channel author receives converted $ into their wallet. Additionally, reminders, automatic deductions, and automatic addition and… Bot Development ∙ 20 hours 4 minutes back ∙ 71 proposals |
It is necessary to develop a Telegram bot for monitoring cars from auctions in the USA (Copart, IAAI)A Telegram bot is needed for automatic searching and monitoring of "BUY IT NOW" cars at auctions in the USA (Copart, IAAI). The bot should operate automatically and send notifications about new cars that meet the specified filters.Main functionalityFilter settings: 1. Car… Data Parsing, Bot Development ∙ 2 days 17 hours back ∙ 93 proposals |
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 ∙ 3 days 7 hours back ∙ 93 proposals |
Dnepr