Create hyperlink in Telegram message sent by bot via script / google sheets

Question

My current script is:

function EnviarTelegram(botSecret, chatId, body) {
var response = UrlFetchApp.fetch("https://api.telegram.org/bot" + botSecret + "/sendMessage?text=" + encodeURIComponent(body) + "&chat_id=" + chatId + "&parse_mode=HTML");
}

The formula in Google Sheets I use to send the message is:

=EnviarTelegram("Code to Bot","Code to ChatId","Created Message")

I would like to be able to create the following message:

"Full list of games tomorrow

Click here to access"

In Click here to access I wish there was a hyperlink for example: www.google.com/testtesttesttest

Is there any way to be able to adjust the script or the text created for this?

question from:https://stackoverflow.com/questions/65947137/create-hyperlink-in-telegram-message-sent-by-bot-via-script-google-sheets

Answer 1

In your query parameter, parse_mode=HTML is used. So I thought that in this case, HTML tags can be used for text. When you want to use =EnviarTelegram("Code to Bot","Code to ChatId","Created Message"), how about the following modification?

From:

=EnviarTelegram("Code to Bot","Code to ChatId","Created Message")

To:

=EnviarTelegram("Code to Bot","Code to ChatId","Full list of games tomorrow

<a href='https://www.google.com/testtesttesttest'>Click here to access</a>")