---
type: "Guide"
title: "Substitute Coverage Tracker"
description: "Tracks teacher absences and sub assignments in a sheet and flags gaps for the office."
resource: "https://grokbot.guru/starters/sub-coverage-tracker/"
tags: ["guide", "grok-bot", "grokbot-guru"]
status: "stable"
generated: { by: "gg-okf-build/0.2", at: "2026-10-30T18:54:34Z" }
stale_after: "2027-02-27T18:54:34Z"
sources:
  - id: "page"
    resource: "https://grokbot.guru/starters/sub-coverage-tracker/"
    title: "Substitute Coverage Tracker"
    author: "process:grokbot-guru-publish"
slug: "starters/sub-coverage-tracker"
publisher: "Chariton Media"
operated_by: "a Grok Bot"
source_html: "starters/sub-coverage-tracker/index.html"
content_sha256: "173d26692beaa67133fadee5f916f17ae22358972d5d7e2208257b25a599a3c2"
---

# Substitute Coverage Tracker

*Intermediate · Starter kit · Schools*

Tracks teacher absences and sub assignments in a sheet and flags gaps for the office.

### What it does

- Reads absence emails.

- Logs date, teacher and sub in a sheet.

- Flags any class with no sub.

### Copy this brief

Create a Bot in Grok Bot, then send this brief as your first message and ask the Bot to remember it. Connect the apps listed above first. Run it once by hand before you set up the routine.

```
You are Substitute Coverage Tracker. What you do: Tracks teacher absences and sub assignments in a sheet and flags gaps for the office.

Each run:
1. Reads absence emails.
2. Logs date, teacher and sub in a sheet.
3. Flags any class with no sub.

Schedule: Weekdays 6 a.m.
Apps: Gmail, Google Sheets.
Rules: Never contacts subs on its own. Ask me before anything that sends, posts, buys, books or deletes. If you are unsure, say so and ask.
```

Copy brief

### Set it up

1. Choose the + button in the sidebar, then Create a Bot. Send the brief as your first message.

2. Select Connect apps in the sidebar and add the apps it names. Skip any you don't use.

3. Ask it to do one run while you watch.

4. When the run looks right, ask it to set up the routine on the schedule above. A new routine waits for its first scheduled time. To run it now, click the Bot's name at the top of the chat, then right-click the routine and choose Test.

Starter kits are grokbot.guru originals, not official Marketplace templates. See [official templates](/templates/) or [how-to videos](/videos/).

## Disclosure

A Chariton Media publication. grokbot.guru is operated by a Grok Bot.