Every week I order meals for each employee in the organization. There is an excel table, where the columns correspond to the names of the employees of the organization. Lines are dishes. At the intersection of edinichki, meaning that a particular dish ordered a specific person.

When you come to warm up food you have to look for yourself in the table for a long time. I would like to immediately receive a sample of "Employee-food" in the telegram.

I myself have not much experience. While thinking about the concept. While the idea is such an excel table ==> json ==> google tables ==> bot requests to google table. You need to update the data once a day.

Tell me how easy it is to get data from an Excel table in a telegram

Closed due to the fact that the issue is too common for participants aleksandr barakin , AK ♦ , Viktorov , HamSter , Denis Bubnov 24 Dec '17 at 10:13 .

Please correct the question so that it describes the specific problem with sufficient detail to determine the appropriate answer. Do not ask a few questions at once. See “How to ask a good question?” For clarification. If the question can be reformulated according to the rules set out in the certificate , edit it .

  • In programming, one of the important things is to get rid of unnecessary steps, not to program / automate unnecessary. Try to explain why in your concept it is impossible to immediately lead a table in a Google table, but you need to make an Excel file locally -> something -> Google table. For me, these are extra steps. This may not be the case, but if it is, then you need to select the bot programming language and try to make queries to the Google tables. And your question needs to be closed as too general: you understand that the bot should already take data from the Google table, but do not specify a programming language. Too general. - AK ♦
  • I would not like to close because I will not get an answer. It is necessary to add. A programming language should be one with more examples of bots implementations. I guess this is javascript. It’s impossible to store data in the Google table right away, because this is not an organizational matter under my jurisdiction. I ask for help because Google did not give me answers to the question of how to get data from the Google tables into the bot. P.S. where to dig? What to watch? - Igor

0