Google Apps Script Archives

RoseCRM – A free Google Sheet CRM

Andrew Roberts / Friday, January 31st, 2025

There are many advantages to using a Google Sheet as a CRM, including: RoseCRM, a simple but functional CRM, offers […]

Andrew Roberts / Monday, December 2nd, 2024

This text is taken from a forum response on the Apps Script Google Group from Sandeep Kumar Vollala. Key Reasons

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 / Thursday, October 14th, 2021

Not only am I an “expert” but I’m now a Google “champion” too!

Andrew Roberts / Friday, November 6th, 2020

Very proud to have been part of the re-launch of the popular YouTube show dedicated to Google Apps Script –

Andrew Roberts / Saturday, August 1st, 2020

Back in 2013, someone had the great idea of forking the JavaScript testing library QUnit and updating it to work

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 / Saturday, March 28th, 2020

I have repurposed Amit Agarwal’s GSheet for India for use with Welsh regional data. Amit’s website describes how his

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.