New Visions Cloudlab
•  341,681
rosterSync - Teacher Edition allows teachers to sync a Google Classroom course roster with Google Sheets.
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.
Sort by:
Stephen Mosley
March 6, 2020
Tried to use but get error saying: "Sign in with Google temporarily disabled for this app This app has not been verified yet by Google in order to use Google Sign In."
Is this review helpful?
Chris Merkert
April 2, 2020
This used to be great. New Visions, Cloud Lab, A. Stillman all worked excellent. But it is not verified and cannot work as mentioned. Any status update? This was one of the best tools to use for mail merges, Hapara set up, etc. Now it's dead in the water. Please get it verified and update us all.
Fred Masuoka
March 13, 2020
I also get the same message. I have been using this add-on for two years now and it does work it is unfortunate that the developer made it a "legacy add-on'. I have contacted them and got a standard answer but have not received any more replies with an answer if they will get it verified. So I would give the add-on 4 stars but the Developer 1/2 star so overall a 2 stars. I will not use New Visions other add-ons because I would be concerned they will also stop working.
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.
Is this review helpful?
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.
Is this review helpful?
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.
Is this review helpful?
1-4 of 4
Additional information
New Visions Cloudlab
Terms of Service
Clear search
Close search
Google apps
Main menu