Turn a school-year calendar into draft Google Calendar events with Gemini
- Posted
- by Joshua Kaan (LinkedIn)
- Last checked
- Method:
- How we verify
Evidence: Described by posterThe person describes what happened in words, without screenshots or video.
PartialThe source says it only partly worked, or had a significant problem a person had to deal with.
What went wrong: Gemini drafted and added the events after approval, but couldn't add other email addresses as guests.
Beginner-friendlyNo logins, payments or coding needed. Low risk: paste the prompt and you should get something useful.
Outcome
Instead of typing in the kids' school calendar for the next school year, Joshua Kaan gave Gemini the details. Gemini drafted the events and Kaan approved them. The one thing it couldn't do was add other people's email addresses as guests on the events.
Agent
Prompt Recreated prompt
The source didn't share its exact prompt, so we wrote this from what it describes.
Run this task now, exactly as written below. Everything you need is here, so start straight away and only stop if something required is missing or a rule below tells you to. Goal: Turn my kids' school calendar into Google Calendar events I can review before they're added. Fill in before running: - The school calendar as a PDF, photo or pasted text: [UPLOAD] - Which child or school each date applies to: [NAMES] - Which calendar to add them to: [CALENDAR] Rules: - Draft every event first and show me the full list before adding anything. - Mark days off, half days and events clearly, with the child's name in the title. - Use all-day events unless a time is given. - If you can't do something (like inviting other people), tell me so I can do it myself. - Check facts that can change (prices, opening hours, dates, availability, rules) against the official source, and tell me anything you couldn't verify. Output: A list of draft events to approve, then the events added to my calendar. You'll know it worked when: every school date is on my calendar and I didn't type a single one.
Customize this prompt
Answer the questions below and we'll put your answers into the prompt for you. You can leave any of them empty.
The school calendar as a PDF, photo or pasted text
You'll attach this in the chat tool, not here. Add the file in the chat before you send the prompt.
Your prompt
Run this task now, exactly as written below. Everything you need is here, so start straight away and only stop if something required is missing or a rule below tells you to. Goal: Turn my kids' school calendar into Google Calendar events I can review before they're added. Fill in before running: - The school calendar as a PDF, photo or pasted text: [UPLOAD] - Which child or school each date applies to: [NAMES] - Which calendar to add them to: [CALENDAR] Rules: - Draft every event first and show me the full list before adding anything. - Mark days off, half days and events clearly, with the child's name in the title. - Use all-day events unless a time is given. - If you can't do something (like inviting other people), tell me so I can do it myself. - Check facts that can change (prices, opening hours, dates, availability, rules) against the official source, and tell me anything you couldn't verify. Output: A list of draft events to approve, then the events added to my calendar. You'll know it worked when: every school date is on my calendar and I didn't type a single one.
Scroll to see the whole prompt. Your answers show in green.
2 blanks are still empty: Which child or school each date applies to; Which calendar to add them to. They'll stay in brackets in your prompt, so the chat tool may ask you about them.
What you type stays in this browser tab. We don't send it or save it, and it's gone when you leave the page. If you use a "Try this in" button, your answers go to that tool as part of the prompt.
Try this in:
This prompt has blanks to fill in, like [UPLOAD]. We'll copy it instead of filling it in, so you can edit it before you send.
Opens in a new tab. We don't see what you send.
These links are only a shortcut. We're not affiliated with OpenAI, Google or xAI, and your results may not match the source.
Optional stronger version
Our rewrite with extra checks. The poster didn't test it.
Run this task now, exactly as written below. Everything you need is here, so start straight away and only stop if something required is missing or a rule below tells you to. Goal: Turn my kids' school calendar into Google Calendar events I can review before they're added. Fill in before running: - The school calendar as a PDF, photo or pasted text: [UPLOAD] - Which child or school each date applies to: [NAMES] - Which calendar to add them to: [CALENDAR] Rules: - Draft every event first and show me the full list before adding anything. - Mark days off, half days and events clearly, with the child's name in the title. - Use all-day events unless a time is given. - If you can't do something (like inviting other people), tell me so I can do it myself. - Check facts that can change (prices, opening hours, dates, availability, rules) against the official source, and tell me anything you couldn't verify. - After adding, list any dates in the source you weren't sure about so I can check them. Output: A list of draft events to approve, then the events added to my calendar. You'll know it worked when: every school date is on my calendar and I didn't type a single one. Before you finish: re-read my goal and constraints, check your answer against each one, and list anything you assumed or couldn't confirm.
Source
Related cases
- Turn school and sports schedules into importable calendar invites with ChatGPTRecreated promptEvidence: Described by poster
Emily Steinberg uploaded their children's school-year calendar to ChatGPT, had it list the events in a table first to check it got them right, then asked for a downloadable .ics file of calendar invitations and imported it. Steinberg repeated this for sports teams and after-school activities, says it saved at least an hour that season, and shared the file with other parents so they could load the events too.
ChatGPT · Personal · Source date:
- Turn a messy weekly brain dump into a Google Calendar import file with GeminiEvidence: Article or interview
An Android Police writer plans the week each Sunday by writing out meetings, errands, bills and appointments in plain language and asking Gemini for a CSV to import into Google Calendar. The writer double-checks everything before importing, and says Gemini sometimes outputs plain text instead of a downloadable file, which they save as .csv themselves.
Gemini · Personal · Source date:
- Find snack days and spirit days for each of three kids on school calendars with GeminiEvidence: Described by posterBeginner-friendly
A parent of three kids with three school calendars and many 'special events' photographs each calendar and gives it to Gemini with context, e.g. find his son's snack day (16 nut-free snacks) and all spirit days, filter to only that child's events, then add them to Google Calendar with a reminder to bring the snacks.
Gemini · Personal · Source date: