Advertisement
Namokonov

Untitled

Jun 7th, 2022
1,440
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. const botToken = '11744...';
  2. const chatIds = ['320117024'];
  3. var msg = 'привет, привет!';
  4.  
  5. function send(e) {
  6.   const range = e.range;
  7.   const sheet = e.source.getActiveSheet();
  8.   const value = e.value;
  9.   const old_value = e.oldValue || '';
  10.  
  11.   if (value && range.getColumn() == 2 && sheet.getName() == 'Лист1') {
  12.     msg += `\nзначение: ${value}\nстарое значение: ${old_value}`;
  13.     chatIds.forEach(chatId => {
  14.       UrlFetchApp.fetch(`https://api.telegram.org/bot${botToken}/sendMessage?chat_id=${chatId}&text=${encodeURI(msg)}`)
  15.     });
  16.   }
  17. }
  18.  
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement