Skip to content

Assignment Reminder System

Example prompt: "Track assignment due dates from our course spreadsheet. Email students 3 days and 1 day before each deadline. Alert me on Slack when someone submits late."

How to automate assignment reminders with GloriaMundo

The Problem

Missed deadlines are one of the most common friction points in any course, whether corporate training or academic. Instructors maintain a spreadsheet of assignments and due dates, but students lose track, forget to check the schedule, or misjudge how much time they have left. Sending manual reminder emails is tedious and easy to forget, especially when you are managing multiple cohorts or courses. The result is a wave of late submissions, extension requests, and follow-up conversations that eat into teaching time.

How GloriaMundo Solves It

We build a workflow that reads assignment due dates from your Google Sheets course tracker. A conditional step checks which assignments have deadlines approaching within the next 3 days or 1 day, and triggers the appropriate reminder. For each upcoming deadline, an integration step sends a personalised email to the relevant students via Gmail, naming the assignment, the due date, and any submission instructions. The workflow also creates Google Calendar events for each deadline so students have a visual reminder. If a submission is marked late in the spreadsheet, a conditional step catches it and posts an alert to the instructor's Slack channel. Glass Box preview shows you exactly which emails will be sent and to whom before anything goes out.

Example Workflow Steps

  1. Trigger (scheduled): Runs daily at 8:00am to check for upcoming deadlines.
  2. Step 1 (integration): Read assignment due dates, student email addresses, and submission status from the Google Sheets course tracker.
  3. Step 2 (conditional): Identify assignments due in 3 days and assignments due in 1 day, filtering out any already submitted.
  4. Step 3 (integration): Send a 3-day reminder email via Gmail to students with assignments due in 3 days.
  5. Step 4 (integration): Send a 1-day reminder email via Gmail to students with assignments due tomorrow.
  6. Step 5 (conditional): Check for any assignments past their due date that are not yet marked as submitted.
  7. Step 6 (integration): Post a late-submission alert to the instructor's Slack channel with the student name and assignment details.

Integrations Used

  • Google Sheets — source of assignment due dates, student details, and submission status
  • Gmail — sends personalised reminder emails to students before deadlines
  • Google Calendar — creates deadline events so students see reminders in their calendar

Who This Is For

Instructors, teaching assistants, and L&D coordinators who manage assignment schedules for one or more cohorts and want to reduce late submissions without manually chasing students.

Time & Cost Saved

Manually tracking deadlines and sending reminder emails for a class of 30 students with weekly assignments takes roughly 30-45 minutes per reminder cycle. This workflow runs automatically each morning and handles all reminders without instructor involvement. Over a 10-week course, that saves approximately 5-8 hours of administrative work. The workflow uses only integration and conditional steps, costing minimal credits per daily run.