June 23, 2023
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).