Better Sheets

PropertiesService

What it does

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

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

No tagged tutorials yet. Fetch Apps Script from the harvest table and this page fills automatically.