Google Classroom, Google Sheets, Google Apps Script: Classroom API, SpreadsheetApp, map, forEach
At the date of writing this the world is in the midst of a worldwide pandemic – the Corona Virus.
For educators and their Igors administrators like me, it has been an incredibly busy couple of months.
Many of us have quickly sort to use online resources and tools to keep in contact with our students and take a crash course into the world of online teaching.
Google Classroom has become one of the darlings of the teaching world that has come out of this crisis. Its shallow learning curve and attractive UI made it an obvious choice for most educators. Oh, and I am sure the fact that it is free helped too.
For all of Google Classroom’s ease of use, I still feel the application is in its fledgling stages and does have a few limitations that, I’m sure, Google is constantly working on and improving.
One of the limitations is that you cannot simply upload grades from, say Google Sheets or another assessment tool. Well…not directly in the Google Classroom platform, yet.
However, you can still upload grades from an external source using Google Apps Script. You could use GAS to upload a whole courses grades from a Google Sheet. You could even use GAS to upload grades on a trigger from another assessment’s API into your Google Classroom.
In this tutorial, I am going to run you through the basics of uploading grades into Google Classroom using Google Apps Script with the Classroom API.
NOTE! This tutorial is for a wide audience. Feel free to read the post all the way through, or take what you need and get cracking!