The PropertiesService
library is used to store and retrieve data that persists across script executions. You can manage properties at the script, user, or document level.
-
Set and Get a Script Property:
Store and retrieve a value that is global to the script. -
Set and Get a User Property:
Store and retrieve user-specific data. -
Set and Get a Document Property:
Store and retrieve data tied to a specific document. -
Delete a Property:
Remove a stored property. -
Log All Properties:
List all properties in a specific property store. -
Clear All Properties:
Delete all properties in a property store. -
Use Properties for API Keys:
Securely store API keys for external integrations.