Apps Script Add-ons - Desktop Liberation

Here is an index of Apps Script Add-Ons and useful add-on stuff that are distributed around this site

Add-on for decrypting columns in Google Sheets

In Merging sheets from multiple sources and encrypting selected columns I published some code for selectively copying columns from multiple input …
Read More

Chord Snip

Chord snip is an add-on for Google Sheets that creates a Chord diagram as you type, gives you the SVG …
Read More

Color Arranger

Important note on my add-ons I’ve (reluctantly) decided to stop supporting all my Apps Script add-ons, as I no longer …
Read More

Debugging Office JavaScript API add-ins

If you already write Apps Script add-ons, you’ll know that debugging can be a little challenging, and although you can …
Read More

Dicers

Dicers are a visual way of filtering rows on Sheets by selecting from lists of values that are present in …
Read More

Dicers Pro and advanced features

Now available on Add-ons store Dicers are a visual way of filtering rows on Sheets by selecting from lists of values …
Read More

Import, export and mix container bound and standalone Apps Script projects

This article covers how to pull scripts from multiple projects and import them into another project. You can even use …
Read More

Inline libraries in an Apps Script project

This piece of work to create inline libraries was both challenging and a lot of fun to produce, and it’s …
Read More

Measure round trip and execution time from add-ons

This isn’t an add-on yet (although I may get round to making it into one), but it can be used …
Read More

Merging sheets from multiple sources and encrypting selected columns

Sometimes you have a forest of spreadsheets each with multiple sheets, but you only want to share a selection of …
Read More

Merging slide templates with tabular data

This has been superseded by the add-on version – SlidesMerge add-on, but the below should still works too if you prefer …
Read More

Office Add-ins – first attempt

Office has the concept of an Add-in (previously these were called Apps for Office as well as the JavaScript API for …
Read More

Orchestrating competing google and Office framework loads

If you are porting an Apps Script add-on to an Office add-in, you may find you’ll be dealing with competing …
Read More

Plotting maps with overlays Sheets add-on starter

This isn’t a completed add-on but rather a proof of concept that may give you some hints on how to …
Read More

Polyfill for Apps Script properties service for the Office JavaScript API

In Google Apps Script there are 3 PropertiesServices. Document, User and Script. Office doesn’t have a direct equivalent, but we …
Read More

Promise implementation for Apps Script Stripe payments

In a recent Totally unscripted broadcast, Steve Webster provided a great introduction to monetizing add-ons, along with some sample code on how to …
Read More