Uploaded September 2026 | Updated September 2026, 1 day ago

---

Your weekly schedule lives in a spreadsheet. Your colleagues need it in Google Calendar. This walkthrough shows how to get it there with Gemini, with every student name stripped out and the room attached to every event, repeated across the whole school year.

It starts with an error a lot of people hit: "Imported 0 out of 0 events." The cause was a single file ending, and the fix is one sentence in the prompt. That moment is the real lesson here: look at what the AI hands you before you act on it.

What you'll see:

Prepping the spreadsheet so every session has a room
Why one template week is enough (you don't need a tab per week)
The exact Gemini prompt, and the line that prevents the error
Checking the CSV before you touch your calendar
Creating a separate calendar so you can share it and delete it cleanly
Importing and sharing with staff

The schedule in this video is synthetic. No real students, names, rooms, or schools appear.

Free downloads:

Step-by-step guide docs.google.com/document/d/130YSDrShff8KicBiNLTFDHkohurj3IS7mGvE2tD16M0/edit?usp=sharing