Google Sheets: number subscriptions

1. Once you have selected a Google Sheet as a resource (learn here how), you can create 3 types of subscriptions depending in the range of cells you select in «Sheet Rules».

2. In «Range» you must select the range of cells you want to receive notifications about, following the A1 Notation, as shown in the picture below.

3. If the range of cells you select have «number» format, certain options will appear in «select an operator» . Optionally, you can apply an aggregation function to your range of cells (calculate sum, average, maximum or minimum of the range). Regarding the configuration I created in the picture below, I will only be notified when the average number of all the values in that range of cells is grater than 300.

Configuration of google sheets regarding number cells