What this does
Converts unstructured event data (a PDF of exam timetables, an email of CCA match fixtures, etc.) into Google Calendar entries — in roughly 30 seconds, without manual entry.
How to use
- Click Download at the top of this page (sign in with your MOE iCON if prompted)
- Google will prompt: “Copy document?” → click Make a copy
- The copy lands in your own Drive with the Apps Script bound to it
- Open the copy, paste your raw event text/PDF into the input cell, run the menu command
- First-time use will ask Calendar permission — grant once
Why this is a Google Sheet (not a downloadable file)
This tool uses a Google Apps Script that talks to your Google Calendar. The script has to live alongside the Sheet, so the distribution model is "make a copy" rather than "download a file".
Audience
All staff.