What’s different in Google Workspace to a free Gmail account? This post will show you some of the differences between a paid Google Workspace account and a free personal Gmail account and quite often Google Workspace users aren’t aware of some of the extra features Workspace offers, so let’s have a look some of them… Continue reading What’s the difference between a Google Workspace and a free Gmail account?
Posts
How to automate Google Sheets tasks with Macros
Do you get fed up with doing the same monotonous tasks over and over again on your spreadsheets? Well, there’s one thing that may save you time – Macros. These record you doing actions on your sheets, then with a click of a button you can repeat those actions in seconds. Here, we’re going to… Continue reading How to automate Google Sheets tasks with Macros
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
Google Workspace 2021 Recap (2)
This is part 2 of a summary of the main improvements to Google Workspace that were made in 2021. Here, I’ll focus on Google Meet, Forms, Calendar, and Sites. If you missed it, you can find part 1 which looked at Google Sheets, Docs, and Slides here. Google Meet New ways to join a meeting… Continue reading Google Workspace 2021 Recap (2)
Google Workspace – 2021 Recap (1)
It was a busy year for the Google Workspace team and there were a lot of changes and improvements that came out during the course of the year. As there have been so many improvements, in this part I will cover Sheets, Docs, and Slides, and in the second part I will cover the improvements… Continue reading Google Workspace – 2021 Recap (1)
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