📖 3 mins read

How to Add a User to Many or All Active Google Classrooms

 

Introduction

This post will outline the steps taken to add a Student/teacher or a co-teacher to many or all active classrooms. GAT+ facilitates this using the Flow tool.

 

Getting started

Launch GAT Flow and navigate to the ‘Create workflow‘ section.

GAT+ | Adding a Co-teacher/student(s) to All Active Google Classrooms 1

 

Adding a New Student to many or all classes

Step 1

The name given to this workflow for this example is ‘Adding new student to classrooms‘. ‘Onboarding’ workflow is used to initiate the process, once selected click next to proceed to choose the student to onboard.

GAT+ | Adding a Co-teacher/student(s) to All Active Google Classrooms 2

Step 2

Next, select the domain that you would like to take these actions. for this example, ‘gedudemobsn.com‘ is used.

Multiple parameters can be defined for the scope of the actions, below used are,

  • First Name’,
  • First letter of first name‘,
  • First letter of last name

After populating the fields accordingly, click to ‘Add new user‘ if additional students need to be onboarded and added to the intended classrooms. Otherwise ‘proceed to actions‘ to move onto ‘choosing actions‘ for the new student.

GAT+ | Adding a Co-teacher/student(s) to All Active Google Classrooms 3

Step 3

The next step is to configure the actions for the selected student, GAT flow offers many action sets that can be configured in the same workflow. for this example, the action set ‘Add user(s) as student to Google Classrooms‘ is used.

When selecting the action set it will pop up on the right side as shown below with the option to select all or many classes, whatever the case may be.

GAT+ | Adding a Co-teacher/student(s) to All Active Google Classrooms 4

When approval is requested the tool will take you to the Workflow section where a record of the previous workflows is presented with status updates. Once the ‘Security Officer‘ nominated for this role approves the request then the actions will be executed.

GAT+ | Adding a Co-teacher/student(s) to All Active Google Classrooms 5

Adding a new teacher as a Co-teacher to Google Classrooms

For adding a new teacher as a Co-teacher to Google classrooms repeat the steps above until you reach the action sets where you can select the option below and populate the field accordingly.

Add user (s) as a Co-teacher to existing Google Classrooms

 

Adding a C0 – Teacher to all Google Classrooms in Bulk

Another way of assigning a teacher to all Google classrooms in bulk is to take advantage of the import/export functionality of GAT+ tool.

To do this navigate to the Classroom section in the GAT+ too. Select all active classes and then export them to a spreadsheet as outlined below.

GAT+ | Adding a Co-teacher/student(s) to All Active Google Classrooms 6

GAT+ | Adding a Co-teacher/student(s) to All Active Google Classrooms 7

 

Once exported, Select the Column Teachers and add a new blank column to the right.

For every classroom add the new teacher account (this can be done as a bulk-paste action)
GAT+ | Adding a Co-teacher/student(s) to All Active Google Classrooms 8
In the example above, the Co-teacher user email is added in the new column created (J).
Now add a new column to the left of Teachers and into this add a join function in the first cell and copy down the column
GAT+ | Adding a Co-teacher/student(s) to All Active Google Classrooms 9
This is the join that should be added in the first cell (2)
=JOIN(“,”,J2:K2)
It will join the old Teachers column with the new and add a comma.
Next, the Join column needs to be turned into a string to import the new values back.
First, copy the column and then paste back again using ‘paste values only’
Click on ‘I‘ to select the whole column and then from the Dropdown arrow in the ‘I‘ cell select ‘Copy’.
Go back and select paste special, selecting Values Only.
GAT+ | Adding a Co-teacher/student(s) to All Active Google Classrooms 10
Select the New I column and call it TEACHERS, then remove the new J and K columns to get rid of the ones merged.
GAT+ | Adding a Co-teacher/student(s) to All Active Google Classrooms 11
Now import the spreadsheet again to update every ‘Teacher‘ cell for every class.
GAT+ | Adding a Co-teacher/student(s) to All Active Google Classrooms 12

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 trailed 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!