Skip to main content
All CollectionsRosters & Student AccountsCSV Sync
CSV Sync for District Google Classroom Rosters
CSV Sync for District Google Classroom Rosters

How to import and sync rosters for use with Google single-sign-on (SSO) from a school or district level.

Grenard Madrigal avatar
Written by Grenard Madrigal
Updated over 4 months ago

RocketLit and InnerOrbit are able to let students login via Google as well as get rosters set up for all of your teachers. All that's required is that you or your tech team get us a CSV file with your roster data in it.

Steps in the Setup Process

  1. Create a CSV with roster data including teacher and student google email addresses - Find the exact format and which fields need to be unique below.
    ​
    ​

  2. Upload the CSV to our SFTP server - When you are ready with this file, let us know and we can send you an SFTP username and password.
    ​
    ​

  3. Let us Process and Test on our end - We want to make sure the CSV file looks okay and run some test roster syncs.
    ​
    ​

  4. Test Google SSO on your end - Once we use your CSV to load all the rosters into our system, we'd need you to test a few student and teacher accounts by logging into Google as them, then going to RocketLit or InnerOrbit and using our login with Google button.
    ​
    ​

  5. That's all - As student info changes, you can upload a new file and shoot us an email when it's been uploaded, or we can automatically run a file of the same name, nightly. It's up to you.
    ​

Details for Each Step

1. CSV

The fields that are needed are:

school_id, school_name,
​teacher_email, teacher_first_name, teacher_last_name,
​class_id, class_name,
student_first_name, student_last_name, student_email, student_grade_level
​
​

The ones that need to be unique are bolded.
​
​

Please limit the classes in the CSV to ONLY ones that will be using RocketLit or InnerOrbit. We'll be processing the entire file and since each student will count against the number of seats on your license, we don't want to have any extra data on there.
​


​2. SFTP

Once you're ready with your file, please email support@rocketlit.com so we can provide you with a username and password.
​
​

host: ftp://rocketlit.hostedftp.com

username: TBD

password: TBD
​
​
​4. Testing on Our End

This should take about a day for us.
​
​

5. Testing on Your End

You just need access to log into Google with student and teacher accounts, then click on our Google login button and see if it works. That button is located at https://www.rocketlit.com/login or https://www.innerorbit.com/login. We may want to take 5 minutes and do this over the phone in case there are any hiccups.
​

Roster Sync Sample CSV

You can also download the sample CSV for syncing rosters.
​


​
If you have any questions, please email support@rocketlit.com.

Did this answer your question?