How to create a Telegram Bot that interacts with a spreadsheet (Part 2 of 3)

[@aimankhalid153]

return sendMessage(id,budget); doesnt return anything on my telegram, but i dont have any problem with function sendMessage before on your previous tutorial. any tips to solve the issue?

[@idobenezri2248]

Amazing tutorial, helped me a lot! thanks.

[@arvideonet]

Hi. At first THANK YOU A LOT!, for these fantastic videos. Theyve been really helpfull I have a question, I hope you can help me: Is there, by any chance, a way yo retrieve the value of multiple cells instead of only one? i.e. when you type ‘budget’ instead only B1, it displays B1:B3

[@krisriley2206]

Thank you for the tutorial. I've added a similar bot to telegram and have a question. My bot returns the user i.d. in a google sheet but when I added the bot to a telegram group, it now returns an "undefined" parameter. Is there a fix? Bot returns user i.d. just find still in the bot itself, just not when added to a telegram group.

[@dabrandt12]

Parsing the json will be a little different if you're looking at private messages or a group. For example, the first one will pull the username from a group and the 2nd one will pull it from a private message to your bot contents.message.from.username; contents.message.chat.username;

[@veganchasers2213]

@@dabrandt12 hello, could you help me. I want to the bot to search my sheet for a name (name of players) and return their balance. How could I go about that.

[@BusinessBananaShikhe]

How can setup Help desk,help tickt, google sheet to Bot, talegram or whatapp

[@muhamadsahirradzi4000]

Hi...how i can do? so that , lot of user can use and without disturb the data that has already key-in , in one same Google Sheet

[@Erasmus12]

Hi, how can i get row with some rules? for example i wanna receive from the bot only the row with cell in column B that have text "To_Do" inside it

[@Erasmus12]

A sort of filter for the query

[@hightfly9300]

Have you find a way to do it? This is exactly what I'd like to do.

[@johandebruyn3533]

Hi How did you get the ssi?

[@adibabdullah]

Hi, i'm succesfull create the telegram bot. But i have an idea for Savings. If Savings is negative or less than certain amount, the return message will different like "be careful, your savings is negative". But i'm not able to find where and how i should change it

[@FarizAgati]

did u got the solution? try to tweak something around: sendMessage(id,"Added to your spreadsheet") My modification around this section will calling the "Savings" (or budget left), and it will be like: var sisaBudget = sheet.getDataRange().getCell(3, 2).getValue(); sendMessage(id,"Added to your spreadsheet. Your budget left is Rp "+ sisaBudget) what it means like it's not only showing "Added to your spreadsheet", but it also inform us our savings. ...maybe you can add "if condition" there.

[@ademumut4052]

hi, firstly, I very thank you for your videos. I want to ask a question. When I send an item and its price via bot, how can i learn which line it will be written? For example, I will send the message apple -5 and bot will send back me, your item has been written to C3 cell or C5 cell, i want to learn where it was written, could you please help me? ı also get this message. "Cannot read property 'postData' of undefined." function doPost(e) { var contents = JSON.parse(e.postData.contents); var id = contents.message.from.id; var text = contents.message.text; is there a problem here which i cant be able to see.

[@girishtony]

How to link a Google sheet data to teligram ? Suppose some one type his/her code then the bot display her details data from Google sheet

[@ahmadyusairimohdyusop7205]

Hi, How to get the spread sheet id?

[@alyaazwa4643]

hi i stuck start at 5.57. my spreasheet does not appear anything. can you help :(

[@marsescobin]

Hello! Make sure your webhook is working by rerunning set webhook function

[@ape00ng]

I have same issue. First make sure no typo even get the letter case exactly same. Second,happened to me, at var ssId, copy and paste the ssId and make sure NOT included "/edit#gid=0" at the end of the address. Hope this help.

[@nsmz8978]

@@ape00ng id tu, ambik dr mana ke mana?

[@nsmz8978]

kalau aku debug, dia tulis cannot read the property of postData line 17

[@FarizAgati]

@@nsmz8978 spreadsheets/d/*INI_ID_NYA*/edit

[@talibabbas4417]

This is amezing. However how can I get sender location. (Means from which lat long sender send a particular msg) plz reply.

[@sdpl-nka6854]

i liked your tutorial very much .inspired from you i want to create a telegram bot which fetch data from google sheet to telegram when user gives an input pls help

[@syafiqshahiri7653]

function sendMessage was error

[@syafiqshahiri7653]

var contents = JSON.parse(e.postData.contents); postData error. can you help me

[@ridzakalimanto]

I know I'm 2 years late for this, but did you solve it? I encountered the same problem