Google Apps Script – File Clone
This little script makes a copy of a list of Google Drive files in a Google Sheet in a folder called “Cloned Files”. You can get a copy by clicking on this link. You can see the script in Extensions […]
Tag: Google Apps Script
Totally Unscripted Re-launch – Meet the GDEs
Very proud to have been part of the re-launch of the popular YouTube show dedicated to Google Apps Script – Totally Unscripted. “This time tomorrow will see the return of Totally Unscripted the Google Workspace and Apps Script developer community […]
QUnitGS2 – Create QUnit tests with Google Apps Script
Back in 2013, someone had the great idea of forking the JavaScript testing library QUnit and updating it to work with Google Apps Script. However, no (public) work has been done on it since and it is stuck with v1.12 of […]
Merging two 2D arrays/datasets/tables with Google Apps Script
Ever needed to merge two similar datasets and automatically get rid of any duplicates? This article describes how to do that using the SsObjects Google Apps Script library. And if you are just looking for a solution without taking […]
Covid-19 in Wales by region
I have repurposed Amit Agarwal’s GSheet for India for use with Welsh regional data. Amit’s website describes how his work’s behind the scenes. The main difference is mine uses the data put together by Tom White for UK cases who […]
Screencast of developing Google Apps Script offline
This GDrive folder contains a great video demo of how Alex Ivanov has set up his environment to develop Google Apps Script offline using Visual Studio Code, the Clasp script and this boilerplate.
Comparison of Ways to Share a Google Apps Script
I have done a write-up of the various ways the functionality of a Google Apps Script can be shared/published/deployed.
V8 is finally here on Google Apps Script
An exciting day for all us Apps Script devs: Google have finally replace the Rhino JS engine with the V8 used in Chrome and Node.js! So we can now use all those funky new features. If there is not a […]
New Google Apps Scripts Resources: Solutions Gallery and Pulse
There have been a few interesting new resources pop up recently: “The G Suite Solutions Gallery is a collection of sample solutions that demonstrates how you can solve common business challenges with G Suite Developer technologies. These samples showcase different ways to […]