Question Details

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


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("", options);


Profile picture


Are you sure? question.vm