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 […]
Category: Google Apps Script
Rose Photo Manager – Bulk Copy Google Photos to Google Drive
If you, like me, miss the automatic sync between Google Drive and Google Photos we lost in July 2019 (as Google thought we’d find it too complicated!) this is the GSheet for you. Rose Photo Manager copies the photos and […]
Meet the experts!
Proud to be included in a recent blog post about the Google Workspace Google Developers Experts! https://developers.googleblog.com/2020/12/meet-google-workspace-developer-experts.html
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 […]
GSheet Sidebar with Materialize CSS & jQuery
Tutorial on creating a Google Spreadsheet Sidebar with Materialize CSS framework, jQuery JavaScript framework, and Google Apps Script.
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.