Question Details

Unanswered
Need a Google App Script to edit event when a specific cell is changed in Google Spread Sheet and then send message to Line Notify

Hi,

Is to possible to get a script that can do the following:

When column 14 is changed(=Reminder)

Reason why I need a script is that column will be sent to line notify. Thxs

function onEdit(e) { if (e.range.getColumn() === 14) { ** MailApp.sendEmail('your email address', 'you have a change in column 14', 'click here to open')** <---How to correct this

} sendLineNotify(msg); } } function sendLineNotify(message) {

var token = ["token ID"]; 
var options = {
    "method": "post",
    "payload": "message=Reminder" ,
    "headers": {
        "Authorization": "Bearer " + token
    }
};

UrlFetchApp.fetch("https://notify-api.line.me/api/notify", options);

}

0
Profile picture
^^SUB^^

Answers

0
Are you sure? question.vm