![]() ![]() Var formattedDate = dateNow.getDate() + "/" + (dateNow.getMonth() + 1) Var sheet = SpreadsheetApp.openById(ssId).getSheetByName( "") UrlFetchApp.fetch( '' + token + '/', data) In addition to fetching the input from the users, I also wanted to store the searched word inside a Google Sheets spreadsheet. ![]() The translation capability is invoked with anslate(text, sourceLanguage, targetLanguage). Google Apps Script can be used to manipulate the Google Translate capability by calling the Language.App class. So I found a class that I could use in Apps Script to realize that. Although there are undoubtedly tons of mobile apps out there which do the same thing, I wanted to learn about it by using Telegram. One way to use the Telegram Bot and Google Cloud Services which came to mind was to create a translation bot. After receiving Telegram’s API key we can use it inside our Google Apps Script editor. The initial process of creating a Telegram bot is outlined on Telegram’s website. In this post I will share a bit on how to adapt Mars’s code and use Telegram Bot to get the input from the user and let Google Apps Script call Google’s cloud-based services (translation and finance) to later return the outputs to the user. The Telegram Bot I created from Mars’s code looks like this: Coincidentally, last year I learned a bit about how to use Google Apps Script with Telegram Bot as a personal ledger tool, as outlined in this post by Mars Escobin. In a previous post on this blog, Afif wrote about how to use Google Apps Script with Google Forms. ![]()
0 Comments
Leave a Reply. |