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…


Get the number of emails with a specific label

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 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. …


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…


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. …


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

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…


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…


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…


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…

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