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. […]
All the Google Apps Script related github activity is now on Google Bigquery and Google Looker. Here’s how it was done. […]
An example use case for Kubernetes workload identity federation – transferring collections from mongodb to bigquery with a Kubernetes cron job […]
3 secret managers working together. How to use GCP Secret Manager, Kubernetes secrets and Doppler together. […]
Anaylze and colorize the sentiment of inidivual sentences in Google using Documents Google Language API […]
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 […]
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 […]
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 […]
The problem with rate limits You’ve most likely hit the problem of rate-limited APIS at some point. You make a request and it gets refused because you’ve done too many requests in some time period. […]
The Video Intelligence API allows you to analyze the content of videos. I covered basic labelling in Google Video Intelligence API film labelling. This section will look at how to get a transcript of a film. It turns […]
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 […]
This is a part of the series of posts on Getting an API running in Kubernetes, and you should first have created an app to be deployed as described in Building your App ready for […]
This is part of the writeup on Using Google Cloud Storage with Apps Script. By now you should have completed all the steps in Setting up or creating a console project, Enabling APIs and OAuth2 […]
This is part of the writeup on Using Google Cloud Storage with Apps Script. By now you should have completed all the steps in Setting up or creating a console project, Enabling APIs and OAuth2 […]
This is part of the writeup on Using Google Cloud Storage with Apps Script. By now you should have completed all the steps in Setting up or creating a console project, Enabling APIs and OAuth2 […]
Goa is a library to simplify Oauth2 with both Google services and other Oauth2 providers, many of which are natively supported. It takes care of dealing with HTML dialogs, refreshing tokens, getting service account data […]
The Vimeo Rest API is a simple, standard API. It’s been added to the Goa library list of services. Goa library is available with this key, and on github MZx5DzNPsYjVyZaR67xXJQai_d-phDA33 Vimeo dashboard There are various kinds […]
Martin John Bramwell created a very detailed tutorial on using DataStore and Oauth2 from Google Apps Script. It uses the library from EzyOauth2 – taking some pain out of Apps Script API authentication. For more contributions like these, […]
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 […]
This is the first step in Making sense of Ocr – getting a pdf turned into a JSON map. Mechanics First of all just load your pdf file somewhere in cloud storage, then I’ll use this code […]
In the project I’m using for illustrating some of the capabilities of GCP, I need to make sense of a variety of documents, some very complex and some less so. The basic problem though is that there […]
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 […]
In Firebase auth for graphql clients I covered how to use firebase client side auth to lock down your Apollo Graphql server. Developers and other admins are probably going to need to use the Graphiql tool too […]
The Video Intelligence API allows you to analyze the content of videos. For my use case this is super useful, because now I can Label videos with their content, and use those labels to navigate to the […]
Some cloud apis are considered to be ‘long running’, which means you wont get the result right away. Rather the result is stored and you can retrieve it later. There is an api for doing […]
In Stream content to Google Cloud Storage I covered how you could stream content (in this case a video file) from a hosted URL to an object on cloud storage in preparation for labelling it with the […]
This article looks at the Node implementation to stream content directly to google cloud storage, and we’ll look at how to convert that to a Cloud run function in a later one. Note that although […]
This is one of a series of articles about Going serverless with Firebase. You many want to read about Firebase cloud functions before this article. Using custom domains 2 of the great things you get with Firebase hosting […]
In August 2016, the ability to host files on Google Drive is being deprecated. Many add-ons and sites rely on this capability (this one included) and will need to get on with finding somewhere else […]
If you use any kind of API you’ll eventually have to deal with rate limiting. Most API providers introduce rate limiting to prevent abuse if their platform, but it can be tricky to deal […]
This collection of articles deal with getting Graphql/Apollo server up and running on Node Rate limit handling A deep dive into rate-limiting with the Vimeo API
This is a new section to collate various snippets related to GraphQL both from and back ends. For the purposes of these articles, I’ll be concentrating on the integration of this collection of platforms with […]
This describes how to use 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 key, or on github. […]
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, […]
Now that the data from Query parse.com from GAS, and Query scriptDB from GAS is populated in both parse.com and scriptDb, and we have the capability to Query parse.com from GAS and Query scriptDB from GAS, we can now pull […]
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. 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 section contains some different methods of getting an access token for use with Google APIS that are not built in or advanced services. All the demo code for the full app used in these examples […]
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 […]
This collection of articles deal with various Google Cloud Platform APIS. The full content is below. It is part of a project that I will document at a later stage The next section is a […]
Continuing the theme of using Google Apps Script Content service and scriptDB for lots of things, today’s post cover a few tricky topics. How to convert an image to a blob so it can be […]
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