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 & Java Script
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. […]
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
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 & Java Script
JavaScript typo detection with proxies
How to make getting JavaScript code in the right order less of a chore, and detect object property typos before they become a problem. […]
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 […]
Apps Script & Java Script
Apps Script Oauth2 library Goa: tips, tricks and hacks
Motivation Goa is a library to support OAuth2 for Apps Script connecting to a variety of services, using a variety of Authentication flows and processes. There are plenty of other articles on Goa on this […]
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 – 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 & Java Script
Apps script caching with compression and enhanced size limitations
Motivation Caching is a great way to improve performance, avoid rate limit problems and even save money if you are accessing a paid for API from Apps Script. A big limitation though is that cache […]
Apps Script & Java Script
Iterator magic – Splitting an array into chunks
It’s a pretty common requirement, especially when you’re posting to an API, to split an array of data into manageable chunks, and most often the solution is to make an array of arrays – with […]
Apps Script & Java Script
Simple but powerful Apps Script Unit Test library
Why unit testing? There are many test packages for Node (my favorite is ava) and there are also a few for Apps Script but I couldn’t find one that was exactly what I was after, […]
Apps Script & Java Script
JavaScript proxy, fiddling with Apps Script objects and custom errors
This article is a little more advanced than usual, and we’ll cover a number topics in one go. A JavaScript proxy gives us the ability to intercept JavaScript as it attempts to access the properties […]
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
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
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 […]
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
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 & Java Script
A third way to preserve formulas with fiddler, plus 2 new methods
In 2 ways to create and preserve formulas with fiddler for Google Apps Script I gave some examples of how to preserve formulas if you are using fiddler for Sheets. Fiddler does have a number of […]
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 & Java Script
Google Apps Script – What a difference 5 years make – Episode 2
It’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 […]
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 […]
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
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
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
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 & Java Script
Google gapi, Vue and Vuex together
JavaScript authentication with Gapi is both impressive and frustrating. Frustrating because in most of the examples you come across, and indeed in Google’s own guides, gapi is the center of the universe. They are about […]
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
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. […]
General JavaScript techniques
TimeSimmer : An adjustable timer for apps that need to speed up or slow down time
TimeSimmer When creating simulations, and especially when testing or demoing apps that simulate events over time, you often need to speed up or slow down time. You may even need to slow it up or […]
Apps Script & Java Script
Apps Script V8: Keystore for global space
One of the challenges with Apps Script V8 compared to Rhino is that you can’t be sure of the order of global variable initialization. Personally, this is not an issue for me, as I avoid […]
Apps Script & Java Script
Qottle recipe: Managing asynchronous queues with duplicates
Qottle recipe for managing asynchronous queues with duplicates Qottle is a queue for asynchronous tasks with prioritization, ratelimit, and concurrency support. It can also detect and reject duplicate requests. This recipe shows an example of […]
Apps Script & Java Script
Qottle recipe: How to manage an asynchronous polling queue
Qottle is a queue for asynchronous tasks with prioritization, ratelimit, and concurrency support. This recipe shows an example of a qottle queue for continuous, controlled polling. Qottle recipe for polling You can use qottle […]
General JavaScript techniques
Queuing asynchronous tasks with rate limit and concurrency constraints
Qottle If you are using an API you often need to queue tasks that are asynchronous and constrained by other factors such as rate limits of the API. Qottle is a general purpose queue manager […]
Apps Script & Java Script
Goa v8 changes and enhancements
v8 and other htmlservice changes meant I had to make a few small changes to cGoa. The good news it’s easier to use than ever, and supports a few new services too. It’s best to look at the service list on github, as that’ll be kept up to date. Here’s a reminder of how to use it. […]
Apps Script v8
Apps Script V8: Arraybuffers and Typed arrays, endianness and views
This article looks at how to extend classes and apply that easily handling data structures presented as an array of bytes as you’d have to do when dealing with binary data from a file. […]
Apps Script & Java Script
Apps Script V8: Provoke server side code from add-ons and htmlservice
There are some new problems to do with the accessibility of functions in the global space which depend on a number of factors such as the order of declaration, and whether they are in a […]
Apps Script v8
Apps Script V8: Arraybuffers and Typed arrays
Apps Script V8 implements ArrayBuffers and Typed arrays from ES6. If you’ve used Apps Script Crypto Utilities or done any work with Blobs, then this is what’s going on behind the scenes, now exposed as […]
Apps Script v8
Apps Script V8: Maps and Sets
Apps Script V8 implements a couple of useful new ES6 structures – Maps and Sets. Here’s what they are and how to use them Maps and Sets: What are they? These are a collection of […]
Apps Script v8
Apps Script V8: Multiple script files, classes & namespaces
Multiple Script Files: The problem Apps Script V8 doesn’t have a module loader system. If you’re used to developing in NodeJs, you’ll also be familiar with importing and exporting to include required modules in your […]
Apps Script v8
Apps Script V8: Template literals
V8 adds template literals from JavaScript ES6. Template literals: What are they? It’s a shorthand way of using a template into which variables are substituted in a string. This allows for better reuse of string […]
Apps Script v8
Apps Script V8: spreading and destructuring
Apps Script V8 adds destructuring from JavaScript ES6. Legacy Apps Script already had destructuring of arrays added fairly recently, but v8 gives full a destructuring capability. Destructuring: What is it? It’s a way of plucking […]
Apps Script v8
JavaScript V8 Arrow functions, this and that
Function declarations versus arrow functions JavaScript V8 adds the arrow function declarator from modern JavaScript. This is a handy shorthand but it’s more than just that. There are some behavioral differences too that you’ll need […]
Apps Script v8
JavaScript V8 variable scopes
var, const and let One of the key things that V8 has sorted out is the scope of variables. Using var to declare variables meant that anything declared within the scope of a function could […]
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 […]
Apps Script & Java Script
Setting up blister lists
In Using blister custom functions I showed examples of how to lookup scriptDB lists as custom functions. Here’s how to create lists. In each case, to access lists in your sheet you need to add a reference […]
Apps Script & Java Script
Blister validation code
Here is the code for each of the example mentioned in GAS lists and validation. The custom functions You need this in your local workbook. You can find it in the examples sheet. These are the custom […]
Apps Script & Java Script
Using blister custom functions
Examples Let’s take an example. Say you are a small garage, with a stock list of cars and you work exclusively with spreadsheets. You don’t want to take copies of the list, but you want […]
Apps Script & Java Script
Blister custom functions
The custom functions These are the custom functions you can call directly from your sheets. The function documentation is here and you can find examples of use in Using blister custom functions and you’ll need the code described in Blister […]
Apps Script & Java Script
GAS lists and validation
It’s very common to want to lookup some list, or apply them as validation to data entry when playing around with Spreadsheets. Between them, a search for Spreadsheet related VLOOKUP, INDEX and MATCH return 30 […]
Apps Script & Java Script
Easy reference for published scripts
It would be useful to keep a reference guide to all projects and libraries shared on github, and their IDS. If you are using gasgit, then we already have everything needed to make that as […]
Apps Script & Java Script
Measuring sheet operation performance
Looking into how various operations perform as the size of the sheet increase provided some interesting data. The objective is to see whether the time to execute particular operations is directly proportional to the size […]
Apps Script & Java Script
Performance
All about performance analysis, tips and tricks for getting the best out of both Apps Script and Excel. […]
Apps Script & Java Script
scriptDb JavaScript api examples
The JavaScript client is very similar to A VBA API for scriptDB, so reading that will give you a more detailed flavor of what can be done. The implementation is very different though, and there are […]
Apps Script & Java Script
Testing the API
This is a ScriptDB API for JavaScript. The tests that are referred to in scriptDB API for JavaScript are implemented in https://storage.googleapis.com/toasty/t/gas/scriptdbapi.html. Code is below <!DOCTYPE html> <html> <head> <meta charset=”utf-8″ /> <title>scriptDB data input – ramblings.mcpher.com</title> <link […]
Apps Script & Java Script
scriptdbcom implementation
Here is the javascript implementation for the scriptDB API. It needs jQuery. * methodType = “GET”; */ var dataType = “json”; if(!postData) { u += “&callback=?”; dataType = “jsonp”; } var d = $.Deferred(); var […]
Apps Script & Java Script
Authenticating scriptDb JavaScript API
As per this blog post, Google Apps Script does not support CORS (cross origin resource sharing) to allow access from cross domain client apps. The API uses JSONP for GET requests to get over this, but […]
Apps Script & Java Script
cParseCom implementation
I use scriptDB a lot , both with Google Apps Script and from other sources, including VBA, and in this blog post, I compare parse.com performance with script DB. One of the things that Parse.com has going […]
Apps Script & Java Script
Some simple examples
Because the GAS API is so similar to parse.com – nosql database for VBA, you may want to read that too, which has similar examples. Note that virtually all methods can be chained leading to pretty […]
Apps Script & Java Script
creating Parse Classes from Google Spreadsheets
Just as in parse.com – nosql database for VBA, you’ll probably want to load up some test data from a Google Spreadsheet to a Parse.com class. You’ll find some test data in this workbook – it’s same data […]
Apps Script & Java Script
The Orchestration namespace
Take a moment to read these if this is a new topic for you. Orchestration of Apps Scripts – parallel threads and defeating quotas Jobs, work, stages, threads and chunks Namespaces and App structure Creating […]
Apps Script & Java Script
Creating a work package
Take a moment to read these if this is a new topic for you. Orchestration of Apps Scripts – parallel threads and defeating quotas Jobs, work, stages, threads and chunks Namespaces and App structure Code […]
Apps Script & Java Script
Namespaces and App structure
Take a moment to read these if this is a new topic for you. Orchestration of Apps Scripts – parallel threads and defeating quotas Jobs, work, stages, threads and chunks Code is on github GasThreader structure […]
Apps Script & Java Script
Jobs, work, stages, threads and chunks
Before getting started on how to set up Orchestration of Apps Scripts – parallel threads and defeating quotas let’s get a few definitions clarified. Code is on github This dashboard will provide the reference point for each of […]
Apps Script & Java Script
Goa in a sidebar
This describes how to implement goa in a sidebar. The example will assume that the authorization process should be repeated for each new user (like a web app published in Accessing as the user running the […]
Apps Script & Java Script
Getting and using the token
This describes how to get and access token from the Goa library as described in Oauth2 for Apps Script in a few lines of code (which you should read first for background). If you have initialized the […]
Apps Script & Java Script
Automatic UI support for OAUTH2 Goa dialogs
There’s always a little bit of work needed if you are planning to do an OAUTH2 flow that might need some user interaction. Goa now is able to create its own UI to manage the […]
Apps Script & Java Script
How fast can you get OAuth2 set up in Apps Script
Many people are a little intimidated by OAuth2 in Apps Script, and because you don’t need to set it up very often you always need to work from a cheat sheet. Luckily if you use […]
Apps Script & Java Script
How OAuth2 works and Goa implementation
Oauth2 for Apps Script in a few lines of code (which you should read first for background) has many pages of videos and tutorials about different OAuth2 scenarios for Apps Script and is used daily in […]
Apps Script & Java Script
How to customize the consent screen
This describes how to customize a consent screen using the Goa library as described in Oauth2 for Apps Script in a few lines of code (which you should read first for background). What is a consent screen […]
Apps Script & Java Script
Setting an alternative ontoken callback
This describes how to authenticate with Podio using Goa, as described in Oauth2 for Apps Script in a few lines of code (which you should read first for background). The library, cGoa, is available under this project […]
Apps Script & Java Script
Unnesting data to sheet values
This is an Apps Script version of the code referred to in Flattening arrays for Elastic Search. The point of that article is to prepare data arriving from GraphQL for elastic search, but it also solves […]
Apps Script & Java Script
Using Google Earth
javaScript: Flying around and asynchronicity in google Earth This relates to Data Driven Mapping applications and the Javascript HowTo section Google Earth Api You will find tons of content on Google Earth , most of which is described […]
Apps Script & Java Script
Using Google Visualization DataViews
javaScript: creating google visualization Data Views This relates to Data Driven Mapping applications and the Javascript ‘HowTo’ section Google Visualization dataViews As mentioned in Using Google Visualization DataTables a master google DataTable is created for all data in […]
Apps Script & Java Script
Using Google Visualization DataTables
javaScript:creating google visualization DataTables This relates to Data Driven Mapping applications and the Javascript HowTo section Google Visualization Tables I have covered Google Visualization in various forms with an ‘Excel slant’ on this site. Let’s take a look […]
Apps Script & Java Script
Providing VizMap Data without Excel
VizMap: the data javaScript This relates to Data Driven Mapping applications For this example I had created a Concerts/Venues example that is now deprecated. The complete workbook (googlemapping.xlsm) can be downloaded (above) and the example Parameter WorkSheet is […]
Apps Script & Java Script
Creating VizMap framework without Excel
VizMap: the framework javascript This relates to Data Driven Mapping applications For this example I had created a Concerts/Venues example that is now deprecated. The complete workbook (googlemapping.xlsm) can be downloaded (above) and the example Parameter WorkSheet is […]
Apps Script & Java Script
VizMap Application Filename
VizMap: the Viz Html parameter Block This relates to Data Driven Mapping applications This parameter block is handled by cDataSet classes and is used to define the filename of the to be generated application. It also contains customization […]
Sheets specific
cOauth2 class implementation
In Google Oauth2 VBA authentication I showed how to use this class. All associated libraries are available in the cDataSet.xlsm library downloadable here, or through gistthat, as described here. You’ll need the cRest module. Examples […]
Apps Script & Java Script
VBA and jsdoc
For an overview of what VbaGit is, please read Integrate VBA with Github. If you are working with Google Apps Script as well as VBA, then you will probably be familiar with JDSOC. This is a way […]
Apps Script & Java Script
Getting started with VbaGit
For an overview of what VbaGit is, please read Integrate VBA with Github. Getting the code You can get the code from github or you can get a premade bootstrap workbook from the github stuff section in the downloads […]
Libraries
EasyCron Library
The easyCron service is a cloud based scheduler for recurrent jobs. Google Apps Script has it’s own scheduler for triggering tasks, but you may prefer the management capabilities with easyCron. You have to sign up, […]
Libraries
Snippets
Copying to new host location
In Finding where Drive hosting is being used in Sites, we created a couple of sheets by examining the hosted files referenced in a Google Site so that we could sort out the world after […]
Snippets
Finding where Drive hosting is being used in Sites
Now that Drive hosting is going away, we face the task of discovering where its used. One place that it may be used a lot is if you are using the old version of Sites. […]
Snippets
Identifying hosted files
In Finding where Drive hosting is being used in Sites, we created a couple of sheets by examining the hosted files referenced in a Google Site so that we could sort out the world after […]
Snippets
API Specific
Using the slideshare API from Apps Script
I used to use Slideshare a fair bit but I’d forgotten all about it until today. I wanted to see what I had there and if anyone was looking at it. I suppose I could […]
API Specific
Using Google sheets via Bigquery from Apps Script
The Apps Script team released this post today about integrating BigQuery and sheets. So this means you can use SQL to access any sheets that you’ve linked to bigQuery. You can follow the instructions in […]