Google Apps Script – File Clone

File clone Google spreadsheet

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 […]

Share

read more →

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 […]

Share

read more →

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 […]

Share

read more →

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 […]

Share

read more →

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.

Share

read more →

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 […]

Share

read more →