the prompt this whole guide is built on
Here's my syllabus. List every assignment, quiz and exam as a table with three columns named exactly Subject, Start Date and Description. Write every date as MM/DD/YYYY. Only use dates that are written in the syllabus. List anything without a date separately underneath.
Every class gives you a syllabus with the whole semester on it. Then nobody opens it again, and a quiz shows up on Thursday that you swear nobody mentioned.
Fix it once. AI pulls every date into a table, you save that table as a CSV file, and Google Calendar imports the whole semester in one go. A CSV is just a spreadsheet saved as plain text, which is a format Google Calendar knows how to read.
How to do it
- Upload the syllabus PDF or paste its text into an AI chat, then send the prompt above.
- Check every row against the syllabus. Fix wrong dates and read the list of stuff with no date.
- Paste just the table, without the undated list, into a blank Google Sheet. The top row has to say exactly Subject, Start Date and Description.
- In Sheets, go to File, then Download, then pick the .csv option.
- Open Google Calendar on a computer, since importing doesn't work in the phone app. Next to Other calendars, hit the plus and create a new calendar named after the class.
- Click the gear, then Settings, then Import & export. Choose your file, pick the new class calendar and hit Import.
Make them all day events
Add a fourth column called All Day Event and set it to True for every row. Keep the other column names exactly the same.
Add study reminders
For every exam in the table, add a row three days earlier with the same columns and date format. Its Subject should say Start studying for and then the exam's name.
that's it. go try it tonight.
