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.

A lot of people live in their inbox. So, let's email when the cell changes this status column. We're going to go up to extensions, appscript.

Now you might think to do onedit here. This is a simple automation that basically anytime a cell is edited it's going to do whatever is in this function . But we're not going to use this because there's some issues with sending emails through this.

This event here gives us some really special information. We know what row we're in by event. range .get.

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.

Now in my particular case, I want it sent to the owner , which is me.

Let's do variable subject. Now, now here's a couple of things that I like to do in this particular case. I like to add the date.

We're getting the value of whatever row we're on in the third column. That is Oh, I can actually switch that around.

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.