Sharing secrets between Doppler, GCP and Kubernetes
3 secret managers working together. How to use GCP Secret Manager, Kubernetes secrets and Doppler together. […]
3 secret managers working together. How to use GCP Secret Manager, Kubernetes secrets and Doppler together. […]
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 […]
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 […]
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 […]
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 […]
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 […]
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 […]
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 […]
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 […]
Some APIS allow batching of requests, but with a maximum number you can do at the same time. When the calls are asynchronous, chunking a request into smaller pieces and putting it all together afterwards […]
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 […]
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 – […]
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 […]
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 […]
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 […]
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 […]
If you want to write to sheets from a server side Node app, you can use a service account, but it’s a little tricky as you have to authorize that service account to be able […]
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 […]
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 […]
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 […]
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 […]
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 […]
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 […]
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 […]
In a previous section , I explained how to create javascript to create a Google Motion Chart directly from your from Excel data, and optionally embed it in your workbook. Since it is of course […]
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 […]
This is a snippet from the series described in Playing around with maps and streetview, which will use the service to find an appropriate panorama, given a location, and set the initial heading and pitch so […]
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 […]
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. […]
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 […]
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 […]
In Getting your apps scripts to Github I introduced the idea of using Drive JSON API for apps script to get your source code out of the Apps Script environment as a first step to […]
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, […]
GasGit For the past few years, I’ve been using gasGit (any many of you have too Getting your apps scripts to Github) to get all my public stuff to github. I have over 150 Apps Script repos […]
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 […]
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 […]
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, […]
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, […]
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 […]
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 […]
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 […]
In Drive JSON API for apps script I posted about an apps script library to help with the complexities of using the Drive SDK instead of the Apps Script DriveApp service. It needs Oauth2. Recently, the advanced […]
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 […]
This section is all about Chrome related development. Chrome content tracing
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 […]
GeoCode addresses with Google Maps API If you haven’t read about Bing rules on doing this, please do. In this section, we will look at what Google responds to a request for an address geoMapping. Using […]
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 […]
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 […]
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, […]
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. Next up, was Using a service account where could generate a […]
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 […]
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 […]
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 […]
The Google Sheets V4 API is a very nice piece of work that exposes almost all of the Sheets object model in a REST API. Here’s a VBA wrapper for that API. I’ll add to […]
In Using the Google Sheets V4 API from VBA to integrate Sheets and Excel I showed a VBA API that could be used to talk to the Sheets API, to create some integration between Excel and Office. […]
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 […]
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 […]
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 […]
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 […]
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 […]
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 […]
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 […]
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 […]
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 […]
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 […]
It turns out there is a kind of API – suggestqueries.google.com – that you can use to programatically get what Google autocomplete shows when you use search. You know the kind of thing… It’s well known […]
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 […]
I’ve been messing around with the google Drive API lately, and haven’t really found out how to use it to host images for web sites satisfactorily. That was one of the things that prompted this […]
Yesterday, I showed how to get all the f1 circuit names and locations using the Ergast API along with the Rest-Excel library. Now we have that data to play with, why not visualize them on […]
Twitter, Google Visualizations, Google Maps, Google Earth, Excel – all together. In various posts such as Flying around with Google Earth and The Royal Family and their homes as well as on the ramblings site I showed how to […]
Google Visualizations on Google Map infoWindows and Google Earth Balloons A few weeks ago I wrote about generating data driven mapping applications straight out of Excel, with no javaScript required (by you anyway). It has […]
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 […]
bruce mcpherson is licensed under a Creative Commons Attribution-ShareAlike 4.0 International License. Based on a work at http://www.mcpher.com. Permissions beyond the scope of this license may be available at code use guidelines