TWJ School Digital
INTERNATIONAL SCHOOL DIGITALISATION · VERSION 1.7

Bulk email planning studio

Prepare student and staff email usernames from a spreadsheet before Google Workspace or Microsoft 365 is connected. Review duplicates and export a proposed roster for approval.

Review-first import. Excel and CSV are read locally in your browser. Nothing is saved unless you explicitly approve the fictional roster below. Saving a proposal stores it privately in this school’s Supabase database; it NEVER creates Google or Microsoft mailboxes. Use fictional records only during this pilot.

School selection

Open the secure school administrator dashboard and sign in first. This page can also be explored with fictional data while signed out.

01 / EMAIL DOMAIN

Choose the address format

Use a verified school-owned domain for eventual production. This pilot defaults to a reserved example domain. Keep the student_number column formatted as TEXT in Excel so leading zeros are not lost.

Students s232323@school.example.org

Teachers and staff first.lastname@school.example.org

A school domain must be verified and connected to its provider before mailboxes can be created. Choosing a preview domain does not verify ownership.

02 / SPREADSHEET IMPORT

Upload or generate a trial roster

Upload a CSV or ordinary .xlsx Excel file (maximum 3 MB). The first worksheet is used unless a sheet named Roster exists.

Required headings: person_type, student_number, first_name, last_name. Optional: email_local_part for transliteration or duplicate-name resolution.

03 / VALIDATION & REVIEW

Proposed email accounts

Total rows0
Ready for review0
Needs correction0

Select a fictional dataset or upload a roster to check names, student numbers and duplicate emails.

RowRoleStudent no.NameProposed emailValidation
No data loaded.
04 / CONTROLLED APPROVAL & SAVE

Save fictional proposals to the school workspace

This pilot permits saving fictional test rows only to a registered fictional school. The school administrator must be signed in and the entire roster must pass validation. Records are saved as planned, never as actual email accounts.

Privacy boundary: Do not upload real children’s details to this demonstration. For live schools, data-protection arrangements, role-based approvals and an authorised email-provider tenant must be established separately.

Saved proposals in selected school: Not checked. The action is repeat-safe: existing email proposals are not duplicated.

No records have been saved from this page.

05 / GOOGLE WORKSPACE READINESS

Provisioning is deliberately disabled

1
School identifies a real domain

TWJ verifies ownership using DNS. The domain is also verified within Google's administrator setup.

2
Google approves the institution

A qualifying school completes Google Workspace for Education eligibility checks and authorises technical administration.

3
School reviews the complete roster

The school approves account names, privacy permissions, organisational units and account policies before provisioning.

Open the Google Workspace setup & export studio

4
TWJ connects securely through Google's Admin API

Only authorised, appropriately scoped credentials may create users. This live integration has not yet been implemented.

No Google connection is active for Zimbabwe Excellence School. This application prepares planned accounts only; no button can create Gmail accounts.