This sheet Notification Add-on can trigger the mail if any of the mentioned range values met, so basically it keeps an eye on the sheet every time in background. Just create Checkpoint, set some condition that range A1 should equals "Value" and set the notification and just relax whenever condition got met we'll get the notification. So perfect. It also works many users working on same sheet, means other users if have access can also view and modify the checkpoint of others in the same sheet. Good support
Is this review helpful?
radio_button_uncheckedYes

Your review, profile name and photo will appear publicly in Google’s services. Your review must comply with the Google Workspace Marketplace Comment Guidelines and Review Policies. Learn More