APIS and techniques
Gassypedia – public Google Apps Script on Github
All the Google Apps Script related github activity is now on Google Bigquery and Google Looker. Here’s how it was done. […]
Apps Script
Apps Script
Color scales, custom schemes and proxies with Apps Script
How to add Google Material Colors and your own custom schemes to chroma […]
Apps Script
Proxy magic with Google Apps Script
I’ve written a few articles on here about JavaScript proxy and reflect. I use both extensively not only in Node projects but also in Apps Script. In this article I’ll demonstrate how to extend built-in […]
Apps Script
Find nearest matches in color schemes with Apps Script
Here’s another article on playing around with color in Apps Script. Let’s say you have a defined list of colors in a scheme (for example paint or textile colors or perhaps a predefined scheme like […]
API Specific
Detect fake news with Google Fact Check tools
I came across Google’s FactCheckTools API today, so I thought it might be fun to add to my bmApiCentral Apps Script library. This API can be used to both search popular fake news claims and […]
API Specific
Convert any file with Apps Script
Apps Script library to convert between file types, including OCR for image to documents, with a huge repertoire of conversion combinations. […]
Add-ons
Colorize sentiment in a Google document
Anaylze and colorize the sentiment of inidivual sentences in Google using Documents Google Language API […]
Apps Script
Content oriented color mixing with Apps Script
Apps Script library to derive colors and color mixtures based on text to help contextualize sheets content. […]
Apps Script
Obfuscate text with Apps Script
Sometimes you want to hide data in a sheet that’s being used for demo purposes.Here’s some options and library to help you do it. […]
Apps Script
Markup HTML from JSON with Apps Script and JavaScript
Apps Script/JavaScript library to generate prettified HTML Markup from JSON […]
Apps Script
Create GraphML markups from Apps Script
A recent social network analysis project meant I had to find a way to convert Google Form data for visualization in NodeXL. Normally I’d use D3 for this kind of thing (you’ll find plenty of […]
Apps Script
Calculate contrasting font colors for Sheets.
If you are playing around with Sheet colors with Apps Script, you sometimes find yourself with font colors that don’t go well with the background colors you’ve chosen. However, we can use Yiq values to […]
Apps Script
Use a proxy to catch invalid property access
Accidentally accessing non-existent properties and tracking down where that is happening is a big time waster that a JavaScript proxy can help you track down. In Fix Apps Script file order problems with Exports I […]
Apps Script
Apps Script
SuperFetch Plugin: Cloud Manager Secrets and Apps Script
Smg is a SuperFetch plugin to access the Google Cloud Secrets API. SuperFetch is a proxy for UrlFetchApp with additional features – see SuperFetch – a proxy enhancement to Apps Script UrlFetch for how it […]
Apps Script
SuperFetch caching: How does it work?
SuperFetch is a proxy for UrlFetchApp with additional features such as built-in caching – see SuperFetch – a proxy enhancement to Apps Script UrlFetch for how it works and what it does. This is another […]
Apps Script
SuperFetch plugins: Tank events and appending
Tank and Drv are SuperFetch plugins to emulate streaming and use the Drive REST API with Apps Script. SuperFetch is a proxy for UrlFetchApp with additional features – see SuperFetch – a proxy enhancement to Apps […]
Apps Script
SuperFetch Plugins: Apps Script streaming with Tank and Drive
Tank and Drv are SuperFetch plugins to emulate streaming and use the Drive REST API with Apps Script. SuperFetch is a proxy for UrlFetchApp with additional features – see SuperFetch – a proxy enhancement to […]
Apps Script
SuperFetch Tank Plugin: Streaming for Apps Script
Tank is a SuperFetch plugin to emulate streaming with Apps Script. SuperFetch is a proxy for UrlFetchApp with additional features – see SuperFetch – a proxy enhancement to Apps Script UrlFetch for how it works […]
API Specific
SuperFetch plugin – Google Drive client for Apps Script – Part 1
Drv is a SuperFetch plugin to access the Google Drive API. SuperFetch is a proxy for UrlFetchApp with additional features – see SuperFetch – a proxy enhancement to Apps Script UrlFetch for how it works […]
API Specific
SuperFetch – Twitter plugin for Apps Script – Get Follows, Mutes and blocks
Twt is a SuperFetch plugin to easily access to the Twitter v2 API. SuperFetch is a proxy for UrlFetchApp with additional features – see SuperFetch – a proxy enhancement to Apps Script UrlFetch for how […]
Apps Script
SuperFetch plugin – Twitter client for Apps Script – Counts
Twt is a SuperFetch plugin to easily access to the Twitter v2 API. SuperFetch is a proxy for UrlFetchApp with additional features – see SuperFetch – a proxy enhancement to Apps Script UrlFetch for how […]
Apps Script
OAuth2 and Twitter API – App only flow for Apps Script
I covered how to handle the somewhat more complex OAUTH2 authorization flow for the Twitter v2 API (OAuth 2.0 Authorization Code Flow with PKCE) using my Goa library in this article. The purpose of that […]
Apps Script
SuperFetch plugin – Twitter client for Apps Script – Search and Get
Twt is a SuperFetch plugin to easily access to the Twitter v2 API. SuperFetch is a proxy for UrlFetchApp with additional features – see SuperFetch – a proxy enhancement to Apps Script UrlFetch for how […]
Add-ons
Apps Script Oauth2 – a Goa Library refresher
It’s been a few years since I first created the Goa library. Initially it was mainly to provide OAuth2 authorization and authentication to be able to access Google APIS and services unavailable via App Script. […]
Apps Script
SuperFetch plugin – Firebase client for Apps Script
Frb is a SuperFetch plugin to easily access a Firebase Real time database. SuperFetch is a proxy for UrlFetchApp with additional features – see SuperFetch – a proxy enhancement to Apps Script UrlFetch for how it […]
Apps Script
SuperFetch plugin – iam – how to authenticate to Cloud Run from Apps Script
SuperFetch is a proxy for UrlFetchApp with additional features – see SuperFetch – a proxy enhancement to Apps Script UrlFetch for how it works and what it does. In this article I’ll cover how to use […]
Apps Script
SuperFetch – a proxy enhancement to Apps Script UrlFetch
I’ve written a few articles about JavaScript proxying on here, and I’m a big fan. I also use a lot of APIS, and it can be time consuming to keep on checking the REST documentation […]
Apps Script
Using Firebase and Apps Script to link Google Forms reponses
There’s a really basic thing missing from Google Forms. What’s missing ? A way of stamping responses with some sort of code to be able to link them back to some user or some other […]
Add-ons
Opportunities and workflows inlining Apps Script libraries
This article will look at some of the opportunities you’ll have when you pull in your libraries inline rather than leaving them as references to external files. It’s a follow on from the articles on […]
Apps Script
Pulling in Apps Script libraries – how is it done
This is a follow on from the article on Pull libraries inline to your Apps Script project (which you should probably read fiest) to explain a little about how it works. The Script API It uses […]
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
12 Years and 1000 pages in Office,Google (Docs,Gsuite) Workspace, and other stuff
1000 pages and counting Most years I do a post on ‘a year in Apps Script’, looking back over the changes in the platform over the preceding year. As many of you will probably know, […]
Add-ons
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 this to make container bound script standalone, or visa versa. My initial motivation for this […]
Apps Script
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 those sheets. You could cut and paste, but that’s error prone and difficult to repeat. […]
Apps Script
Fiddler now supports joins to merge matching columns from multiple sheets
You may have come across my post on SQL for Apps Script it’s here where I shared a library for using SQL syntax in Apps Script to do things like joining tables. For some cases, this […]
Apps Script
Super simple cipher library for Apps Script encryption and decryption
Encryption and decryption can be a bit cheesy to come to grips with. The most common library is probably cryptojs which has endless options. Since most people simply want to encrypt some data and decrypt […]
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 […]
Apps Script
Apps Script server side to client side htmlservice progress reporting using CacheService
I’ve published a few examples of this in other projects (for example Implementing a client side progress bar reporting on server side work for htmlService) but I got a request from someone on LinkedIn to […]
Apps Script
Data Studio connector for scrviz – finally connecting it up
This series of articles will work through how to create a connector for Data Studio in Apps Script. For an introduction into the structure I’ll be following see Creating a connector for Data Studio and for a […]
Apps Script
Coding a connector for Data Studio (without using data studio)
This series of articles will work through how to create a connector for Data Studio in Apps Script. For an introduction into the structure I’ll be following see Creating a connector for Data Studio This article […]
Apps Script
Creating a connector for Data Studio
This series of articles will work through how to create a connector for Data Studio in Apps Script. The source data will be the github apps script project catalog from Every Google Apps Script project on […]
Apps Script
Finding the scriptId from Apps Script projects on github
In Every Google Apps Script project on Github visualized I demonstrated an app that could be used to explore what every Apps Script developer who has shared their code is working on. One of the features […]
Apps Script
A fourth way to preserve and create formulas with Fiddler for Sheets, plus some more new methods
This is (probably) the last in a series of posts describing how Fiddler for Sheets can be used to help with formula manipulation and creation, as well as column insertion and deletion without caring too […]
Apps Script
Proxy implementation of Apps Script GraphQL Class
In Resuscitating the Apps Script execution transcript – JavaScript Proxy and Reflect to the rescue I showed how we could use the ES6 Proxy global object to intercept calls to Apps Script services so we could […]
Apps Script
2 ways to create and preserve formulas with fiddler for Google Apps Script
I’ve had a few queries from fiddler users about how to deal with formulas. Fiddler is primarly for abstracting spreadsheet values so they can be manipulated and updated without worrying too much about the physical […]
API Specific
Currency exchange rates library for Apps Script – optimized for the parsimonious – swop.cx
There are quite a few exchange rate APIs out there to get the latest and historic exchange rates. Google used to have a nice, simple and free one – the finance API, but that was […]
Apps Script
Sheets Workbook functions in Apps Script – Filter functions
This article will cover the translation of the Sheets workbook filter type functions for Apps Script. All of them will be covered. Motivation If you are handling data from sheets it might be useful to […]
Apps Script
Resuscitating the Apps Script execution transcript – JavaScript Proxy and Reflect to the rescue
If you’ve been using Apps Script for a while, since back when it was running on the Rhino JavaScript emulator; see (What JavaScript engine is Apps Script running on?), you’ll remember the Execution Transcript. This […]
Apps Script
ES6 Symbols – what on earth is all that about ?
javaWhen I first read about Symbols coming to JavaScript, I couldn’t figure out what the point was or even what they were, so I just kind of parked it. Lately I’ve been doing some work […]
Apps Script
Sheets Workbook functions in Apps Script – Database functions
This article will cover the translation of the Sheets workbook database type functions for Apps Script. All of them will be covered. Motivation If you are handling data from sheets it might be useful to […]
Apps Script
Sheets Workbook functions in Apps Script – Array functions
This article will cover the translation of the Sheets workbook Array type functions for Apps Script. Most of them will be covered, except for a few exotic ones that I might do later if anybody […]
Apps Script
Getting ‘a pile of files’ from Google Drive with Apps Script
The method for doing this is actually part of the bmFolderFun library documented in A handier way of accessing Google Drive folders and files from Apps Script but it can be really useful for keeping […]
Apps Script
Supercharging copying files between Drive and Cloud Storage from Apps Script with Cloud Run
In Blistering fast file streaming between Drive and Cloud Storage using Cloud Run I showed how you could use Cloud Run to hand off transfers between Drive and Cloud Storage to make them faster and […]
Apps Script
A handier way of accessing Google Drive folders and files from Apps Script
The usual way to access files and folders on Drive from Apps Script is via their ID, yet on other platforms we’re more used to using file and folder paths. This can be a bit […]
Apps Script
Blistering fast file streaming between Drive and Cloud Storage using Cloud Run
A friend of mine hit an Apps Script problem the other day when transferring large amounts of data between Drive and Cloud Storage. We’ve all had the mysterious ‘unexpected Javacript runtime error’ from the IDE […]
Apps Script
Apps Script V8: Sorting out the call stack to figure out who called
Let’s say you need to find out how your function was called, either for in app debugging or some other purpose. A JavaScript Error has a non standard property (stack) that contains some info about […]
Apps Script
JavaScript snippet to create a default method for an object
Today’s snippet is going to be shorter than usual, because there’s a really easy solution. Many objects have a default method like toString(). You may want to add one of those to your own functions […]
Apps Script
Sheets Workbook functions in Apps Script – Date and Time and Temporal primer
This article will cover the translation of the Sheets workbook functions for Date and Time manipulation to Apps Script. Virtually all of them will be covered, except for a few exotic ones that I might […]
Apps Script
Sheets Workbook functions – converted to Apps Script
One of the things missing from Apps Script compared to VBA, is the ability to run workbook functions, which you can do in VBA I’ve often thought about implementing the sheets functions from Apps Script, […]
Apps Script
Temporal – dates, times and timezones and the proposed new Date system for ECMAScript
The idea for Temporal came from a conversation about how poor the Date implementation of JavaScript is. Some history of that is in this blogpost, where Brendan Eich reveals he pretty much copied Java date […]
Apps Script
Random and fake test data in Sheets with Google Apps Script
Sometimes you need to generate some fake data for a spreadsheet. In this post I’ll cover a few utilities in 2 separate libraries that can help with this. Faker This is a node module to […]
Apps Script
Google Apps Script – What a difference 5 years make
I’ve been doing an annual update called ‘a year in Apps Script’ for a number of years now, but I didn’t get round to the 2021 post. This year I thought I’d do something different. […]
Analytics
Apps Script – How to track library and script usage
Motivation You’ve written a great Apps Script library and you want to know how many people are using it, and perhaps even which parts of the library they are using, and how often. Perhaps you […]
Apps Script
Sharing data between Apps Script and Node using Google Drive back end – 5 minute example
Another quick demo of data sharing Here’s a challenge that shares the data in a spreadsheet with node, set up end to end in less than 5 minutes. This example is almost exactly the same […]
Apps Script
The nodejs Drive API, service account impersonation and async iterators
This is part of the series on sharing data between Apps Script and Node on various backends, Apps script library with plugins for multiple backend cache platforms but the Drive API introduces a number of tricky […]
Apps Script
Sharing data between Apps Script and Node using Google Cloud Storage (GCS) back end – 5 minute example
Another quick demo of data sharing There are many ways to accomplish this of course, but using Caching across multiple Apps Script and Node projects using a selection of back end platforms is pretty fast to […]
Apps Script
Sharing data between Apps Script and Node using Github back end – 5 minute example
Quick demo of data sharing There are many ways to accomplish this of course, but using Caching across multiple Apps Script and Node projects using a selection of back end platforms is pretty fast to set […]
Apps Script
Sharing data with Upstash between Node and Apps Script – end to example in 5 minutes
Quick demo of data sharing There are many ways to accomplish this of course, but using Caching across multiple Apps Script and Node projects using a selection of back end platforms is pretty fast to set […]
Apps Script
Caching across multiple Apps Script and Node projects using a selection of back end platforms
Motivation I’ve always been interested in ways to get multiple projects in Apps Script sharing data more easily and in a more standard way, independently of whatever platform is being used to host the data […]
Apps Script
Github as an Apps Script cache platform
Github as an Apps Script cache platform Another plugin available for Apps script library with plugins for multiple backend cache platforms so we can use Github as a back end for caching large objects across […]
Apps Script
Upstash as an Apps Script cache platform
Upstash as an Apps Script cache platform Upstash is a brand new service offering a serverless redis over https via a GraphQL API. Previously redis was hard to use along with Apps Script since we […]
Apps Script
3 Favourite things in one article – redis, apps script and graphQl
Apps Script, Redis and GraphQL – together I’m a great fan of both Redis and GraphQL. You’ll find plenty of articles about them around on this site. Although I’ve showed many examples of GraphQL and […]
Apps Script
4 ways to customize scrviz info card behavior
Info Card customization By default the info card appears when you hover over a node in the scrviz visualization. Although the info card is they key tool for investigating scrviz entries, it can be annoying […]
Apps Script
Find an Apps Script library id in 10 seconds with scrviz
You want to include an Apps Script library, and you know it’s name, but not its id. A pain right? Here’s 3 easy steps to find it in https://scrviz.web.app Step 1 – find the library […]
Apps Script
More scrviz updates to help you enrich your profile and repos
A few scrviz updates today, with more flexibility around the depth of the repo visualization and more options to enrich your own profile. Less is more for visualization We have a rapidly increasing number of […]
Apps Script
Microsoft OneDrive plugin as a cache for Google Apps Script
OneDrive as Cache platform In Apps script library with plugins for multiple backend cache platforms I covered a way to get more into cache and property services, and the bmCrusher library came with built in plugins […]
Apps Script
Google Cloud Storage platform cache plugin for Apps Script crusher
Google Cloud Storage as Cache platform In Apps script library with plugins for multiple backend cache platforms I covered a way to get more into cache and property services, and the bmCrusher library came with built […]
Apps Script
Apps script library with plugins for multiple backend cache platforms
Motivation This library used to be part of my cUseful collection, but I’ve decided to pull out into a library in it’s own right. The idea is not only to be able to squeeze more […]
Apps Script
Enrich your scrviz repo profiles and drive traffic to your website or blog
In Enrich your developer profile on scrviz I showed how scrviz could be used to show off your Apps Script work to potential clients (Showcase your Apps Script work and get hired via vizzy) and how to […]
Apps Script
Enrich your developer profile on scrviz
In Showcase your Apps Script work and get hired via vizzy I showed how scrviz could be used to show off your Apps Script work to potential clients, so they could see what kind of […]
Apps Script
Direct scrviz link to your Apps Script github repo, project or owner
Motivation You’ll know from Every Google Apps Script project on Github visualized that you can get a very large diagram of all known public Apps Script projects and from Find and clone Apps Script projects from github […]
Apps Script
Find and clone Apps Script projects from github directly into the IDE with scrviz
Motivation Every Google Apps Script project on Github visualized describes how to use https://scrviz.web.app to find and visualize public Apps Script projects on Github. More and more apps script projects are being publicly shared on github. […]
Apps Script
Apps Script Vizzy – new views, searches and filtering examples
Apps Script Vizzy update Every Google Apps Script project on Github visualized introduces a way of visualizing public Apps Script projects on github. Showcase your Apps Script work and get hired via vizzy shows how […]
Apps Script
Showcase your Apps Script work and get hired via vizzy
Get yourself found as an Apps Script consultant Every Google Apps Script project on Github visualized introduced this vizzy app to give a searchable view into public apps script projects on Github. If you are […]
Apps Script
Vizzy github data open access – how to build something with Apps Script
In Every Google Apps Script project on Github visualized I introduced Vizzy which uses GitHub data as its source. That same data package is available publicly in case you want to build something on top of […]
Apps Script
Searching and cataloging Apps Script projects on Github
In Every Google Apps Script project on Github visualized I demonstrated an app that could be used to explore what every Apps Script developer who has shared their code is working on. It can be used […]
Apps Script
Every Google Apps Script project on Github visualized
Motivation There are so many Apps Script projects out there where the source code is published on Github, but it’s hard to find what you want. Whether it’s a library, an example of an add-on, […]
Apps Script
Rate limit handler, helper and iterator: Apps Script use cases
Motivation for apps script example I originally create both qottle and rottler for various node projects, but realized that I had some Apps Script that could be solved with them too. One of them was […]
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. […]
Apps Script
Rate limit handler and helper: Test and manage rate limiting APIS
rottler – a rate limit helper Working with rate limits can be hard, so the purpose of rottler is to provide no only a way of testing rate limit strategy, but also an helper to […]
Add-ons
Improve Vue.js Apps Script add-ons with a Vuex store
Vuex If you use Vue.js, then you probably use (or should consider using) Vuex for state management. Like most Vue.js related things, it’s at its easiest when used with Node tooling, but you can also […]
Add-ons
Including npm modules and Vue components: an htmlservice pattern for Apps Script add-ons
Include patterns When using HtmlService it can be quite messy to organize your script/js/html/css files and vue components so that they can be inserted into your add-on/webapp. This becomes much more complex when you want […]
Add-ons
Browser tab visibility : adjusting add-on behavior
When a browser tab goes in and out of view, it’s possible you want to do something differently. If you’re writing Apps Script add-ons this is especially true. TabVisibility is a class to allow […]
Add-ons
Optimize updates to Google Sheets with fiddler fingerprints
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
How to use Vue.js, Vuex and Vuetify to create Google Apps Script Add-ons
Create beautiful Apps Script add-ons with Vuetify and Vue.js The idea of ‘reactive programming’ has been around for many years, but frameworks such as React, Vue and so on have moved it into the mainstream. […]
Apps Script
Apps Script
What is Apps Script It’s the language used for extending GSuite and is based on JavaScript. Unlike the JavaScript that runs in your browser, it runs on a Google Server in the cloud, but unlike […]
Apps Script
Apps Script v8
Apps script now supports JavaScript ES6 Apps Script V8 now supports the same modern JavaScript you can use when writing for the browser. Up until now, you had to write in a dialect of JavaScript-based […]