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.
School selection
Open the secure school administrator dashboard and sign in first. This page can also be explored with fictional data while signed out.
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.
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.
Proposed email accounts
Select a fictional dataset or upload a roster to check names, student numbers and duplicate emails.
| Row | Role | Student no. | Name | Proposed email | Validation |
|---|---|---|---|---|---|
| No data loaded. | |||||
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.
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.
Provisioning is deliberately disabled
TWJ verifies ownership using DNS. The domain is also verified within Google's administrator setup.
A qualifying school completes Google Workspace for Education eligibility checks and authorises technical administration.
The school approves account names, privacy permissions, organisational units and account policies before provisioning.
Open the Google Workspace setup & export studio
Only authorised, appropriately scoped credentials may create users. This live integration has not yet been implemented.