Help & Support
Send Feedback
rosterSync - Teacher Edition
rosterSync - Teacher Edition allows teachers to sync a Google Classroom course roster with Google Sheets.
New Visions Cloudlab
124,503 users
Works with
rosterSync - Teacher Edition allows teachers to sync a Google Classroom course roster -- including student email addresses -- directly with Google Sheets for handy use with Add-ons like Doctopus, formMule, autoCrat, formRange, and others.


- Sync is to be run manually, from a friendly sidebar interface.

- Sync can be run in either direction: Classroom --> Sheet  -or-  Sheet --> Classroom.

- When run in Classroom --> Sheet mode, the Add-on inserts First Name, Last Name, Email Address, and Classroom Status columns into the sheet and populates the sheet with all active and invited students.  On subsequent syncs, new students are added and removed students are flagged. Formulas and formatting will usually be copied down when new students are added to the sheet from Classroom.

- When run in Sheet --> Classroom mode, the Add-on seeks to update (add/remove) the student roster in the Classroom section using email addresses in the Email Address column of the sheet.  A preview is provided before any such action is taken to avoid user mistakes!

- Multiple tabs (sheets) within the spreadsheet can be synced to the same and/or different section.

- Headers are designed to match those used in the English version of the Doctopus Add-on, to allow for relatively easy interoperability and syncing of rosters.


- Use to quickly pull a class list into a Sheet for use with any number of Add-ons that can leverage student name and email address to enhance personalization and teacher workflow:  Doctopus, autoCrat, formMule, formRanger, etc.

- Use to create informal record-keeping sheets that are always up-to-date with your Classroom section.
Use to bypass the enrollment code process by creating classroom invitations for a roster of students.
Kate Salute
January 7, 2020
I really just need to be able to get the guardian emails to sync and all it says under them is either "undefined" or is blank and then next to that it says "active" or is blank but there are no emails in the spreadsheet.
Submit reply
Wei Wang
October 9, 2017
It looks like a nice add-on but doesn't seem to work for me. I am a Classroom teacher. I added this add-on to a Google Sheet, launched it -- The add-on starts, but then stuck in a state with the "Getting course roster and guardian details from Google Classroom..." message.
Submit reply
Joey Lehrman
March 28, 2017
quick and easy to use, especially in the wake of the well known new classroom bug where you can't bulk invite students.
Submit reply
1-3 of 3
Additional information
Clear search
Close search
Google apps
Main menu