Skip to content
  • Email Signup
  • Contact Us
Compass Horizontal W Mod White (1)
MENU
  • Compass Partners in Learning
  • Services
    • Professional Development
    • Community & Family Engagement
    • Classroom & Team Support
    • Data, Evaluation & Planning
    • Culture & Connection
    • Training & Events
    • BHSSC Canvas Catalog
    • TIE Conference
    • Birth to Three
    • 21st Century Programs
    • SD SFEC
    • BHOLC
    • ThirdSpace Collaborative
    • First LEGO League
    • About Us
    • Staff
    • Careers
    • Compass Membership
    • Title Funding Planning & Support
    • PD Catalog
  • Blog & News
  • There are no suggestions because the search field is empty.

Tracking and Reminder System

A Google Sheet that follows one report, form, or task across many people or organizations and emails each of them reminders on a schedule until they are done. It runs from your own Google account, and you can try everything in Preview mode before a single email goes out.

At a Glance

  • Who it's for: Offices that collect the same thing from many people, such as grant reports, compliance forms, surveys, or quarterly numbers from partner sites.
  • What it does: Keeps a status and due date for each person, sends reminders before, on, and after the due date, thanks people when they finish, and can collect quarterly numbers through an optional partner portal.
  • What you need: A Google account (Workspace or personal). No coding is required. Reminders work without publishing a web app; the optional portal needs one.
  • Your data: Names and email addresses of the adults or organizations you track. Everything stays in your own Google Sheet, and every email sent is logged there. It is not built for student information.
Make a Copy of the Template

Quick Start

These four steps get reminders going for your own list. The full walkthrough on bradylicht.com covers each setting in more detail.

  1. Make a copy of the template. Use the Make a Copy button at the top of this page. Nothing you change affects the original.
  2. Run Get started. In the spreadsheet, open the Tracker menu and choose Get started. Seven short steps set up your organization name, what you are tracking, and your list of people. When Google asks for permission, review it and allow access.
  3. Check your messages and schedule. Open Tracker, then Open Control Panel. The sample messages and reminder schedule work as they are, or you can edit the wording and timing.
  4. Preview, then turn it on. Choose Tracker, then Preview what will send. Nothing is sent and nothing is logged. When it looks right, set Send Mode to Auto and turn on the daily check.

The Tracking and Reminder System Control Panel overview showing 5 people tracked, 4 overdue, none due in the next 7 days and 1 finished, with an Is it running? check and a breakdown by status.

Good to Know

Start in Preview

A new copy starts in Preview mode, so it only shows what it would send. You can also use Draft mode to review each email in Gmail before it goes out.

Mind Your Email Limits

Reminders send from the account that owns the copy, so Google's daily sending limits apply. For long lists, a shared office account works better than a personal one.

The Portal Is Optional

The partner portal and recipient actions need a published web app that anyone with a signed link can open. Leave them off if you only need reminders.

Want Help Setting It Up?

Some teams set this up on their own. Others want help writing the messages, planning a reporting schedule, or setting up the partner portal. Compass can help with any of those, and the finished tool still belongs to your district.

For every setting and option, read the full Tracking and Reminder System walkthrough on bradylicht.com.

Request Information

Get in Touch

Let’s talk about how a custom tool could save your team time.

Request Information

Related Tools

Danielson Walk-Through Observation Form

A quick walk-through form for principals, built on the Danielson Framework, with a record for each teacher.

Learn More About the Danielson Walk-Through Form

General Behavior Tracker

Staff log student behavior from a phone in under 30 seconds, and the sheet turns entries into patterns.

Learn More About the General Behavior Tracker

Staff Rounding Dashboard

Anonymous staff check-ins that help school leaders hear what is working and what staff need.

Learn More About the Staff Rounding Dashboard
Compass Horizontal W Mod White (1)

The Compass Vision

A future where schools, families, and communities are connected to support all individuals.

 

605-394-1876

1925 N Plaza Blvd.
Rapid City, SD 57702

  • Services
    • Professional Development
    • Community & Family Engagement
    • Classroom & Team Support
    • Data, Evaluation & Planning
    • Culture & Connection
  • Learning Opportunities
    • Training & Events
    • BHSSC Canvas Catalog
    • TIE Conference
  • Projects
    • Birth to Three
    • 21st Century Programs
    • SD SFEC
    • BHOLC
    • ThirdSpace Collaborative
    • First LEGO League
  • Who We Are
    • About Us
    • Staff
    • Careers
    • Compass Membership
    • Title Funding Planning & Support
    • PD Catalog
  • Blog & News

Copyright © 2026 Black Hills Special Services Cooperative.
Privacy Policy

BHSSC_Logo

Compass Partners in Learning is a division of Black Hills Special Services Cooperative