In this post, we’re going to look at how we can remove duplicates from a list on Google Sheets and also store those duplicate rows on a separate sheet. Google Sheets has a remove duplicates feature but it only removes the duplicates and sometimes you also want to have a list of those. So, here… Continue reading Remove and separate duplicates in Google Sheets
Category: Apps Script
Apps Script – How to deploy a library
Apps Script libraries In this post we’re going to look at how we can connect an Apps Script project to a library file. So, first, why would we want to do that? You want to connect to an external project, which you haven’t written. There’s an example of this in my post on how to… Continue reading Apps Script – How to deploy a library
How to quickly make short pre-filled URLs
In this post, we’re going to look at how we can quickly make short bit.ly links for pre-filled Google Forms using Google Sheets and a bit of Apps Script. Bit.ly links are great but if you have to make a lot of them in can be a slow, tedious process. Plus, if you also want… Continue reading How to quickly make short pre-filled URLs
Apps Script: How to automate a script
In this post we’re going to look at how to set up a trigger in Apps Script and look at some of the options available. So, first of all, what’s a trigger? A trigger automatically calls a function in the script project based on some kind of event. This could be something changing on a… Continue reading Apps Script: How to automate a script
How to authorize an Apps Script project
In this post, I’ll show you how to authorize an Apps Script project. This could be a project that you’ve written yourself or it could be a program someone else has written and something like Google Sheets has displayed a pop up window asking you to authorize the code. The good thing is that it’s… Continue reading How to authorize an Apps Script project
Mail merge using draft emails
In this post, we’re going to look at creating a simple mail merge program, which will use a draft email as the basis of the final email that will be sent out. The idea is to have a program which is flexible enough to send different messages out and that can be used by admin… Continue reading Mail merge using draft emails
Issues reporting with translation
In this post, we’re going to look at a simple issues reporting system, where the teacher fills out a Google Form to report the issue. This is stored in a Google Sheet, and an email with the summary of the issue is either sent to the maintenance person or IT technician, depending on the type… Continue reading Issues reporting with translation
Multiple FOLDER maker
Making multiple copies of folders in Google Drive is a slow, boring task. You select the folder you want, make a copy, then have to rename it, then repeat this again and again. Here you’ll learn how to create multiple folders and name them individually, really fast using Apps Script. If you’ve already read my post “Multiple… Continue reading Multiple FOLDER maker
Multiple FILE Maker
Making multiple copies in Google Drive is a slow, boring task. You select the file you want, make a copy, then have to rename it, then repeat this again and again. Here you’ll learn how to make multiple copies of a file and name them individually, really fast using Apps Script. First, we have a… Continue reading Multiple FILE Maker
Card sorting game using Google Sheets & Apps Script
One popular method to get your students to learn is to categorise things or to put them in order. Here, we’re going to look at making a card sorting game, which could be used for both. This is the web app we’re going to make: The code There are two parts to the code, stored… Continue reading Card sorting game using Google Sheets & Apps Script