Read & write multiple User Properties

The following Google Apps Script is a few snippets of some larger code where I needed to write (and then later read back) a number of User Properties in one go. Rather than creating multiple single write requests it is more efficient to do this in bulk.

I also needed a way to bulk read/extract these values later from a JavaScript Object that would allow me to easily call the Property name and get its value in return.

Access User Properties and get the values in an Object

The Code

Putting a number of key:value pairs into User Properties is simple enough via the 'setProperties(properties)' method:

var userProperties = PropertiesService.getUserProperties();
var newProperties = {
   sourceFolderId: '123',
   destinationFolderId: '456',
};
userProperties.setProperties(newProperties);

With regards to getting them back out we can simply reference them directly from the Object:

// log each item from User Properties
Logger.log(userProperties.destinationFolderId);
Logger.log(userProperties.sourceFolderId);

 

Download

Read & write multiple User Properties download (please use 'Overview' > 'Make a copy' for your own version).