Creating a Student Roster with Email Addresses from Aeries.Net
This will mix all of your students into a single roster but it will provide their email addresses.
This will make an Excel Spreadsheet that you can then upload to Google (or you can just copy and paste into a Google Sheet). You then will have all your students on one spreadsheet and can create rosters with that information.