Magic Cell Notifications
Use this add-on to setup email notifications on a Google Sheet when specific cells reach set values.
This add-on will load a sidebar menu for you and you can then begin to set up notification rules on your Google Sheet. You can add as many rules as you like and the add-on will keep a track of them on a worksheet called ‘Notification Rules’. You can view this worksheet and even amend the rules directly on the sheet.
Once the spreadsheet is changed and the values reach the notification rules you have set you will automatically receive an email to inform you. You can also add multiple email addresses to one notification rule simply by separating them by a comma.
All of these add-ons are produced and maintained by Not so Magic Apps