Latest articles
-
All the Google Apps Script related github activity is now on Google Bigquery and Google Looker. Here’s how it was done. […]
-
Getting a bunch of secret values out of kubernetes into your local shell […]
-
An example use case for Kubernetes workload identity federation – transferring collections from mongodb to bigquery with a Kubernetes cron job […]
-
How to add Google Material Colors and your own custom schemes to chroma […]
-
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 [...]
-
3 secret managers working together. How to use GCP Secret Manager, Kubernetes secrets and Doppler together. […]
-
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 [...]
-
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 [...]
-
Apps Script library to convert between file types, including OCR for image to documents, with a huge repertoire of conversion combinations. […]
-
Anaylze and colorize the sentiment of inidivual sentences in Google using Documents Google Language API […]
-
Apps Script library to derive colors and color mixtures based on text to help contextualize sheets content. […]
-
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/JavaScript library to generate prettified HTML Markup from JSON […]
-
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 [...]
-
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 [...]
-
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, [...]
-
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 [...]
-
I’ve written many times about various Apps Script caching techniques such as how to deal with size limits and use different back ends for more persistent caching. In this article, I’ll bring together a few [...]
-
Motivation It’s good practice to keep class and namespace definitions in separate files and avoid defining functions or variables in the global space. However, App Script doesn’t give you control over the order in which [...]
-
Motivation I’ve been working on a CardService Add-on lately which also uses HtmlService, and also runs quite a few things Server side. All of these modes need to share state, and it always ends up [...]
-
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 [...]
Latest posts
-
Google Apps Script – What a difference 5 years make – Episode 2
June 21, 2021 Comments Off on Google Apps Script – What a difference 5 years make – Episode 2It’s been over 5 years since my book ‘Going Gas‘ was published, and Apps Script evolution means that a number of sections of it is now pretty out of date. I’ll use this format then [...] -
Google Apps Script – What a difference 5 years make
June 15, 2021 Comments Off on Google Apps Script – What a difference 5 years makeI’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. [...]