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 .

Comments
Post a Comment