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 →

Creating a GCP project to publish a Google Apps Script Add-on

Alan Wells has created a great YouTube video with some information about the Google Cloud Platform, creating a standard GCP project and associating it with your Apps Script project. https://www.youtube.com/watch?v=vEDUt7aj15k

Share

read more →