Exclusive first look – setup Google Classroom with this Google Sheets add-on

20 April 2017
Classroom Sync_1

I have been speaking with Blake Seufert from Naavi about the development of this add-on for a while now, and am glad it is now available to schools.

If you are using Google Classroom, you will enjoy this ad-on.  Blake has written the following how-to post, if you have any questions let Blake or the UTB team know.

Naavi Classroom Sync is here! A simple add-on for Google Sheets that can setup your classes in Google Classroom with one easy process. Whether you’re a teacher or school administrator, Naavi Classroom Sync can save you some serious time.

Let’s take a look at how it works:

Create a new Google Sheet and click the Add-ons menu > Get add-ons. Search for Naavi Classroom Sync and click the +Free button to install.

Once installed, it’s time to setup each class in our spreadsheet. Use the image below as a guide. In this example we’ve used a simple example of a teacher with 3 classes and a few students in each class.
Tip: To save even more time, you could copy and paste a list of students from your timetable or student management suite into the Google Sheet.


Classroom Sync_1

Note: If you’re the school domain administrator you can take your timetable export (import a CSV or Excel file into Google Sheets) and map the columns to pre-setup all student and staff classes in Google Classroom.

Naavi Classroom Sync let’s you create Google Classroom Classes from a class list in Google Sheets! Click To Tweet

Once you’ve entered all your data, simply press the Sync Courses button!
Check the log to make sure the sync completes without error. If successful, it should look like this:

Classroom Sync_2

You will also get an email confirming the sync has completed successfully or any errors that it encountered.

Now let’s take a look in Google Classroom and see what has been setup:

Classroom Sync_3

As you can see, the classes have been created and are ready for you to accept!

Note: You may notice the student count is at 0 as students are only ‘invited’ at this stage. Once they accept the invitation you will see the student count rise. Students will appear in the ‘Students’ section of the Classroom with ‘(invited)’ next to their name until they join. If you set up classes from a domain admin account, students will be forced to the class, skipping the invite process.

Classroom Sync_4

And that’s it! If you want to know more, check out http://classroomsync.naavi.com for a video walkthrough and template to help you get started!

Recent Posts

Here’s What
Our Clients Say

PR Industrya


In 2018, Using Technology Better designed and delivered a two phase post-migration training program for this New Zealand based graphic design firm. The initial goal of the training program was to reduce frustration with G Suite, with the long term aim of facilitating a change in culture and collaboration that can lead to transformative practices

Download your skills checklist to see how you score...


Choose Industry:

Which Skills Checklist?


Nice Move Allstar!
You're about to get
awesome value in your
inbox that's going to make
life that little bit easier & sweeter!


Pop in your details below and we'll send you the PLD Checklist 📧

First time applying for MoE Funded PLD?

Get the Latest Blog Posts, New Tips And Tricks


NSW DoE Leadership Webinars


NSW DoE Leadership Webinars


Holiday Rescue Maker Camp

Student to agree to and tick:
Guardian to agree to and tick: