Alert Collector

Use Alert Collector to receive notifications on your device when your data changes to a desired value on your google spreadsheet.

Your spreadsheets may have huge data and gets updated in real-time from various sources, however you may be interested in knowing some specific details instantly on your device from your spreadsheet when a value of some specific sheet/cell changes to a predefined value.

Assume you have a google spreadsheet(Example: "sheetId1") with a sheet (Example: "WatchList"), with two columns 1)Trigger column (Example: "C") 2)Remark column(Example: "D"),

and you have defined cell formula or scripts to update this sheet from a real-time data source (Example: Market price) which fills cell values to change trigger column(Column "C") value to "TRUE" and a corresponding remarks column (Column "D") to a desired text (Example: "Price of car1 is reduced by 2.5%").

In the above scenario, You can monitor the price of car1 from alert collector by creating an Alert source in the app with sheetid(Example:"sheetId1"), cells(Example: 'WatchList!C2:D100' (To monitor 2nd Row to 100th Row)), and "Collect every 15 mins" option. Now the app will start polling the sheet cells for every 15mins, when there is a trigger column with value "TRUE" you will receive a notification with remarks in the corresponding row (ex: "Price of car1 is reduced by 2.5%").

The app supports various features including,

1) Manage Alert Source

2) Export and import Alert source

3) Search alert source and alerts/logs/errors

4) Clear alerts/logs/errors instantly and through settings for automatic clearing of older alerts/logs/errors

5) Option to Sign-in and allow permission to access spreadsheet data as per alert source details

6) Option to Sign-out and disconnect permission to stop collecting the spreadsheet data

7) Settings to Turn off data collection completely or per alert source

8) Various data collection error handling and retry settings

9) Settings to exclude one or more days of a week from data collection per alert source

10) Settings to define start and end date/time for data collection per alert source

11) Support to exclude data collection for a specific time duration of a day