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 ...

Chord Snip

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

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 ...

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 ...

Dicers

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

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 ...

DocAI – A Google WorkSpace Add-on for Sheets – interpreting the contents of ill-defined documents

...coming soon ...

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 ...

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 ...

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 ...

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 ...

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 ...

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 ...

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 ...

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 ...

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 ...

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 ...

Refreshing an oauth token in add-on

It's very convenient to use ScriptApp.getOAuthToken() in an addon to reuse the token from the server side in your client ...

Repeatable add-on settings layouts and style

If you have a few add-ons, it's good to make the Settings a consistent layout and behavior across them. It's ...

Sankey Snip

Important note on my add-ons I've (reluctantly) decided to stop supporting all my Apps Script add-ons, as I no longer ...

Sheets API – Developer Metadata

Why Sheets Developer Metadata ?With Sheets API developer metadata, you can associate keys and data with a spreadsheet, sheet, row ...

SlidesMerge add-on

Important note on my add-onsI've (reluctantly) decided to stop supporting all my Apps Script add-ons, as I no longer had ...

Unpicking the Google Picker

When you first use the Google Picker with Apps Script it can be quite daunting to figure out how to ...

Watching for changes in an Office add-in

In Watching for server side changes from the client html service I showed a method of noticing and reacting to server side ...

When test add-ons doesn’t work

Those of you that write add-ons will know how to test them before deployment using but sometimes this ...

Check the menu bar for more add-ons covered on other modules but also listed under this category for you convenience