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 Jasper Duizendstra shows the added value of the changes made in the constructor pattern using the factory functions. It also shows how to implement chaining and a builder pattern in Apps Script.
Source: Structure and simplify your Google Apps Script (with) V8
Jasper Duizendstra provides some Google Apps Script coding tips…
Source: Structure and simplify your Google Apps Script – Jasper Duizendstra – Medium
Jasper Duizendstra demonstrates how with a little bit of Google Apps Script you can easily use your Google Calendar to keep a record of how much time you spend on tasks and then query/report this via Google Sheets. The post contains instructions and code for getting started
Source: Record time and activities with Google Sheets, Calendar and Apps Script
Creating BigQuery tables using the GUI can be a hassle. This article describes an alternative way to create BigQuery tables
Source: Create BigQuery tables with Google Sheets and Apps Script