Google Apps Script can go way beyond a simple script that solves a problem. In this article I will showcase the way I deploy Google Apps Script code in an Enterprise environment. I will share the actual build file and the necessary steps and tools to reproduce my workflow. This approach does require Google Cloud Platform knowledge and a credit card. The instructions are high level, this article is not a codelab. If you get stuck, leave a comment and I will try to assist and update the article.

Image for post
Image for post
Photo by David Gilbertson on Unsplash

When I use Google Apps Script to solve a problem I…


Get the number of emails with a specific label

Image for post
Image for post
Photo by Andreas Dress on Unsplash

Software development is hard. This tweet illustrates how professional developers sometimes see their job:


The Apps Script dashboard lets you manage and monitor your Apps Script projects. This is the first sentence in the documentation about the Apps Script dashboard. It describes the high level purpose of the Apps Script dashboard, but what does that mean in real live environments. In this article I will describe some of my use cases for the Apps Script dashboard.

Image for post
Image for post
Photo by Mitchel Boot on Unsplash

Opening the Apps Script dashboard is usually the first step I take whenever I start working in a new environment. I work for multiple companies and I have a lot of Google Accounts. It is great to see…


In this article I will showcase one of the many ways you can customize your Google Workspace environment. We will implement two custom functions in Google Sheets. With these functions as an example I will demonstrate how to use Google Apps Script Libraries to organise and distribute your solution. There are multiple ways to distribute your Apps Script code within the Google Workspace, and this article will help you decide if this library method is right for you.

Image for post
Image for post
Photo by Gabriel Sollmann on Unsplash

Custom functions are a great way to address specific use cases in Google Sheets. In this case I will focus on how…


Building and maintaining code can be hard. There are multiple phases in the livecycle of the code, each phase with its own challenges. Being able to easily retrieve information about the execution of your code in each phase is key. This is where the new Google Apps Script IDE debugging and logging features can help. In this article I will show you what you can do with the new debugging and logging features.

Image for post
Image for post
Photo by Timothy Dykes on Unsplash

A simple Google Apps Script is used to walk through the powerful features of the debugger and logging. In the final part of the article we will…


Image for post
Image for post
Photo by Karsten Würth on Unsplash

Apps Script now supports the V8 runtime. Time for an update to the story “Structure and simplify your Google Apps Script Apps script”. The V8 runtime brings modern ECMAScript syntax to Apps Script. So we can now use arrow functions and destructuring assignments. No more hoisting with let and const and my personal favorite, template literals.

In this story I will show the added value of the changes I made in the constructor pattern using the factory functions. I will also show how to implement chaining and a builder pattern in Apps Script.

The function now uses arrow functions…


Organise your JavaScript objects in Google Apps Script with the constructor pattern by Douglas Crockford.

Image for post
Image for post
Photo by Evan Dvorkin on Unsplash

Factory functions and Apps Script are a good match. Structuring your code in App Script with these factory functions simplifies the process of developing and maintaining code. In this article I provide examples and background information on why I use the pattern.

The background

Apps Script is based on JavaScript 1.6, plus a few features from 1.7 and 1.8. It is synchronous as long as you stay on the server side. Editing is done in a limited online editor. We are waiting for an update of the JavaScript engine and an updated editor. …


Image for post
Image for post
The ID token is used to identify the user accessing the application

Google Cloud Endpoints can be used to develop, deploy, protect, and monitor your APIs. I use the Cloud Endpoints for OpenAPI with an App Engine standard environment backend app in Python.

The architecture and how to set up the environment is described in the How-to guide Getting Started with Endpoints for App Engine standard environment.

Setting up this environment on a local development machine involves Docker and is described in the Running ESP locally or on another platform How-to guide.

For the authentication I use the Google ID token authentication. This involves creating the client ID and client secret and…


I have seen many scenarios where we moved Google Drive files into a G Suite environment. In one scenario the files belonged to conflicting accounts. In another case a we moved a set of user accounts and related content to another G Suite environment.

Google Drive files can be migrated using the standard tooling. Or you can have the owners migrate the files themselves. This copy is a new document and bookmarks or other references to this document are lost. The shares on the document can be recreated and the comments can also be copied. …


Image for post
Image for post
Organizing

Keeping a record of time spent on tasks can be a challenge. Should you update daily, weekly, make notes, use a spreadsheet or just a piece of paper? The dreaded monthly email, please enter your time, it is the end of the month and we need to send the invoices. I have been in situations where I needed to enter the time in three systems, one of them being an terminal based program.

Keeping the records in sync, find a frictionless way to record daily time became important to me. The first iteration of getting control over the process was…

Jasper Duizendstra

Freelance Google Cloud Platform Architect, Google Workspace GDE

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store