Import your students names from Google Classroom and insert them into any Google Sheet that contains the student email address.
Works with:
Tired of looking at student email addresses and not knowing their names? OTT-o-matic Student Name Import allows you to insert your students names into any sheet that already includes their emails (ie. results of a quiz using Google Forms).  There are two simple steps grab and add your students names:

Step 1 is to grab all of your students emails and names from your active Google Classrooms.
Step 2 is to insert a column next to their email address and add the students names.

Once you have inserted the students names, feel free to relocate the column as needed.  If you do modify the sheet and happen to break the formulas, or have new students enroll in the class, simply re-run the appropriate step. 
Additional information
PricingNot available
Trader status unspecified
Privacy policy
Terms of service
Student Name Import will ask for the permissions shown below. Learn more
Student Name Import will need access to your Google account
This will allow Student Name Import to :
See, edit, create, and delete all your Google Sheets spreadsheets
Display and run third-party web content in prompts and sidebars inside Google applications
See, edit, create, and permanently delete your Google Classroom classes
View the email addresses of people in your classes
View the profile photos of people in your classes
Manage your Google Classroom class rosters
See your primary Google Account email address
See your personal info, including any personal info you've made publicly available
Sort by:
Google doesn't verify reviews or ratings. Learn more about reviews
Profile Picture
Lena Szwedo
October 14, 2020
Would like to be able to do this on a class-by-class basis rather than all students in all googleclassrooms all at once.
Is this review helpful?
Profile Picture
A User of Student Name Import
March 16, 2020
Amazing! Would probably only use it once a year, though.
Is this review helpful?
1-2 of 2
Clear search
Close search
Google apps
Main menu