What is Google Apps Script?

Google Apps Script is a Javascript-based coding platform built into Google Apps (Sheets, Forms, Gmail, Classroom, etc). You can use it to add your own functionality and build small apps of your own. In the context of education, you can create routines to manage repetitive tasks like inviting guardians to Classroom courses or sending praise emails when a teacher submits a Form.

When I first learnt how to use Apps Script, I found the learning curve far steeper than it really needs to be.  The reference documents are aimed at programmers rather than enthusiastic amateurs and most of the examples they give don’t use the in-built Apps Script editor (or even javascript sometimes!).  That’s where this site comes in.  It addresses the questions that don’t otherwise have easy to find answers and it gives concrete code snippet examples in the context of real applications in educational settings.

Apps Script fundamentals

The details you need to know, but which aren’t easy to find.

Working with Sheets

Code snippets for reading from and writing to Sheets

Working with Classroom

Code snippets for managing courses, students and guardians in Classroom