Google App Script to trigger email -

Google App Script to trigger email -

i'm trying email fire alerting me if column in google sheet =x.

i've tried using notification scheme using using eq operator turn on when cell equals x, changes cell , notification scheme supposed send email right away. it's not working way, email never fires.

i'm think need script fire email if cell =x nice because customize email made more sense. (i.e. "the conference room event beingness held has reached capacity, should remove reservation form")

i new google scripts , utilize little help creating email trigger if cell =x script.

thanks,

dave

you need add together script run onedit.

function onedit() { var sheet = spreadsheetapp.getactivespreadsheet().getsheetbyname("nameofyoursheet"); var currentvalue = sheet.getrange("a5").getvalue(); if (currentvalue == (whatevervalueyourelookingfor)) { mailapp.sendemail("youremail@domain.com", "alert: cell in sheet equal x!", "the message body want send."); } }

email triggers google-apps-script