No Picture
Add-ons

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 something I’ve wanted to get round to for a long time.  Apps Script libraries are […]

Add-ons

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 spreadsheets/sheets to create summary sheets, and optionally encrypting columns. The idea was to distribute the […]

No Picture
Add-ons

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 side add-on code. However, these have a limited time to live (1 hour), so what […]

No Picture
Add-ons

Handly helper for fiddler

If you use some of my libraries, you may have come across  the Fiddler class, which abstracts sheet data and provides a more functional way to manage data from multiple sheets in a Google Spreadsheet. […]

Add-ons

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 have the time or inclination to put them through the various verification processes and upcoming […]

No Picture
Add-ons

Running things in parallel using HTML service

Apps Script is inherently synchronous – you cant do lots of things at once. Primarily to get round the execution limit, I did a science project using triggers for parallel processing but the triggers are fairly unpredictable […]

No Picture
Add-ons

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 good for the add-on user, since they can go between your add-ons and immediately understand […]

No Picture
Add-ons

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 refuses to run. For example, if you have an add-on that includes an installable trigger, […]

No Picture
Add-ons

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 data changes from a client side Apps Script add-on. It boiled down to this   […]

No Picture
Add-ons

Unpicking the Google Picker

 When you first use the Google Picker with Apps Script it can be quite daunting to figure out how to do what, and in what order, especially as there a few error reported in the […]

No Picture
Add-ons

SlidesMerge add-on

Important note on my add-ons I’ve (reluctantly) decided to stop supporting all my Apps Script add-ons, as I no longer had the time or inclination to put them through the various verification processes and upcoming […]

No Picture
Add-ons

Using promises with apps script

Using promises rather than callbacks is a much cleaner way of dealing with asynchronous activities. Promises were introduced in EcmaScript 6, and of course are not implemented in Server side Apps Script. Since everything is […]

No Picture
Add-ons

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 use Stripe to manage payments. Using stripe means that you have to deal with things happening both server […]

No Picture
Add-ons

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 office). At first sight they look pretty much the same as Apps Script Add-ons – […]

No Picture
Add-ons

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 to bake your own simplified version. This isn’t an add-on yet (although I may get […]

Add-ons

Dicers

Dicers are a visual way of filtering rows on Sheets by selecting from lists of values that are present in selected columns.The Dicers add-on provides a simple and visual way of applying filters to data […]

No Picture
Add-ons

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 that are present in selected columns.The Dicers add-on provides a simple and visual way of […]

No Picture
Add-ons

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 use the developer tools in chrome on a running add-on, breakpoints don’t persist between sessions […]

No Picture
Add-ons

Chord Snip

Chord snip is an add-on for Google Sheets that creates a Chord diagram as you type, gives you the SVG code to embed it in a web site and the ability to embed it in […]

No Picture
Add-ons

Watching docs for changes

In Watching for server-side changes from the client html service, I showed how to watch for server-side positional or data changes from the client and be woken up when they happen. That post covered spreadsheets, but […]

No Picture
Add-ons

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 had the time or inclination to put them through the various verification processes and upcoming […]

No Picture
Add-ons

Apps Script Add-ons

Here is an index of Apps Script Add-Ons and useful add-on stuff that are distributed around this site Check the menu bar for more add-ons covered on other modules but also listed under this category […]