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