There are a handful of moments in teaching when a Google Sheet is genuinely the right tool: a parent meeting where you need to show the pattern of missing work over several weeks, an admin conversation where you need hard evidence, or a long-term record you keep for your own reference. Brightspace doesn't give you a direct path to that data. This post covers the manual route and a faster one-click option.
Why teachers want this
Tracking missing submissions in a spreadsheet isn't just administrative tidiness. There are specific situations where it matters:
- Documentation for parent or admin meetings. A visual grid showing which students are missing which assignments, over which weeks, is much easier to discuss than a verbal summary.
- Identifying patterns. Which students have chronic gaps? Which assignments have unusually high non-submission rates, a sign the instructions may need revisiting?
- Department or team records. Some schools ask teachers to keep a log of missing work for reporting periods or intervention tracking.
- Personal peace of mind. A weekly export is a safety net. If something gets disputed later, you have timestamps.
The manual method
Brightspace doesn't have a "Export to Google Sheets" button, so getting missing work data into a spreadsheet requires copy-pasting from each assignment page individually. Here's the process:
The real problem is the repeat cost. This isn't a one-time setup. You have to do it every time you want updated data. For weekly tracking across a full class, that's easily an hour a month spent on copy-paste admin.
ClassWatcher's one-click Google Sheets export
ClassWatcher builds the export for you. Instead of copying from each assignment page manually, ClassWatcher tracks the missing-submission data for every page on your watch list as you visit them. When you're ready to export, you click one button and it pushes everything into a Google Sheet called ClassWatcher.com in your own Google Drive.
Here's what the exported sheet looks like:
| Student | Unit 3 Essay | Chapter Quiz 5 | Lab Report 2 | Missing Count |
|---|---|---|---|---|
| Ahmed, Tariq | ✓ | ✓ | ✓ | 0 |
| Chen, Lily | ✗ | ✓ | ✗ | 2 |
| Diallo, Fatou | ✓ | ✗ | ✗ | 2 |
| Kowalski, Piotr | ✗ | ✗ | ✗ | 3 |
| Singh, Priya | ✓ | ✓ | ✓ | 0 |
Every student in your class appears as a row. Each assignment on your watch list is a column. The cells show a checkmark for submitted and an X for missing, with a Missing Count column on the right. The sheet updates in place: click Export again next week and it overwrites with fresh data, no duplicate tabs building up.
What gets exported
A ClassWatcher export includes three sections:
- Class list. Every student in the class with their name and contact information (where available).
- Missing items grid. The student × assignment matrix shown above, with ✓ and ✗ indicators and a missing count per student.
- Contact history. A log of every SMS and email you've sent through ClassWatcher, with student name, message, date, and delivery status.
Your data stays in your Drive. ClassWatcher writes to a Sheet in your own Google account. No data is stored on ClassWatcher's servers as part of this export. The Google auth is one-time and uses only the permissions needed to create and update that one sheet.
How the Google auth works
The first time you export, ClassWatcher asks you to connect your Google account. This is a standard Google OAuth screen. You're authorizing ClassWatcher to create and update Sheets in your Drive, and you can revoke that access at any time from your Google account settings. ClassWatcher stores a hint of which Google account you used so re-authorization is seamless on subsequent exports.
No data leaves your browser to ClassWatcher's servers during export: the connection is directly between your Chrome session and Google's API.