Email When Cell Changes
Learn how to set up email notifications in Google Sheets when a specific cell changes, enhancing your CRM's efficiency and keeping you updated without manual checks.
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.
So we're going to come to appscript and we're going to create a function here.
Essentially the actual automation of this is when we add a trigger and that'll come later.
Now as I told you we need to do one more step to get the trigger done.
We've set up our email notification in our CRM. You're watching Better Sheets here on YouTube.