Skip to content

I need help in my apps script #50

@mbino94

Description

@mbino94

Hello,
I've been looking for a solution for since a week
I will explain it here hoping to get help

i made a script that interacts with telegram using Apps script and i have a spreadsheet which has a database...
3 columns 500 rows

ID , Username, Full Name

i want to make a command for tg bot like when i send /who "ID NUMBER" it looks up in the spreadsheet in first columns for that specific ID NUMBER and sends back the Full name of it

here is my apps script

var ssId = "16Rw-ilDTdozSHOn73I0fhXeaTJuixyQOp7BDDXfY9Cs";

function setWebhook() {
var url = telegramUrl + "/setWebhook?url=" + webAppUrl;
var response = UrlFetchApp.fetch(url);
}

function sendMessage(id, text,) {
var url = telegramUrl + "/sendMessage?chat_id=" + id + "&text=" + text;
var response = UrlFetchApp.fetch(url);
}
function doPost(s) {

var contents = JSON.parse(s.postData.contents);
var id = contents.message.from.id; // user ID
var name = contents.message.from.first_name; // Sender First name
var uname = contents.message.from.username; // Sender Username
var text = contents.message.text; // Message Text

if (text.includes("/who")) {

var result = text.substr(text.indexOf(" ") + 1);; // this line removes the first word from the Message`

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions