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

  1. Click Download at the top of this page (sign in with your MOE iCON if prompted)
  2. Google will prompt: “Copy document?” → click Make a copy
  3. The copy lands in your own Drive with the Apps Script bound to it
  4. Open the copy, paste your raw event text/PDF into the input cell, run the menu command
  5. 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.