If you're new to Apps Script, would like to learn some key features, or have had a go but would like some structured guidance, we now have a self-directed online course you can work through, Essential Apps Script. You don't need any prior coding knowledge to get started with it.
Explore the Essential Apps Script course:
It is helpful for automating things you might do in Google apps or finding creative solutions to problems.
Apps Script works by accessing different 'apps' within your code so that you can work with Google applications and their respective features. For example, you use the SpreadsheetApp to work with features of spreadsheets and the DriveApp to work with features of Google Drive.
So, what can you do with Apps Script? How do you go about planning an Apps Script project?
If you've used Google Workspace apps, you've probably got some ideas about what you wish they could do or have processes it would be good to automate. You might want to be able to create a lot of files or folders in one go, automate things that happen from a form submission, or extend Google Sheets.
One important thing to consider is scale. For most users, Apps Script is very good for small scale solutions, but if your project would either be used more widely than just you, or would be used for larger scale or business critical processes, you might need to take extra things into consideration. If you're at the University of York, get in touch with IT via firstname.lastname@example.org to discuss any Apps Script projects you might be looking into doing and get advice.
For more on using Google apps and what they can already do, see our Google Workspace guidance:
If you're at the University, we've created some useful tools based on Apps Script, that can be used without any coding knowledge. Check there's not already a tool out there for what you're looking to do:
If you're learning Apps Script and want some inspiration for what you could do, here's some things that are possible with Apps Script (caution: some of these might be trickier than others to create!):
If you want to have a go at writing some Apps Script, try following this first livecoding walkthrough from the Essential Apps Script course, which focuses on writing your first script to read a cell in a spreadsheet.