---
title: "A comprehensive look at key value store options in Google Apps Script"
author: "Martin Hawksey"
date: 2024-05-28T19:53:55+00:00
canonical_url: https://pulse.appsscript.info/p/2024/05/a-comprehensive-look-at-key-value-store-options-in-google-apps-script/
markdown_url: https://pulse.appsscript.info/p/2024/05/a-comprehensive-look-at-key-value-store-options-in-google-apps-script.md
categories:
  - "Intermediate"
  - "Solutions"
tags:
  - "poehnelt.com"
featured_image: https://pulse.appsscript.info/files/2024/05/apps-script-key-value-stores.png
description: "Justin Poehnelt has shared a comprehensive look at key-value store options in Google Apps Script. Key-value stores are useful for storing data like user preferences or frequently accessed data, which can also be shared between script executions. As part of Justin's post as well as looking at the built-in store options, PropertiesService and CacheService, there is also a look at scenarios where you might want to consider alternatives like Firestore. The choice of key-value store depends on factors like expiration needs, number of items, value size, access control requirements, latency sensitivity, and cost considerations. Justin's post provides a thorough analysis of each factor, including latency comparisons. Head over to the source link to get all the details!"
---

# A comprehensive look at key value store options in Google Apps Script

![A comprehensive look at key value store options in Google Apps Script](https://pulse.appsscript.info/files/2024/05/apps-script-key-value-stores.png)

> [https://justin.poehnelt.com/posts/apps-script-key-value-stores/](https://justin.poehnelt.com/posts/apps-script-key-value-stores/)
> A comparison of key-value store options in Google Apps Script, including PropertiesService, CacheService, Firestore, and Sheet Developer Metadata.

Justin Poehnelt has shared a comprehensive look at key-value store options in Google Apps Script. Key-value stores are useful for storing data like user preferences or frequently accessed data, which can also be shared between script executions.

As part of Justin’s post as well as looking at the built-in store options, PropertiesService and CacheService, there is also a look at scenarios where you might want to consider alternatives like Firestore.

The choice of key-value store depends on factors like expiration needs, number of items, value size, access control requirements, latency sensitivity, and cost considerations. Justin’s post provides a thorough analysis of each factor, including latency comparisons.

Head over to the source link to get all the details!

Source: *[Key Value Store Options in Google Apps Script | Justin Poehnelt*](https://justin.poehnelt.com/posts/apps-script-key-value-stores/)

---

*Published by [Martin Hawksey](https://pulse.appsscript.info/p/author/admin/) on [Pulse](https://pulse.appsscript.info/). Original article: [https://pulse.appsscript.info/p/2024/05/a-comprehensive-look-at-key-value-store-options-in-google-apps-script/](https://pulse.appsscript.info/p/2024/05/a-comprehensive-look-at-key-value-store-options-in-google-apps-script/)*