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 […]

Google API

infoBox for google Map popups

What is the infoBox An infoBox is an enhanced infoWindow. Details can be found here . I will be converting the Google Maps modules on this site to use the infoBox rather than the native Google Maps […]

No Picture
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 […]

Google API

Encoding client keys for Maps

If you have a business account for Google Mapping, you’ll need to provide your client id and crypto key. These things are meant to be kept private, so I did not provide a mechanism for […]

Integrating Excel with Maps and Earth

Using Google Earth – creating KML files

Plotting markers on on a Google Earth This article will cover how to create a basic KML file so that your Excel data can be mapped on Google Earth. There is a more advanced implementation […]

Google API

Getting an API running in Kubernetes

In Getting cockroachDB running with Kubernetes I covered how to get your cockroach database orchestrated by Kubernetes. Next you’ll want to get your API running, and expose it over SSL. Normally I’d put these kind […]

Drive

Using Drive SDK from Google Apps Script

If you want to play around with your scripts from within Apps Script, you’ll need to use the drive SDK. Although Drive is available as a Google Apps Script advanced service, the SDK is not – […]

Drive

Polling and the Drive changes API

This topic was covered on Totally Unscripted 5 (TU5). You’ll find the Youtube Channel here. Polling I’ve already covered polling for changes in a number of articles such as Watching for server-side changes from the […]

Chrome

Chrome Tracing Example

Here’s a real example of using the ChromeTrace library to take a look at what a triggered task is up to, and examine what we can see in the tracing tool. I’m going to add some tracing […]

No Picture
Google API

Connecting Google Sheets to APIs, and building apps with Retool

This is a repoduction of the tutorial, which can be found at https://tryretool.com/blog/google-sheets-app-tutorial/ Access the tutorial and documentation. Contents: Background Live demo Reading data from Google Sheets Displaying data in a table Creating a form […]

APIS and techniques

Orchestrating APIS to analyze OCR data

This is the second step in Making sense of Ocr – an orchestration wrapper for the APIS we’ll need. In Google Vision and OCR I showed how to use the vision API to turn a pdf into a series […]

No Picture
Execution

Testing Javascript on the PC

These articles are abridged from my book on Office to Apps migration. Going GAS, from VBA to Google Apps Script. Now available  from O’Reilly or Amazon. Translated chunks of code can be hard to test outside the environment in which they […]

Apps Script & Java Script

Using Google Visualization charts and tables

javaScript: creating google visualization charts and tables This relates to Data Driven Mapping applications and the Javascript HowTo section Google Visualization tables and charts All visualizations are created from the dataViews mentioned in Using Google Visualization DataViews. Once […]

Google API

Adding flight paths to Maps

Overlaying polyLines to make flight paths on google markers This article will cover how to add flight paths to Google Maps. For a quickstart, see Step by Step Guides Try it out first ? If you […]

Google API

Quicklinks and Categories

Navigating using quicklinks and categories Try it out first ? For a summary step by step explanation see How to add quickLinks to a Map If you just want a to try it, then you can […]

No Picture
From VBA to Google Apps Script

How to make charts in Google Apps Script

The Charts Service Google Apps Script offers a charts service. Using this you can build a dataTable as input to a chart, as well as the chart itself. Elsewhere on this site I covered how to […]

No Picture
Docs

VBA debug object

There is a debugger for google apps script. Here’s how to use it Compared to the VBA debugger it sucks, so you probably need to be able to log and assert. javaScript does not have […]

Google API

Adding markers to Google Maps from Excel

We’ve already looked at how to geoCode addresses using various APIs. Now lets look at using Google Maps to put markers on a Map using an Excel worksheet as input. As usual you can find the […]

Google API

Web Services

Interacting with APIs This site uses a lot of calls to Google APIs in order to connect Excel to web applications. There are a number of custom classes used everywhere such as  Data Manipulation Classes and Excel […]

No Picture
Apps Script & Java Script

Mapping the demo

By the time that A gigantic pub crawl gets here, then various components will have suggested pubs inside an area and declared pub crawls. We can use the Maps API to work out the optimal route between […]

No Picture
Drive

Tracking github pageviews

Apps Script (advanced level) posted on 16th Oct 2017 Github pageviews You can get things like number of stars and watchers etc from the GitHub REST API repository data, but pageviews are not tracked there. […]

copt between drive and gcs
Apps Script & Java Script

Response format from apps script project query

Format of Info.json Each project directory contains an info file that describes the scripts for this project. It is also used to decide whether the sources in the project need to be refreshed. To force […]

No Picture
Apps Script & Java Script

Making sense of gwt rpc dependency service

Obsolete This post is now pretty much obsolete. As of April 2016, the dependency service seemed to disappear. Next attempt was via a hacked autocomplete service to discover dependencies, which worked until 2018. Now this […]

No Picture
Drive

Getting your apps scripts to Github

GasGit Getting your scripts to Github is not the easiest thing in world. Nowadays people mainly do it manually, which is fine for small scripts, but when you have many with lots of library dependencies, […]

Cloud Functions

Using Google Maps API with Google cloud functions

If you are thinking about using Google Cloud functions (and you should), you may be wondering how to use things like Google Maps in the context of cloud functions. Well, cloud functions allow you to run Node.js […]

No Picture
Drive

Visualizing Apps Script dependencies

dependencyForce If you use a lot of libraries, sometimes things get a bit messy. You delete an old version to clean up and suddenly notice a few days later that things stop working because it’s […]

No Picture
Apps Script & Java Script

Using the People API with Apps Script

The BigQuiz app uses the People API to identify who is using it so that it can keep track of game and category scores. I could have used the Gplus api – which has an Apps Script advanced service, […]

APIS and techniques

BigQuery and the Execution API

The data for BigQuiz app is held in BigQuery. In Loading large JSON datasets into BigQuery with Apps Script I showed how you could maintain data in BigQuery with Apps Script, but now when I come to use it, […]

No Picture
BigQuery

BigQuiz app

This is a webapp that touches on a number of different Apps Script capabilities such as.. The app structure OAuth2, and multiple providers and roles Firebase authentication Firebase to manage player data Using libraries to […]

Google API

Overlaying circles and heatmaps

Overlaying shapes on markers  Try it out first ? If you just want a to try it, then you can download an example application (googleMapping.xlsm) and come back here later. First you should take a look at Adding markers […]

Chrome

Chrome Tracing class for VBA

This is a library to allow us to use the Chrome Tracing utility for VBA profiling. It works exactly the same way as the ChromeTrace library for apps script. You should look at them both and see just how […]

No Picture
Chrome

ChromeTrace library

This is a library to allow us to use the Chrome Tracing utility for apps script profiling. I’ve implemented a subset of what can be profiled, but will implement additional capabilities if there is enough interest. The […]

Chrome

Tracing

Chrome has a brilliant tracing visualizer. This allows you to provide trace file data to visualize what’s going on in an app. You can read about it here. Once you have a trace file, you start […]

Chrome

Chrome

This section is all about Chrome related development. Chrome content tracing

Google API

Data Driven Mapping applications

Deprecated Google has now stopped its Earth API and Maps API is a paid for API nowadays. Some capabilities have also been either removed or changed. Therefore, I had to remove all examples of VizMap […]

No Picture
Docs

Get Data From Google Docs

There have been a number of changes to Google Docs over the years each of which has provided more ways to do things. The latest is the new Sheets API V4,which is by far the best […]

No Picture
Drive

Drive SDK and GitHub

You probably have used the Apps Script DriveApp service. There are examples of this scattered throughout the projects on this site. There is another way to manipulate your Google Drive – an SDK that exposes its APIs to external […]

Drive

Drive JSON API for apps script

In Using Drive SDK I described why you might want to use the SDK JSON API rather than the built in Apps Script Drive Class. Before you can start with this you need to authorize your access with OAUTH2, […]

No Picture
Apps Script & Java Script

Using a service account

In Borrowing an access token from Apps Scripts I demonstrated the simplest way to get a token to use with a Google API, by borrowing one from Apps Script. However to access APIS that have no equivalent in […]

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 […]

Google API

Recursion

If you are a ‘recursion newbie’, you may want to first read Getting started with recursion, or take a look at a real, but simple example with How to traverse a treeview Getting to grips with recursion […]

No Picture
Colors

Coloring maps and other shapes

In Using Google Maps I covered how to create various web based interactive maps. Of course many would like to use Excel to create maps, and the topic of chorpleth maps, has been covered many times by […]

No Picture
Execution

Final migration steps

These articles are abridged from my  book on Office to Apps migration. Going GAS, from VBA to Google Apps Script. Now available for directly from O’Reilly or Amazon. Now the data has been migrated, the logic migrated and the orchestration is now managed by Apps Script. In most […]

No Picture
Execution

Migrating orchestration

These articles are abridged from my  book on Office to Apps migration. Going GAS, from VBA to Google Apps Script. Now available  from O’Reilly or Amazon. As the migration progresses, there is less and less happening in VBA, and its role […]

No Picture
Execution

Migrating logic

These articles are abridged from my  book on Office to Apps migration. Going GAS, from VBA to Google Apps Script. Now available from O’Reilly or Amazon At this stage of migration, some data has already been moved to Sheets, it is […]

No Picture
Execution

Reading and writing Sheets from VBA

These articles are abridged from my book on Office to Apps migration. Going GAS, from VBA to Google Apps Script. Now available  from O’Reilly or Amazon. If you just want to transfer data between sheets and excel and back again, the […]

No Picture
Apps Script & Java Script

JSON and VBA

These articles are abridged from my  book on Office to Apps migration. Going GAS, from VBA to Google Apps Script. Now available  from O’Reilly or Amazon VBA does not naturally support JSON, but to be able to use this API (and […]

Apps Script & Java Script

Authentication and access

These articles are abridged from my  book on Office to Apps migration. Going GAS, from VBA to Google Apps Script. Now available directly from O’Reilly or Amazon. As with most VBA authentication processes on this site, authentication is handled through the […]

No Picture
Execution

VBA and Apps Script inventory

These articles are abridged from my  book on Office to Apps migration. Going GAS, from VBA to Google Apps Script. Now available directly from O’Reilly or Amazon. To be able to use the Execution API, various assets that are not naturally […]

Apps Script & Java Script

Incremental migration

These articles are abridged from my  book on Office to Apps migration.  Going GAS, from VBA to Google Apps Script. Now available  directly from O’Reilly or Amazon. All code samples can be found on Github. Note that that VBA samples have […]

No Picture
Execution

Execution API and Office to Apps migration

These articles are abridged from my book on Office to Apps migration. Going GAS, from VBA to Google Apps Script. Now available  from O’Reilly or Amazon What is the Execution API ? This is a brand new API that enables the running […]

No Picture
Docs

Google Docs to Excel Asynchronously

I’ve been playing around with creating a promise based framework for VBA for a while now, mainly just to see if it was possible. Here’s a practical implementation that gets the data from a large […]

No Picture
Google API

Comparing Bing, Ovi, Yahoo and Google Maps

Geocoding Excel While looking at how to connect Excel to Google Maps,  I implemented a capability in vba for each of the main Apis for geoCoding capability through a simple http: request. You can read […]