We have a fairly basic CRM here and we want to have multiple people are editing the sheet. But as the owner of the sheet, I want to get email notifications when somebody changes the status column.

Now, this is really awesome little automation because basically if something changes in here, I want to be notified and I don't want to have to check this sheet.

So we're going to come to appscript and we're going to create a function here.

Now we want to say there are lots of things happening on this sheet. Maybe somebody updates a company name or a client name or even the deal value goes up.

So variable two, it's who is it to. Now in my particular case, I want it sent to the owner , which is me.

So, let's get variable date. And why I'm making this a variable is not just new date.

So let's get the status as well. status is going to be the D. Actually, this is going to be funny.

Now as I told you we need to do one more step to get the trigger done.

I want to do one more thing in our editor . I want to add one more thing to our email and that is sheet URL.

Better Sheets

Email When Cell Changes