Software Development Archives

Google Apps Script – File Clone

Andrew Roberts / Friday, September 15th, 2023

This little script makes a copy of a list of Google Drive files in a Google Sheet in a folder […]

Andrew Roberts / Monday, March 30th, 2020

Ever needed to merge two similar datasets and automatically get rid of any duplicates? This article describes how to

Andrew Roberts / Friday, March 6th, 2020

This GDrive folder contains a great video demo of how Alex Ivanov has set up his environment to develop Google Apps Script

Andrew Roberts / Monday, March 2nd, 2020

I have done a write-up of the various ways the functionality of a Google Apps Script can be shared/published/deployed.

Andrew Roberts / Friday, January 10th, 2020

Unfortunately we don’t yet have our own npm in Google Apps Script 🙁 Although there have been efforts to

Andrew Roberts / Saturday, February 9th, 2019

Apps Script guru Bruce McPherson has produced an excellent summary of some of the latest developments in 2018.

Andrew Roberts / Thursday, July 19th, 2018

There are a lot of videos like this out there, but I particularly like this one and its emphasis on

Andrew Roberts / Thursday, June 14th, 2018

Here’s a writeup of a GitHub work flow for multiple devs with various tips and tricks we’ve picked up along

Andrew Roberts / Wednesday, November 9th, 2016

This script automatically emails the submission from a Google Form as a PDF. The PDF is created by populating a

Andrew Roberts / Friday, September 30th, 2016

I had an interesting question from a client recently about why should they pay my full rate (I charge hourly)