How to turn a school newsletter into Google Calendar events

A school newsletter is one email that behaves like five. Picture day is in paragraph two, the bake sale is in a table, the early close is a single bold line, and the fee is in a PS you will only see if you scroll. Reading it is not the same as getting it onto the calendar.

Do it while the email is open: find the lines that change your week, turn each into its own event, and leave the rest in the mail.

Read it like a list, not like a letter

Do not read a newsletter from the top and hope the dates stick. Search inside the message. On a computer, click the email and use the browser find command (Ctrl+F, or Command+F on a Mac). On a phone, use the Find in page option in the browser menu, or copy the whole email into a note and search there.

Search for day names, the coming months, am and pm, dismissal, due, bring, sign, and fee. Most hits are not events. Leave menus and thank-yous in the email. Create an event only when someone has to be somewhere, bring something, pay something, or sign something.

If the newsletter is a PDF or a poster, Gmail's find box will not see the words. Select the text, or copy a picture of it with Live Text or Google Lens.

Make one event per date, with a title you will understand later

Open Google Calendar. For each real line:

1. 1
   Click the day. Use a start and end if you have them. If the line is only a day ("forms back by Thursday"), tick All day.
2. 2
   Title it for a future glance: Sam: book fair money, $8 cash. North: early dismissal 1:15pm. Avoid School event.
3. 3
   Paste the original sentence into the description, with where it came from ("12 March newsletter").
4. 4
   Timed events: notify 1 hour before. All-day deadlines: notify the day before at a time you look at your phone, such as 4:00pm. A ping at breakfast on the due date is often too late.
5. 5
   One email often deserves four events. Do not squash a week into a single all-day blob.

If Gmail shows Add to calendar on a date, or a small event chip at the top of the message, use it as a head start. Check the year, fix the title, and paste the sentence into the description before you save. Google is good at spotting "Thursday 14 May, 6pm" and bad at naming it.

What to do with "next Friday"

Relative dates are where newsletters go wrong. The writer knows what they mean. You, reading it on Sunday, might not. Resolve the date from the day the email was sent, which is in the date line at the top of the message. Do not resolve it from the day you finally got around to reading.

• This Friday is the Friday of the week the email was sent. If you are reading the following Monday, that Friday may already have passed.
• Next Friday is ambiguous. Trust a full date if one is printed. If not, put the sooner Friday on the calendar and add CHECK to the title until someone confirms.
• A week on Friday (Friday week) is usually the Friday after the coming one. Type the real day and month into the title.
• A month and day with no year belongs to this school year. In October, June 4 is next summer. In May, it is this year. If your date is already past, the line may be a recap, or you may be late.

"Next Friday" is not a title. "Fri 16 Oct: mufti day" is. Keep the original phrase in the notes.

Fees, forms, and lines that are not events

A field trip is two events. The trip is timed, with the place and what to wear. The money and the slip are an all-day deadline days earlier: Sam: $12 trip money due. In the description, note who you pay and how (cash, a check, the parent portal). Sign the slip the night before and put it in the folder by the door. A reminder on the morning it is due usually means the form is still at school.

A whole-school early close goes on each child's calendar. A club or a year-group photo goes only on the child who is in it. Put the name first in the title.

The faster way

Kinboard is free and in open beta. Paste the newsletter, forward it to your household's Kinboard address, or upload it if it arrived as a PDF. Kinboard pulls the dates, deadlines, fees and to-dos into a review queue. Nothing reaches your calendar until you approve it.

Approved events and deadlines sync to Google Calendar. Timed events get a reminder one hour before. Deadlines go on as all-day events with a reminder the day before. Each child has a color, and the calendar event uses that color. Payments and to-dos stay on the Kinboard board, not on the calendar. It is a web app: you can add it to your home screen, and there is no separate store app.