How to create automatic filling of google spreadsheet cells using telegram bot?

Question

Python

I work as an engineer in the mechanical engineering field. In the fabrication shop where I work, there are difficulties with daily reporting of parts produced and parts transferred to other departments.
Is it possible through the bot to make several buttons in which the commands "manufactured parts", "transferred parts" will be displayed Code of manufactured parts, quantity. and after entering the code, the quantity should go to google sheets where you can see the status of production, transfer of parts.
Please help me how to implement what exactly to pay attention to, if there are video tutorials close to this topic, I will be very grateful

Answer 1

yes, everything can be
decomposed
1) bot
2) bot to nowhere
3) bot to server
4) server to table
5) bot - server - table
and do it

Answer 2

Write more precisely formulated terms of reference, there is a desire to help.

Answer 3

Google Scripts - you can make a bot that will support Google Spreadsheets out of
the box