Tracking activity with ScriptDB

Note that scriptDB has been deprecated. I leave this article here for interest.
In Using scriptDB, I covered some usages of scriptDB,along with a method of siloing data to keep it organized. Since scriptDb gives the possibility of shared persistent storage here’s a usage that might be useful for tracking things.

ScriptDB for tracking

In Apps Script timer collection i covered how to measure how long certain activities took, but that was mainly for performance tuning. If you want to track activities, then you need some kind of persistent storage accessible from multiple places.  You could for example, track who is opening what workbook.


Using the idea of siloing the scriptDB, we can set aside a slice of it to track  when certain events start and finish using Google Apps Script. Here’s an example of logging a couple of events, and how long it took.