I wrote an bot on GAS to read from / write to a google sheet from telegram. I use the webhook method. I can address the bot with /read <args> and /write <args>. However, the less tech-savvy are not able…
I'm trying to make a simple app to update prices in WooCommerce through the REST API. I have arrayOne which has SKU + updated prices from my ERP [ {sku=PD-1000-B, price=9800.00}, {sku=PD-1007-A, price=9678.16} ] arrayTwo which has all products from…
I'm actually using this working code and setting a trigger to repeat the task every 4 hours, but I would like to short the code checking every row, let's say look for non empty rows in the range 'A1:A20'. What…
I'm trying sent images chart from Google Sheets to Telegram. I'm saving image chart to Google Disk and then send it to Telegram chat (helping this my telegram bot). If I send Google Drive link to telegram in that way:…
I have a script that creates the client's folder, subfolders, and sheets in the drive whenever I add a new client to the sheet through HTML form. I am looking for a way to add the link in column K…
Project_1 is a container-bound script. A container is a readable spreadsheet (Template). Code_1: function doPost(e) { return HtmlService.createHtmlOutput(JSON.stringify(e)); } The user makes a copy of the Template, deploys the script (Project_1) as a webapp with permissions: "Execute as: Me, Who…
So I have a script, that sends msg to group chat, if in Column ( 2 ) in any cell's some one printed "Yanson" bot sends only fixed cell - .getRange(row,8). In my case this cell holds link to document.…
In order for me to download an image published on a Telegram channel, I need this path: var contents = JSON.parse(e.postData.contents); Logger.log(contents.channel_post.photo); And the answer is: [{ "file_id":"AAAAA", "file_size":11111, "width":253, "height":320 },{ "file_id":"BBBBB", "file_size":22222, "width":632, "height":800 },{ "file_id":"CCCCC", "file_size":44444, "width":1400,…
Twitter API: https://developer.twitter.com/en/docs/twitter-api/tweets/timelines/introduction In theory, when there is no data, it should leave the value as empty. As seen in this part of the script: if ( obj_data.data[int_i].entities.hasOwnProperty("urls") && Array.isArray(obj_data.data[int_i].entities.urls) && obj_data.data[int_i].entities.urls[0].expanded_url != undefined ) { array_Expanded_url.push([obj_data.data[int_i].entities.urls[0].expanded_url]); } else {…
How do I make my Google App Script wait for an answer in telegram bot and run my if statement afterwards? My idea of the code is: When I type /survey, it will run the following code which will post…