Tag : googleclassroom

post image

List all Google Classroom Groups With Scripts


Sometimes it’s nice to check in and see who is using Google Classroom across your Google Apps organization.

The script (which was adapted from another blog here) will allow you to create a spreadsheet with a full list of classes taught by everyone in your organization.

It will also show you the:

  • -Teacher Name
  • -Creation Date
  • -Enroll Code
  • -Number of enrolled students

In order for the script to work properly, you’ll need to set up a few things:

  1. Visit Google Scripts 
  2. Under Resources, choose Advanced Google services
    Screenshot 2015-12-17 at 8.12.46 PM
  3. Turn on the Admin Directory API, Google Classroom API, and Drive API
    Screenshot 2015-12-17 at 8.14.19 PM
  4. Click the Google Developers Console link in the same dialog from step 3.
  5. Find and enable the Admin SDK, Drive API,  and Google Classroom API
    Screenshot 2015-12-17 at 8.18.10 PM
  6. Click the Run button to execute your code (the black triangular icon).
    Screenshot 2015-12-17 at 8.21.28 PM
  7. Now if you visit your Google Drive, you will have a new Sheets file named Google Classroom Listing / Count
    Screenshot 2015-12-17 at 8.25.33 PM
    (if you have a large number of teachers/classes, this file may take a few minutes to populate)

  8. You can rerun this script from script.google.com any time you would like to update the list of classes and/or the number of students in each class.
  9. Coming soon: View a list of the students in each class

The Code: