PropertiesService

What it does

Store script, user, or document key-value settings that persist between runs.

Methods used

Related snippets

Official Google docs

Explore

.getScriptProperties()
Returns key-value storage shared by everyone using the script.
.getUserProperties()
Returns key-value storage private to the current user.
.getDocumentProperties()
Returns key-value storage tied to the current spreadsheet or doc.
.setProperties()
Saves multiple key-value pairs at once.
.setProperty()
Saves a single key-value pair.

Better Sheets tutorials

I built a clone of Cookie Clicker, live on YouTube. Watch the full 1 hou...

Advanced

Design walkthrough of VisiCalc 2023. Watch this if you'd like to see the...

Intermediate

This is a fun template I created for April 1st. Take a quick walk throug...

Beginner

SUM()