School emails to Google Calendar with Gmail: filters, labels and automation

Gmail can catch school mail, and Google Calendar can nag you about it, but only after you tell them what "school" means. A filter is the automation. A label is the pile. A default notification is the part that fires when you are driving and cannot reread the newsletter.

Set this up once on a computer. After that, the phone apps are enough. Plan on half an hour the first time, then a few minutes when a new teacher or a new portal shows up.

Build the search before you build the filter

Open Gmail on a computer. In the search box, try the domains you actually receive, not the school's website address. Look at five real messages and copy the part after the @. Combine them with OR, inside parentheses:

Run the search. If the results are mostly school and a few surprises, you are ready to filter. If they are a mess, tighten them. Useful operators:

• from:@school.edu matches every sender at that domain. from:office@school.edu is one mailbox, when the domain is too wide.
• subject:"early dismissal" matches that phrase. Without quotes, the words match separately.
• has:attachment filename:pdf finds slips and calendars that arrived as files.
• newer_than:30d limits a test search. Take it off the permanent filter, or older mail never gets the label.
• A minus sign excludes: -from:me or -from:newsletter@shop.com.

For the "do something" mail that does not come from the office, search the subject line instead:

Turn the search into a filter and a label

1. 1
   Click the sliders at the right of the search box, then Create filter.
2. 2
   Tick Apply the label, and create School if you do not have it. Nested labels (School/North, School/West) help when two schools write to you.
3. 3
   For the office and the portal, also tick Skip the Inbox (Archive it). The mail stays unread under the label.
4. 4
   For the subject-line filter (fees, slips, early close), do not skip the inbox. Star it, and still apply School.
5. 5
   Tick Also apply filter to matching conversations, then confirm Create filter.

Leave Mark as read unticked. Leave Delete it unticked. A filter that marks mail read will hide the only signal you had. Once a week, open the School label, unread first. That is the safety net.

From the email to a calendar event

If Gmail can see a date as text, the message shows an Add to calendar chip or an underlined date. Check the year (a month that just passed is sometimes filed under next year), replace a title like Event with the child and the real thing, and paste the sentence into the description. If the chip never appears, the date is inside an image, a scan, or a table. Copy it yourself.

Put the event on that child's calendar, not your primary one. Timed events get a notification 60 minutes before. Deadlines with no clock time are all-day, with a notification the day before at a time you actually look at your phone, such as 4:00pm. A fee is its own event, with the amount and the method: Sam: $12 field trip, cash. The trip itself is a second event, on the day you go.

Make the reminders automatic

Set defaults on the child's calendar so you are not adding notifications by hand five times. In Google Calendar settings, open that calendar. Under event notifications, add 1 hour before. Under all-day event notifications, add 1 day before at a time you handle paper, such as 4:00pm. A phone notification beats email if you do not read mail during the day.

Share the calendar with the other adult (Share with specific people, Make changes to events) and with a grandparent who does pickup (See all event details). Do not make it public. You still decide what becomes an event. The lunch menu does not. The early close does.

The faster way

Kinboard is free and in open beta. You can keep the filters above and also forward mail to your household's Kinboard address, paste a thread, or connect a child's school Gmail. The Gmail connection is read-only. Kinboard cannot send, edit, or delete messages. It looks for school-like mail, not the whole inbox.

What you paste, photograph, upload, or forward waits in a review queue, and you approve it before it can reach a calendar. Auto-add for a connected school inbox is opt-in in Settings and off by default. When it is on, a clearly dated item Kinboard is sure about can skip Review. Anything unclear still waits, and you can edit or dismiss what was accepted. Approved events and deadlines sync to Google Calendar: a reminder one hour before timed events, and a day-before reminder on all-day deadlines. The event uses that child's color. Payments and to-dos stay on the Kinboard board. Add the site to your home screen if you want it beside your other icons. There is no separate app.