Classright

Easily manage your Google Classroom……

  • Classright is a free Google sheet add on used by over 500K teachers to manage Google Classroom.
  • Bulk Create, List, Delete courses & bulk add, invite, list or delete students from Courses.
  • Use it right from your Google Sheets without a line of code to manage your Google Classrooms easily.
Classright - A Google Sheet Add-on to easily manage your Google Classroom
Play Video

Table of Contents

Classright - Installation by Admin (Optional)

  1. Go to your G Suite Admin Console.

  2. Click on “G Suite Marketplace”.
A. Go to G Suite Admin Console
  1. Search for Classright.

  2. Click on Classright to start installation.
B. Search for Classroom in G Suite marketplace

Click on “Domain Install”.

C. click on domain install

Google would inform you that Classright needs permission to run, click on “CONTINUE”

D. Click on Continue
  1. You can turn on Classright add-on for everyone OR only for users in given Organizational Units.

  2. Accept Classright’s terms of service and privacy policy, once/if satisfied, checkmark it.

  3. Click on ALLOW
E. Allow Classright access to your domain users

Classright has now been installed in your domain. You can verify it as following:

  1. Go to G Suite Admin console and click on “Apps”.

  2. Go to G Suite marketplace apps
F. Go to G Suit marketplace apps

You should see Classright listed here with the status “On for everyone” OR one for some.

F. You would see Classright listed now

Classright - Installation by User / Teacher

  1. To find and install Classright, either create a new Google sheet, or open an existing one.

  2. Go to Add on, and click on Get add-ons as shown in the screenshot below.
1. Install a new Google sheet add on

Search for “Classright” in the sheet add-ons gallery.

2. Search for Classright in the sheets add on gallery

Click on install button to start the Classright add-on installation.

3. Click on Install

Google would inform you that Classright add on would need permission, click on CONTINUE button.

4. Click on Continue

Select the G Suite account with which you want to use Classright.

5. Select the user that you want to install Classroom sheet add on for

Google would now show you the permission Classright add-on needs.

You can click on the exclamation mark to read more about the permissions required.

Once/if satisfy, click on “Allow” button to grant permission to Classright to manage your Google Classroom.

6. Click on Allow to give Classright access to your Google sheet and classroom

Google would now show that Classright add on has been installed.

Click on NEXT button.

7. Click next

Here you may click on the link to or directly go to goldyarora.com/classright for add-on setup and user documentation.

8. click on done to finish Classright installation

As the Classright add-on is now installed, you can close this window.

9. Click on X to close the window

Classright - Sheets Setup

Now, as the Classright add-on has been installed, let us start with inserting the sheets which it needs to work, each sheet is dedicated to one function (e.g create courses).

  1. Go to Add-ons
  2. Click on Classright
  3. Click on Setup Wizard
  4. Click on Create Sheets
10. Click on Create sheets to insert Classright sheets

You would notice, that the add-on has inserted a few sheet tabs as shown in the screenshot.

You would use each of these tab for a specific Classright functionality (e.g Invite Students)

11. Classright sheets would be added to your google sheet

Classright - Create Courses

  • To create Courses (Classes), go to the sheet tab called 1.1 Create Courses.

  • Enter the details for your courses (course name and classroom owner email are required), rest of the details are optional.

  • If you would be the owner of these courses, you can simply put “me” in the classroom owner email column, but if you want someone else to own the course, then type their full email address.
12. enter details to create google classes
  1. Go to Add-ons
  2. Click on Classright
  3. Click on Courses Manager
  4. Click on 1.1 Create Courses
13. Click on create courses from Classright menu

You would notice that the script started working.

14. Classright script would start running

Your courses would be created, and would output-:

(i) Course Creation Status

(ii) Enrollment Code

(iii) Course IDs

15. Courses would be created

Classright - List Courses

Go to sheet tab called 1.2 List Courses to list all of your courses along with their details.

16. Go to List Courses google sheet
  1. Go to Add-ons
  2. Click on Classright
  3. Click on Courses Manager
  4. Click on 1.2 List Courses
17. Click on List Courses from Classright add on menu
  1. Now all of your Courses would be listed in your sheet tab “1.2 List Courses” with their details like Enrollment Code, Course link, course status etc.

  2. Note -: Courses that you do not own, would not be listed here.
18. You will see all google classrooms listed now

Classright - Archive Courses

Go to 1.3 Archive Courses sheet tab, and enter the course Ids of the courses that you want to archive.

Note -: You can also use “List Courses” function above to get list of all your courses along with their ids.

19. go to archive courses sheet and enter courseids
  1. Go to Add-ons
  2. Click on Classright
  3. Click on Courses Manager
  4. Click on 1.1 Archive Courses
20. Click on Archive courses from the Classright add on menu

Classright add-on would now report the status “Course Archived Successfully” in your sheet as shown in the screenshot.

21. Google Classes would be archived
  1. Go to your Google Classroom (classroom.google.com)

  2. Click on “Archived Classes” from the hamburger menu, and you would see the classes you just archived via Classright.
22. Archived Google classroom courses

Classright - Delete Courses

  1. To delete the courses, go to “1.4 Delete Courses” sheet tab.

  2. Enter the course Id of the courses that you want to delete.

Note -: You can also use “List Courses” function above to get list of all your courses along with their ids.

23. Go to delete courses sheet and add courseids
  1. Go to Add-ons
  2. Click on Classright
  3. Click on Courses Manager
  4. Click on 1.4 Delete Courses
24. Click on delete courses from Classright menu

You would now see the status message “Course Deleted Successfully” for the courses that Classright deleted for you.

25. Google classroom courses would be deleted

Classright - Invite Students

  1. To invite students (in bulk) to your courses, go to sheet tab “2.1 Invite Students”.
  2. Add required details (CourseID, student email, and role).

Notes-:

  • You can send invite to
    (i) Students to join classes.
    (ii) Teachers to collaborate on our courses.
    (iii) Owners – to assign an owner to existing courses.

  • Please ensure to put the role name STUDENT, TEACHER, OWNER in capital letters as shown in the screenshot below.
26. Go to invite students sheet and add details
  1. Go to Add-ons
  2. Click on Classright
  3. Click on Courses Manager
  4. Click on 2.1 Invite Students
27. Click on invite students from Classright add on menu

Classright would show you the confirmation that it has sent the invites successfully.

27.1. Students would be invited

Classright - Add Students (Admins Only)

You should be able to verify it by going to your respective course and click on “People” tab as shown in the screenshot below.

27.2. Students would be invited

If you are a G Suite Administrator, you can also directly add students to the courses instead of inviting and then waiting for them to accept invites.

  1. Go to the sheet tab “2.2 Add Students (Admin Only).
  2. Enter Course Id and student email in the sheet.

Notes:

  • You would need to add courseId in front of each student email even if you are adding all students to the same course.

  • You can also use “List Courses” function above to list all your courses along with their course ids.
28. go to add students courses
  1. Go to Add-ons
  2. Click on Classright
  3. Click on Courses Manager
  4. Click on 2.2 Add Students
29. Click on Add students from Classright add on menu

If you are not a G Suite Administrator, you would see an error stating you do not have permission to add students to courses.

For non G suite Admin users, inviting users should be considered.

30. You would get the error if you do not have G Suite admin role

If you are a G Suite Admin, you would see the success message “Student Added Successfully”.

31. Students would be added successfully

Classright - List Students by Course Ids

You can also list students in different courses with Classright add-on.

  1. To list students by courses, go to sheet tab “2.3 List Students by Course”.

  2. Enter the Course Ids of the courses for which you want to list students.
32. Go to list students by course sheet and enter courseid
  1. Go to Add-ons
  2. Click on Classright
  3. Click on Courses Manager
  4. Click on 2.3 List Students by Couse
33. Click on List Students by courses from Classright menu

Classright would export all the students (with name and email address) in the courses you asked for.

33.1 students in asked courses would be listed

Classright - List Students in All Courses

Instead of listing the students by course Ids, Classright can also list your students regardless of which course/s they belong to.

  1. Go to Add-ons
  2. Click on Classright
  3. Click on Courses Manager
  4. Click on 2.4 List Students in All Courses
34. Click on list students in all courses from classright menu

You would see all the students in your different courses listed.

Note : It would only list students who are enrolled in any of “your” classes.

34.1 all students with their courses would be listed

Classright - Delete Students from Courses

Classright add-on can also help you bulk delete students from courses.

  1. Go to sheet tab “2.5 Delete Students from Courses”

  2. Enter the Course Id and student email address.

Note -: You would need to write courseId in front of all student emails (as shown in the screenshot below) even if you are deleting students from the same course.

35. go to delete students sheet and enter students details
  1. Go to Add-ons
  2. Click on Classright
  3. Click on Courses Manager
  4. Click on 2.5 Delete Students from Courses
36. go to delete students from classright menu

Classroom would delete the students and show you the status as “Student Deleted Successfully”

37. students would be deleted from courses

Classright FAQ

Most frequent questions and answers about Classright

If you see Classright in your add-ons after installation, however if it greyed out then it means your G Suite Administrator has not allowed users to install and use add-ons.

Your G Suite Admin should to go following path to check and enable add-ons-:

G Suite Control Panel –> Apps –> G Suite –> Drive and Docs –> Features and Applications –> Allow users to install Google Docs add-ons from add-ons store.

Classes and Courses are same in Google Classroom.

There can be a few reasons you can not access Google Classrooms, here are a few-:

  1. Your G Suite Administrator has not provided Google classroom access to you.
  2. You are on a Google subscription which does not include Google classroom product (e.g Drive Enterprise SKU).

I initially wanted to name it “Classroom Manager”, but that name wasn’t available, one of my buddies (Dave Abouav) suggested Classright, and I loved it too.

  • When you read my blog, and/or use my services like this labels manager for Gmail add-on, you trust me with your information.
  • My Privacy Policy is meant to help you understand what data I collect, why I collect, and what I do with it.
  • This is important, I hope you will take time to read it carefully. And remember, you can always contact me on the details provided at bottom of this page for any questions about protecting your privacy and security at my Website.
  • You can read the privacy policy here -:  https://www.goldyarora.com/privacy/

RECOMMENDED READING

As you just read Classright – A Google Sheet Add-on to easily manage Google Classroom, I would recommend following as complimentary reading.
Google Meet Attendance Tracker
AdminMeetTools & Scripts

Google Meet Attendance Reporter – Self Service Solution

Read More →
G Suite to Office 365 SSO & Provisioning Guide
AdminG SuiteSecuritySSO

G Suite to Office 365 SSO and Provisioning Guide

Read More →
The Definitive Guide to Google Vault
AdminG SuiteGoogle VaultSecurity

THE DEFINITIVE GUIDE TO GOOGLE VAULT

Read More →
Scroll to Top