I spent several frustrating hours trying to figure out an elegant solution to a #GAM problem.

I did not figure it out. I did a mind-numbing amount of copying and pasting instead.

But I still want to figure it out for next time, so if you know GAM, #GoogleAdmin, #edtech, #GoogleClassroom, #bash?... seeking hints.

-----

I want to add our students to their Google Classroom courses.

I have the students added to a group.

Attempt 1: Add the group email to the course as a student (in bulk via CSV). It works when an individual teacher does it, right? Failed.

Attempt 2: Sync the course participants with the group membership (in bulk via CSV). There's documentation that says this is a feature! But it's a lie. Failed.

I tried to convince GAM a couple different ways, but the only way I'm left with is to make one *monster* CSV, listing the students one by one for every course.

So. I've got a CSV of course alias, group email. I've got another CSV with student email, group email. I need to make a CSV with course alias, student email.

I know in my *bones* there was a way to create that obnoxiously long CSV that didn't involve nearly so much copy-paste. Do you know what it was?

💻 Controlla la visibilità dei banner di avviso in Gmail con un nuovo controllo amministrativo

#google
#googleworkspace
#aggiornamentigoogleworkspace
#googleworkspaceupdates
#googleadmin
#adminconsole
#gmail

@google
@googleworkspace
@googleforeducation

💻 Notifiche e-mail da Google ora disponibili nel Centro avvisi

👉 https://www.andrealamanna.com 👈

#google
#googleworkspace
#aggiornamentigoogleworkspace
#googleworkspaceupdates
#googleadmin
#notifichegoogle
#consoleadmin
#centroavvisigoogle
#centroavvisi

@google
@googleworkspace
@googleforeducation

💻 Notifiche e-mail da Google ora disponibili nel Centro avvisi

👉 https://www.andrealamanna.com 👈

#google
#googleworkspace
#aggiornamentigoogleworkspace
#googleworkspaceupdates
#googleadmin
#notifichegoogle
#consoleadmin
#centroavvisigoogle
#centroavvisi

@google
@googleworkspace
@googleforeducation

Google Enterprise License API https://mdfchicout.blogspot.com/2022/11/google-enterprise-license-api.html

#GoogleAdmin
#GoogleAppsScript
#GoogleEnterpriseLicenseAPI
#Java