Library Subject Guides
Google Apps Script is a coding language that allows you to automate and connect together Google apps, like Drive, Docs, Sheets, and Forms. It is based on JavaScript, a web scripting language, but contains features specific to each of the Google apps.
Welcome to the Essential Apps Script course. This guide is designed so you can work through an introductory course in Google Apps Script, designed so you do not need any knowledge of coding to get started.
If you are new to Apps Script, we recommend you work through each page of this guide, reading the guidance, watching the videos and having a go coding along with them. Each page concludes with a project that you should have a go at before moving on to the next page.
Forthcoming sessions on :
There's more training events at:
If you're already working through this course, you can use this to jump to the next part. You can also use this if you're looking for specific guidance on an area covered in the course.
Numbers, strings (text), arrays, other things stored in variables
Working with spreadsheets in Apps Script
Getting spreadsheet files, sheets, the active cell, a range of cells
Editing spreadsheets in Apps Script
Appending rows, setting values, deleting data, formatted links
Getting files and folders by ID, copying a file
Opening documents, getting the body, appending text, replacing text
Setting a new trigger, editing or deleting triggers
Working with Forms in Apps Script
Getting and using the event values, setting the form submit trigger
Sending emails using Apps Script
Sending emails with MailApp, constructing an email body
Adding permissions to files and folders
Setting permissions, removing permissions
An introduction to dates and times in Apps Script
Creating new dates, formatting dates, getting and setting dates and times, creating Google Calendar events
This guide was created by the Digital Inclusion, Skills, and Creativity team in Library, Archives and Learning Services at the University of York. If you have any feedback about the course/guide, you can fill out our one question feedback form.