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 […]
Tag: Google spreadsheets
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 […]
Google Apps Script Dev Flow with GitHub
Here’s a writeup of a GitHub work flow for multiple devs with various tips and tricks we’ve picked up along the way. What do you think? It is a little prescriptive, but they are all things I’ve found useful, just […]
Rose Money Manager
I’ve just made public the Google Spreadsheet I use for my personal finance management. Features: Schedule regular transactions: Automatically create the next 40 days transactions (to create projected cash flow over the next month). This needs a Google Calendar called “Regular Transactions” […]
Google Sheet Color Scale Add-on – v2 released
Ever popular in the Script Gallery, Color Scale is now available as an add-on in the Google Web Store for adding to your own Google Sheets. The Color Scale add-on for Google Sheets sets the background color of the cells […]
Google UK search position tool
Most of the online search position tools are based on the global google.com rather than the UK site, so when I found this spreadsheet that used Google.co.uk and allowed comparative searches of different keywords I thought it was worth sharing […]
Flubaroo v3.1 – Number range answers
A new version of the Google Apps Script quiz grader/marker, Flubaroo v3.1, has just been released. I’ve added the ability to grade numeric answers within a specific numeric range, rather than only accepting a single value. Useful when you are […]