One of my favourites features of a Google Workspace account is Shared Drives. In this post, we’re going to look at what they are, how to use them and how they differ from My Drive. What is a Shared drive? A Shared Drive lives in your Google Drive and is an addition to your normal… Continue reading How to use Shared Drives
Category: Posts
What’s the difference between a Google Workspace and a free Gmail account?
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?
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
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
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
Forms & Sheets – Attendance System
In this post we’re going to make an attendance system using Google Forms and Sheets. The user will fill in the attendance on the form (possibly on their mobile) and the data will then be stored and organised automatically per student. This will also use a Form add-on called FormRanger to easily populate a Google Form… Continue reading Forms & Sheets – Attendance System
Google Sheets – Grouping rows and columns
Grouping and ungrouping columns Sometimes we have large spreadsheets where we want to work with only certain rows or columns. Sheets gives the option to group rows or columns, allowing you with one click to show and hide numerous rows and columns, rather than having to go into the menus and hide the ones you… Continue reading Google Sheets – Grouping rows and columns
Create a Book inventory with Google Sheets & Apps Script
Here we’re going to make a simple book inventory, where we’ll be able to control the location of the books and also find out where a book is. This uses a mixture of GAS code and Sheets functions. We’ve got 3 sheets: Front page – This is what the user will see and use. In… Continue reading Create a Book inventory with Google Sheets & Apps Script
Google Sheets Functions – QUERY
The QUERY function is in a category all on its own. It’s an extremely powerful function that will let you filter, sort, group, pivot, basically extract data from a table and present it in numerous ways. At first it can look daunting, with its own language and syntax, but once you dip your toe into the… Continue reading Google Sheets Functions – QUERY