bellingcat/google-apps-script
1
0
Fork 0
mirror of https://github.com/bellingcat/google-apps-script.git synced 2026-06-07 19:08:37 +03:00
Code Issues Packages Projects Releases Wiki Activity
Files
main
google-apps-script/monitor-sheet
History
msramalho 16a8ce6a0f update readme
2023-01-11 12:34:11 +00:00
..
Monitor.gs
update readme
2023-01-11 12:34:11 +00:00
README.md
update readme
2023-01-11 12:34:11 +00:00

README.md

Goal

This script can be added to any sheet and then used in conjunction with the Timed executions + immediate email notification to have an alert in case the content of a sheet shows a given error message.

Features:

  • monitors a sheet for any string value
  • throws an error when a given string is found/not-found

How

Use the gsheets formulas to detect errors/bugs and write something like NOT_FOUND when an error occurs (see IFERROR method), then set up recurrent triggers and automated alerts for the sheet being monitored and you will get an email if something breaks in the sheet.