so basically the task is quite simple, but I didn't find any workable solution for my problem. I have a huge upload script on my website (at the moment localhost), but lets reduce all the complexity to the only neccessary.…
I'm trying some Google Apps Script script for telegram bot API. var token = "BOT:TOKEN"; var telegramUrl = "https://api.telegram.org/bot" + token; var chat_id = "CHAT_ID"; var image1 = "https://telegram.org/img/t_logo.png"; var image2 = "https://www.gstatic.com/images/branding/product/2x/apps_script_48dp.png"; var data = { method: "post", payload:…
I'm new to using Google Scripts and am trying to make a connection to a MySQL (5.5.65-MariaDB) database which is hosted on an external (non-Google) server running CentOS Linux 7.7.1908 Core. I'm following the guide here: https://developers.google.com/apps-script/guides/jdbc#other_databases In my script…
How to check if the value is exist in google spreadsheet or not using apps script I want to check if the Sam exist in the entire spreadsheet or not using apps script. If exist I want to perform task...…
I am developing a Google web app JavaScript application to communicate to a Telegram bot. Telegram users type certain words or click buttons appearing on Telegram group via the usage of InlineKeyboardMarkup (InlineKeyboardButton); I have implemented a Telegram Bot state…
0stone0: fixed the problem; thank you, thank you + thank you; ADW: thank you for illustrating keyboard object, adopted; Google web app based on JavaScript to send JSON objects to a Telegram bot; implementing Telegram based menu using buttons, in…
So I wrote this code and it is not working as it should, it is pulling data from woocommerce Webhook with a "code.gs" code in GoogleSheets. Problem is, if var product_name = myData.line_items[1].name; (and [2], [3] and [4].... and others)…
I have: A google sheet which is automatically receiving new shopify orders through zapier The orders are inserted as new rows, at least have been so far, but I do not know whether they may update be edited in the…
I am developing a Telegram bot and need to ascertain who are the admins in a group Have developed a Google Web App using JavaScript and calling the following method getChatAdministrators Use this method to get a list of administrators…
I'm so new with GAS and trying to write a Telegram bot with text commands and keyboard but it didn't give me the result when I pressed keyboard. (text commands work). What did I do wrong? Thanks for reading and…