Sheet Notifications Support

Overview

This add-on sends notifications based on edits made to your Google Sheet™. The add-on monitors your Google Sheet™ for any edits. When a change is detected, it checks all your rules for any that conditions that evaluate to true. If the conditions specified in a rule evaluate to true then all the notification channels specified in your matched rule will be notified.

Setup Instructions

1. Open your Google Sheet™.
2. Go to "Extensions" -> "Add-ons" > "Get add-ons".
3. Search for "Sheet Notifications" and install it.
4. Grant the necessary permissions.
5. Open the add-on by going to "Extensions" and clicking on "Sheet Notifications" and then on "Open".

Creating a New Rule

When you click on 'Open' you'll see the below screen. Click on the "Create Rule" button to create a new rule.

That should bring you to the following screen where you need to specify the following details:

1. The name of the rule
2. The sheet the rule belongs to
3. The conditions that need to evaluate to true for notifications to be sent
4. Who to notify when the specified conditions are matched
5. Optionally, a custom message to send when the specified conditions evaluate to true

Once you specify the required details, click on 'Save Rule' to create the rule

Editing a Rule

To edit a rule, click on the rule you want to edit. This will bring you to the screen where you can edit the rule.

Once you're done making updates click on 'Edit rule' to edit the rule.

Deleting a Rule

To delete a rule, hover on the rule until you see a trash can icon on the top right of the rule. Then click on the trash can icon of the rule you want to delete. This will delete the rule and all its associated data.