Productivity
To Calendar
Turn pasted lists of dated items into Google Calendar events.
Why it’s here
Turns unstructured lists of dated items, such as an exam timetable PDF or an email of match fixtures, into Google Calendar events through an Apps Script bound to a Google Sheet.
- Made by
- Koo Tiannuo, Kranji Secondary School
- For
- educators, school-operations
- Topics
- dataiskoo, doraemon, google-sheets, google-calendar
- Country
- Singapore
What this does
Converts unstructured event data (a PDF of exam timetables, an email of CCA match fixtures, etc.) into Google Calendar entries without manual entry. The maker estimates this takes roughly 30 seconds.
How to use
1. Click Open product above (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.
Before you download
Download: the link requires MOE iCON sign-in. You will be signed in with your @moe.edu.sg iCON account automatically, or asked to switch if you are on a different account.
Platform: Google Sheets & Google Calendar.
Raw files needed: None.
Latest version: v1.3, 9 May 2026.
Not on MOE iCON, found a bug, or need a different version? Contact the maker through the form on the DataisKoo Tools gallery.