title: input data from telegram bot in google sheet
body: <p>I wanna use spreadsheet via telgeram bot as TODO list in order to when input something in my phone that should be save in spreadsheet.(im coding just like this <a href="https://www.youtube.com/watch?v=XoTpdxbkGGk" rel="nofollow noreferrer">https://www.youtube.com/watch?v=XoTpdxbkGGk</a>
  everything is true and google sheet , telegram bot are truly fectched but i dont know why when i input data in telegram bot this isnt save anything in google sheet.</p>
  
  <p>please help me guys</p>
  
  <pre><code>var token="&lt;&lt;BOT-TOKEN&gt;&gt;";
  var url="https://api.telegram.org/bot" + token ;
  var webAppUrl="https://script.google.com/macros/s/&lt;&lt;secret&gt;&gt;/exec";
  var spId='&lt;&lt;secret&gt;&gt;';
  function getme() {
    var response=UrlFetchApp.fetch(url + "/getme");
    Logger.log(response.getContentText());
  }
  function getupdates() {
    var response=UrlFetchApp.fetch(url + "/getupdates");
    Logger.log(response.getContentText());
  } 
  
  function setwebhook() {
    var response=UrlFetchApp.fetch(url + "/setWebhook?url=" + webAppUrl);
    Logger.log(response.getContentText());
  }
  
  function setwebhook() {
    var response=UrlFetchApp.fetch(url + "/sendMessage?chat_id=" + id + "&amp;text" + text);
    Logger.log(response.getContentText());
  }
  
  function doGet(m){ 
    return HtmlService.createHtmlOutput("Heloo" + JSON.stringify(m));
  }
  function doPost(m){
      var contents = JSON.parse(m.PostData.contents);
  GmailApp.sendEmail(Session.getEffectiveUser().getEmail(),"Telegram Bot Update",JSON.stringify(contents,null,4));
    var text = contents.message.text;
    var id = contents.message.from.id;
    var name = contents.message.from.first_name + ' ' + contents.message.from.last_name;
    sendText(id, "HI" + name);
  SpreadsheetApp.openById(spId).appendRow([new Date(),id,text,contents,name]);
    SpreadsheetApp.openById(spId).appendRow([1,2,3,4,5]);
  }
  /*
  {  
      "parameter": {},
      "contextPath": "",
      "contentLength": 310,
      "queryString": "",
      "parameters": {},
      "postData": {
          "type": "application/json",
          "length": 310,
          "contents": "{\"update_id\":*,\n\"message\":{\"message_id\":12,\"from\":{\"id\":*,\"is_bot\":false,\"first_name\":\"*\\*\",\"username\":\"*\",\"language_code\":\"fa\"},\"chat\":{\"id\":*,\"first_name\":\"*\\*\",\"username\":\"*\",\"type\":\"private\"},\"date\":1558331571,\"text\":\"salaaaaaaaaaaaaam\"}}",
          "name": "postData"
  
  }
  */
  </code></pre>
  
  <p>expect this save everything that typed by telegram bot and save the data in google sheet rows.but it dosent save data or show them in sheet cells.it shows nothing</p>