📖 4 mins read

 

With the powerful auditing functionalities of GAT+, Google Workspace Super Admins can create and update their Google Classrooms across their school district without difficulty.

Before we start make sure you have enabled Google Classroom APIs

 

Create new Google Classrooms

1. Enter the Classroom Audit area.

GAT+: How to Bulk Create, Export and Update Google Classrooms 1

2. Click on the Export data button which on the right-hand side of the page to export a Google Spreadsheet of all of the existing classrooms.

Use the Apply custom filter (funnel icon) button to filter for specific classrooms.

GAT+: How to Bulk Create, Export and Update Google Classrooms 2

3. When the exported Spreadsheet appears, click to view and find an empty row at the bottom of the existing data.

GAT+: How to Bulk Create, Export and Update Google Classrooms 3

Fill in the following fields:

  • Name (Name of Google Classroom) – Mandatory Field
  • Owner (Usually email of teacher) – Mandatory Field
    • You must enter only one email address in the Owner field.

Optional Fields:

  • Short Description
  • Section
  • Room
  • State (ACTIVE, ARCHIVED)
  • Aliases (start with :p or :d ) –  ( Alternative identifier for a course, so instead of course id (number) use and add alias. 
  • Teachers (separate emails with a comma)
  • Students (separate emails with a comma)

Important: DO NOT modify any of the RED colored background fields in the spreadsheet. Fields in GREEN background can be edited

  • Course_ID (when creating new classrooms, keep ID blank, if a classroom already has an ID do not modify it.) This field is handled automatically by GAT+.
  • It’s not necessary to create or modify the Created (date field). This field is handled automatically by GAT+.

GAT+: How to Bulk Create, Export and Update Google Classrooms 4

4. Once you have finished filling in the information for the new classroom close the Spreadsheet tab.

5. Then click on the Import data button, to add the data back and import it to Google Workspace (GAT+)

GAT+: How to Bulk Create, Export and Update Google Classrooms 5

 

6. When the correct Google Spreadsheet from the list is selected, click on the “eye” icon to open the Spreadsheet again.

Click on the “check-mark” to import the spreadsheet, details will be displayed

In the below example you can see the type of import is a CREATE action which means a new classroom will be created.

GAT+: How to Bulk Create, Export and Update Google Classrooms 6  

7. After you are happy with these details click on the Accept button.

When the operation is carried out you should see a message stating whether the operation was successful. The dialog box will appear at the top right corner of the screen.

GAT+: How to Bulk Create, Export and Update Google Classrooms 7

The classroom will be added and visible in GAT+.

GAT+: How to Bulk Create, Export and Update Google Classrooms 8

 

Update existing Classrooms

1. Apply a custom filter (funnel icon) and search for the classrooms you want to take action on. Use Search operators to find the classrooms you need to update.

GAT+: How to Bulk Create, Export and Update Google Classrooms 9

2. In the example above – Archived classrooms, created in the previous 2 months (excl current month)

3. Click Apply and the result will be displayed. 

GAT+: How to Bulk Create, Export and Update Google Classrooms 10

4. When the Spreadsheet is created, click to view

GAT+: How to Bulk Create, Export and Update Google Classrooms 11

5.  As in the example below. Edit any of the “allowed” fields as below.

In this case, changing the Name of one classroom, State to Active, and Short description, and adding additional Students.

GAT+: How to Bulk Create, Export and Update Google Classrooms 12

Important: DO NOT modify or edit the fields in RED, Fields with the Green background can be edited

  • Course_ID (when updating a classroom, keep the ID as it is) This field is handled automatically by GAT+.
  • Created (date field). This field is handled automatically by GAT+.

6. When the desired changes are made, close the spreadsheet tab.

7. Click on the Import data button and select the spreadsheet you were working on.

GAT+: How to Bulk Create, Export and Update Google Classrooms 13

8. Under the “Actions” select the “check-mark” button, confirm the before and after changes.

GAT+: How to Bulk Create, Export and Update Google Classrooms 14

Then click on the accept button.

Note: It might take some time for the changes to be carried out (depends on the volume of data).

When the changes have occurred, a Success message will be displayed.

GAT+: How to Bulk Create, Export and Update Google Classrooms 15

The data will be reflected in GAT+ right away.

GAT+: How to Bulk Create, Export and Update Google Classrooms 16

Examples of reasons to update Google Classrooms

  • At the end of the school year, you can ARCHIVE classrooms that are not going to be in use next year so to avoid confusing students.
  • Maybe the Description, Room, Student email addresses have to be modified because they were set up incorrectly by the teacher or classroom creator.
  • A teacher is out sick or on temporary leave and you need to add the new teacher to the Google Classroom.

Delete existing Classrooms

1. The steps to deleting a classroom are very similar to updating classrooms.

The only change you need to make is with the STATE field. Change the STATE field from ACTIVE/ARCHIVED to DELETED.

Find the classrooms, export into Google Spreadsheet or CSV, change the State.

GAT+: How to Bulk Create, Export and Update Google Classrooms 17

2. Change the State to DELETED

GAT+: How to Bulk Create, Export and Update Google Classrooms 18

3. Make sure to close the spreadsheet down and then click on the Import data button.

GAT+: How to Bulk Create, Export and Update Google Classrooms 19

4. Select the spreadsheet you were working on, confirm the changes done, and click on the Accept button.

GAT+: How to Bulk Create, Export and Update Google Classrooms 20

When the change is done, Data updated successfully message will be displayed.

GAT+: How to Bulk Create, Export and Update Google Classrooms 21

The data will be reflected in GAT+ right away.

GAT+: How to Bulk Create, Export and Update Google Classrooms 22

Important information about the Google Classroom States

When a classroom is Archived it is still available on the bottom left-hand side section of the Google Classroom website

GAT+: How to Bulk Create, Export and Update Google Classrooms 23

 

An archived classroom can be always restored. But if you delete a classroom it will be permanently removed.

GAT+: How to Bulk Create, Export and Update Google Classrooms 24

If you would like to run a trial of our products please install GAT+ from the Google Workspace Marketplace and contact us at support@gatlabs.com with any questions you may have.

To request a demo please click here and fill the form, we will get back to you in less than 12 hours during weekdays.

If you tried GAT in the past and you would like to run a fresh trial again, please enquire through this form.

Thanks for sharing and spreading the word!