Skip to content

Student Progress Tracker

Example prompt: "At the end of each month, pull each student's grades from our tracking spreadsheet, generate a personalised progress summary, and email it to their parent."

How to automate student progress tracking with GloriaMundo

The Problem

Teachers and trainers spend a significant portion of their time writing individual progress reports. The data exists in spreadsheets — grades, attendance, assignment completion rates — but turning those numbers into a coherent, personalised summary for each student is tedious and repetitive. For a class of 30 students, writing even a short progress update for each one takes a full day. The alternative is sending raw numbers, which parents or managers find unhelpful. The result is that progress reports either go out late, are rushed, or simply do not happen as often as they should.

How GloriaMundo Solves It

We build a workflow that runs on a monthly schedule. An integration step reads the full student tracking spreadsheet from Google Sheets, pulling each student's grades, attendance records, assignment completion, and any notes the teacher has added. A code step processes this data per student — calculating averages, identifying trends (improving, stable, or declining), and flagging any subjects or areas where performance has changed notably. An LLM step then writes a personalised progress summary for each student: a few paragraphs covering their strengths, areas for improvement, and specific observations grounded in the data. Finally, an integration step emails each report to the corresponding parent or manager via Gmail. Glass Box preview shows you every generated report before any emails are sent, so you can review, edit, or adjust the tone for individual students.

Example Workflow Steps

  1. Trigger (scheduled): Runs on the last day of each month.
  2. Step 1 (integration): Read the student tracking Google Sheet — names, grades by subject, attendance, assignment completion rates, and teacher notes.
  3. Step 2 (code): For each student, calculate averages, determine performance trends over the past 2-3 months, and flag notable changes in any subject area.
  4. Step 3 (llm): Write a personalised progress summary for each student covering strengths, areas for development, and specific data-backed observations. Keep the tone supportive and constructive.
  5. Step 4 (integration): Email each progress report to the student's parent or guardian via Gmail, with the student's name in the subject line.

Integrations Used

  • Google Sheets — source of grades, attendance, and performance data
  • Gmail — delivers personalised progress reports to parents or managers

Who This Is For

Teachers, tutors, and corporate trainers who track student or trainee performance in spreadsheets and need to produce regular, personalised progress reports without spending a full day writing them by hand. Since this workflow handles personal data, use the Glass Box preview to verify what is being shared and with whom before running.

Time & Cost Saved

Writing individual progress reports for 30 students takes roughly 5-8 hours when done manually — reading data, drafting summaries, and sending emails. This workflow reduces the effort to reviewing the generated reports in the Glass Box preview, which takes around 30-45 minutes. Over a school year with monthly reports, that is 40-65 hours saved. The workflow uses integration, code, and LLM steps, costing a moderate number of credits per monthly run depending on class size.