Apps Script Add-ons

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

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

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

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 …
Read More

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 …
Read More

Sheets API – Developer Metadata

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

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 …
Read More

Unpicking the Google Picker

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

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 …
Read More

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 …
Read More

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