Donate. I desperately need donations to survive due to my health

Get paid by answering surveys Click here

Click here to donate

Remote/Work from Home jobs

How to check the condition Telegram User Name with google spreadsheets Data?

Hai I am trying to compare joined telegram user from telegram group and google spreadsheet .

if user registered in telegram the google spreadsheed user field will show approved else NotApproved. how to check these thing using google script

I fetch the information from telegram group through telegram bot .

I want check this log data with google spreadsheet

This is my google script fetch the data from telegram

var token="xxxx"
var url="https://api.telegram.org/bot"+token ;
function getMe() {
  var response=UrlFetchApp.fetch(url +"/getMe");
  Logger.log(response.getContentText())

}
function getUpdates() {
  var response=UrlFetchApp.fetch(url +"/getUpdates");
  Logger.log(response.getContentText())

}

This my log data

[18-11-30 00:04:21:195 PST] {"ok":true,"result":[{"update_id":641687169,
"message":{"message_id":1,"from":{"id":528359603,"is_bot":false,"first_name":"John","last_name":"Robert","username":"BoxerRobert","language_code":"en"},"chat":{"id":528359603,"first_name":"John","last_name":"Robert","username":"BoxerRobert","type":"private"},"date":1543557145,"text":"/start","entities":[{"offset":0,"length":6,"type":"bot_command"}]}},{"update_id":641687170,
"message":{"message_id":2,"from":{"id":528359603,"is_bot":false,"first_name":"John","last_name":"Robert","username":"BoxerRobert","language_code":"en"},"chat":{"id":528359603,"first_name":"John","last_name":"Robert","username":"BoxerRobert","type":"private"},"date":1543557186,"text":"Hello!"}},{"update_id":641687171,
"message":{"message_id":3,"from":{"id":528359603,"is_bot":false,"first_name":"John","last_name":"Robert","username":"BoxerRobert","language_code":"en"},"chat":{"id":528359603,"first_name":"John","last_name":"Robert","username":"BoxerRobert","type":"private"},"date":1543557197,"text":"I 'm BoxerRobert"}}]}

I want output like this BoxerRobert joined telegram group also so that's way it show approved mk not joined telegram group so still not approved .

enter image description here

Comments