A little bit of self-promotion: AutoOOO has been featured in the Google Workspace Developer Spotlight, a series of interviews that Google conducts with developers of innovative Workspace add-ons. You can watch the complete interview here:

It all started after I left a comment about AutoOOO on Chanel Greco’s blog, where she posted about using Apps Script to set the Gmail auto-responder message based on calendar availability – exactly the problem that AutoOOO aims to solve.

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.

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.