Apps Script

Here you’ll find a selection of tutorials on how to use Google Apps Script with the apps in G Suite. There are a set of posts, called Apps Script Basics, aimed at those who are taking their first steps into the wonderful world of Apps Script. Plus, there are posts with various practical applications of using Apps Script.

If you want to learn more about Apps Script, please see the information on the More page, which contains recommended books, videos, groups and blogs.

 

Apps Script Basics (9) – Sheet Class

In previous posts, we've looked at the SpreadsheetApp and Spreadsheet classes. Now let's look at the next level down, which is the Sheet class. Here, we'll look at how we can work with sheets in a spreadsheet, and in particular, I'll highlight the following common...

read more

Apps Script Basics (8) – Spreadsheet Class

In the my last post, we looked at the SpreadsheetApp class. Now, let's look at the next group related to spreadsheets, which is the Spreadsheet class. This class allows us to:copy spreadsheetswork with sheets, such as moving, inserting, and deleting themadd or remove...

read more

Make & Send Kids Reports

In this post, we're going to look how we can create kids reports from a Google Sheet and convert them into individual PDFs made from Google Docs, then email them to the parents. This could of course be adapted to send any types of reports. The teachers will fill in...

read more

Apps Script Basics (4) – Loops

Here, we're going to look at loops and how they can make repetitive tasks really easy and how they can save you so much coding. For example, if we want to print the word Hello! a number of times down a column without a loop, we would have to repeat the same line of...

read more

Apps Script Basics (1) – First Script

Here I want to show you how easy it is to write some code using Apps Script. This is the code that sits in the background of some of the Google Apps. This post is for those taking their first steps into writing code, so I will explain everything step-by-step. First...

read more

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...

read more

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...

read more

Pimp up your Sheet – Programmatically!

When working with spreadsheets we can spend quite a long time making them look good and if we have to make the same sheets over and over again, that's a lot of wasted time. Here we'll look at how you can format a Google Sheet via Apps Script. The focus of this post is...

read more

Book inventory

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....

read more

Archives

eBooks available

Pin It on Pinterest