Not so long ago, I was writing about measuring Apps Script function performance, in particular those offered as part of the environment by Google. As add-ons get more complex and we rely more on other APIs that we have no control over, measuring how much we are making the user wait becomes important. Why poor man’s metrics? Because implementing them will cost nothing. But we are going to pay through hacks here and there to get a nice dashboard of metrics for our add-ons.

During the last few months, as I was implementing a few scripts on Google’s Apps Script, I needed to answer the question of what is the right place to store data. Factors to consider when storing data in typical Apps Script programs would be volume, persistence needs, access requirements and speed. A few APIs are available that provide these features, namely: PropertiesService CacheService These are key-value stores that serialize stored values to string (careful, one can be bitten by this).