This is extremely useful and powerful tool which allows to send alerts and notifications based on your business rules. For instance, if your can set up the alert and received notification if in your Income Statement the Expenses exceeds certain threshold.
In order to set up an alert you need to select from the menu Add-ons -> G-Accon for XERO (or G-Accon for QuickBooks) -> Automation -> Data Operations Scheduler and switch to “Alerts” tab.
In order to generate alerts the Auto Refresh radio button must be in “On” position in “Scheduler” tab.
“Worksheet” drop down select box will provide all google sheets in the current active spreadsheet.
“Range to analyze” – the range where the criteria must be met.
The above image reads the selected range and populates “Range to analyze” field.
The above image reads “Range to analyze” field and highlight the range in the selected sheet.
The possible values in “Where” field are:
- equals, not equals and contains can be used only with string criteria. Example: Paid, Awaiting Payment, etc
- =, !=, <, > can be used with numeric, currency and date values. Example: 1,063.56, etc
“Enter Alert Limit” field is an alert threshold.
The content of the “Alert Message” field is text that will be included into email body.
In order to create and permanently save alert, you need to click on the “Add Alert” button.
Currently G-Accon supports up to 10 alerts per spreadsheet.