I coded this! I hope this helps you to do many fun things with your class list!
- You need your roster in a spreadsheet.
- Student names in column B
- Student emails in column A
- Use the Extensions menu and select Roster Extras by Schoolytics.
- Show the sidebar.
Schoolytics
I created this Add-on as part of my work at Schoolytics. If you are a Google Classroom user you can use the EXPORT ROSTER option
Let's see what are some things you can do with your class list (roster.) We will use the Add-on Roster Extras by Schoolytics (coded by Alice Keeler) to create collaborative Google Slides, Create custom reports per student, Install Roster Extras: https://workspace.google.com/marketplace/app/roster_extras_by_schoolytics/825153074646 Use this sample class roster to try out the Add-on https://docs.google.com/spreadsheets/d/1oug8YKVujZ7eNOM1h1-l64eIc5bpA1YhmiVCFMrxAQE/copy