📖 2 mins read

With GAT+ admin can update all Google Classroom Guardians to the students in bulk.

This can be achieved using Export – extract a list of students and Import – adding students back to GSuite (using GAT+)  with updated Guardians

Start

Open GAT+ and then click on the Classroom audit.

GAT+ | Add and Update Google Classroom Guardians in Bulk 1

From the menu on the top select the Students tab

GAT+ | Add and Update Google Classroom Guardians in Bulk 2

Note: To get the freshest data click on the play button to run extras scan for Classwork, Classwork submissions and Guardians.

Filter

Apply filter to find all students, whose Guardians have to be added, replaced, or removed.

GAT+ | Add and Update Google Classroom Guardians in Bulk 3

As an example search

  • Click on the “apply custom filter” button
  • Select Guardians = is empty
  • Click on Apply 

This will give us a list of all students that have no Guardians added to their accounts. Alternatively, find accounts that have Guardians that need to be updated or removed.

When you find the Students you want to update, export the data.

Export

When the result is displayed Export the data into Google Spreadsheet or CSV

GAT+ | Add and Update Google Classroom Guardians in Bulk 4

Add Guardians

Add new, update existing, and remove guardians in the spreadsheet/CSV document

GAT+ | Add and Update Google Classroom Guardians in Bulk 5

The Guardians field will be in green colored, the data on this field can be changed.

  • Add – add a guardian to the student
  • Replace –  existing guardian, removing the old one, and adding new on its place
  • Remove – remove an existing guardian
  • Multiple -add two or more guardians to one student, separated by a comma

When done with changes, close the spreadsheet this will “auto-save” the changes.

Import

Click on the import button select the last spreadsheet and click on the check-mark button

GAT+ | Add and Update Google Classroom Guardians in Bulk 6

Click on the “eye” icon to open the spreadsheet again.

A new window will be displayed, view the changes that will happen.

Guardians before (none)  and after (email addresses)

GAT+ | Add and Update Google Classroom Guardians in Bulk 7

Click on Accept to import the changes

The Guardians will be shown for each of the Students. The Status for each of them will be pending, when accepted (pending message will disappear).

GAT+ | Add and Update Google Classroom Guardians in Bulk 8

Result

The Guardians (email ) will receive an email notification from Google Classroom.

Note: The email will be sent from “randomly” selected admin of the domain. If admin who request this job is Dave, the Guardian invitation email could be “sent” by Joe who is also admin of this domain.

GAT+ | Add and Update Google Classroom Guardians in Bulk 9

When the Guardian invitation is accepted, the changes will be reflected in the GAT+ Classroom audit, as a new scan will be automatically requested.

 

If you would like to run a trial of our products please install GAT+ from the G Suite 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!