Skip to content

Permission Slip Tracker

Example prompt: "We've got a Year 7 trip to the science museum on 12 May. Send the permission form from Google Forms to every parent in our class list, track who has replied on a sheet, and email reminders to parents who haven't returned it 5 days before the deadline. Alert me on Slack once the deadline passes with the list of outstanding families."

How to automate permission slip tracking with GloriaMundo

The Problem

Organising a school trip is an administrative grind long before anyone boards the coach. Permission slips need to go out to every parent, responses need to be tracked against the class list, and the parents who have not replied need chasing — often more than once. Paper slips get lost in school bags. Digital forms are better, but still mean someone ticking names off a spreadsheet and manually drafting reminder emails. The trip coordinator ends up playing chase-up for the week before the deadline instead of organising the trip itself, and the last few stragglers always appear on the morning of the trip with a half-completed form.

How GloriaMundo Solves It

We build a workflow that kicks off when you specify the trip, deadline, and class list. An integration step sends the Google Forms permission link to every parent on the list via Gmail, personalised with the child's name and trip details. A scheduled integration step runs daily to read form responses and update a tracking Google Sheet, marking each family as responded or outstanding. A conditional step checks the date — when the deadline is five days away, it emails the outstanding parents a polite reminder; when the deadline is one day away, it sends a firmer follow-up. Once the deadline passes, an integration step posts a summary to your Slack channel listing exactly which families still have not returned the form. Glass Box preview shows you the full parent list and each reminder email before anything is sent, so you can adjust the tone or add trip-specific notes.

Example Workflow Steps

  1. Trigger (manual): You provide the trip name, date, form link, deadline, and class list.
  2. Step 1 (integration): Email the permission form link from Google Forms to every parent via Gmail, personalised with the child's name.
  3. Step 2 (integration, scheduled daily): Read Google Forms responses and update a tracking Google Sheet with each family's status.
  4. Step 3 (conditional): Five days before the deadline, email parents who have not yet responded a polite reminder. One day before the deadline, send a firmer follow-up.
  5. Step 4 (integration): Once the deadline passes, post a summary to Slack listing outstanding families so you know who to ring.

Integrations Used

  • Google Forms — collects parental consent responses
  • Google Sheets — tracks response status per family
  • Gmail — delivers the initial form link and reminder emails
  • Slack — alerts the coordinator when the deadline passes with outstanding families

Who This Is For

Trip coordinators, form tutors, and school administrators organising school trips, consent-required events, or any activity that needs signed parental permission. Also useful for after-school club leads collecting medical or emergency contact forms at the start of term.

Time & Cost Saved

Chasing permission slips for a class of 30 typically eats 3–5 hours of a trip coordinator's week — sending the initial emails, ticking off a spreadsheet, drafting reminders, and ringing stragglers. This workflow reduces the effort to the initial setup and the final follow-up calls for genuinely outstanding families, around 30 minutes. Across a school year with multiple trips and consent events, that saves a meaningful slice of teaching time. The workflow uses integration and conditional steps, costing a few credits per run.