RR
function Perehvat(e) {
if(e.range.getColumn()==2){
var ChatId =String(e.range.offset(0,1).getValue());
var payload = {'method': 'sendMessage','chat_id': ChatId,'text': 'Hi, I\'m test','parse_mode': 'HTML'}
var data = {"method": "post","payload": payload}
var API_TOKEN = 'YOUR_TOKEN';
UrlFetchApp.fetch('https://api.telegram.org/bot' + API_TOKEN + '/', data);
}}спасибо!
