Action required
Return excursion consent
Due Thursday · form link retained in the original email
Parent actionGoogle-first family admin
Turn school email into
clear family actions.
School Action Hub files useful updates, checks dates and highlights what the family needs to do. Every original message stays available.
- Google-only
- Duplicate-aware
- Dates checked
Fictional family briefing · no school data
Calendar checked
Family afternoon
Future date validated before an event is created
Added onceFiled quietly
Weekly learning update
Archived to Drive, with no unnecessary alert
No actionThe real problem
See what needs action and file the rest.
The hub separates events, health notices, forms, invoices, policies and general updates. It alerts the family only when someone needs to act.
How it works
Each email is checked before anything changes.
If one message fails, the hub leaves it for review and continues with the rest.
- 01Gmail
Find school messages
Gmail searches only the approved school and childcare senders. Spam and Trash stay out.
- 02Apps Script
Remove duplicate copies
The hub compares message content and attachment hashes so copied emails do not create repeated files or alerts.
- 03Google Gemini
Sort each message safely
Sensitive health and incident notices never go to Gemini. The hub checks Gemini's output again before using it for other messages.
- 04Drive · Calendar · Gmail
File it and flag the action
The hub saves the record in Drive, adds valid future dates to Calendar and sends one Gmail alert when someone needs to act.
What it handles today
A tidy archive with the important actions pulled out.
Organised archive
Attachments and messages go only to approved category folders. AI cannot invent a destination.
Duplicate protection
Several checks catch renamed attachments and repeated copies of the same message.
Safe Calendar events
Malformed, past or implausibly distant proposals are discarded before Calendar is touched.
One-action alerts
Every actionable update gets its own readable email with deadlines, reasons and links back to the source.
Privacy
Family information stays in Google.
The whole workflow uses Gmail, Drive, Calendar, Apps Script and Google Gemini. This public page contains only fictional examples.
- No non-Google AIGemini is the only model, and the workflow checks its output
- No automatic replies or deletionThe hub organises and alerts; the parent stays in control
- No sensitive notice analysisClear rules handle incident and health content without AI
A Drew's Digest project