I want to fetch all coursework currently due and insert it, formatted, into a Google Sheet. That means all coursework that has a due date in the future. I’ve never used the Google Classroom API. How would I do this in Apps Script? Thanks.

I want to fetch all coursework currently due and insert it, formatted, into a Google Sheet. That means all coursework that has a due date in the future. I’ve never used the Google Classroom API. How would I do this in Apps Script? Thanks.

I want to fetch all coursework currently due and insert it, formatted, into a Google Sheet. That means all coursework that has a due date in the future. I’ve never used the Google Classroom API. How would I do this in Apps Script? Thanks.

I want to fetch all coursework currently due and insert it, formatted, into a Google Sheet. That means all coursework that has a due date in the future. I’ve never used the Google Classroom API. How would I do this in Apps Script? Thanks.

I want to fetch all coursework currently due and insert it, formatted, into a Google Sheet. That means all coursework that has a due date in the future. I’ve never used the Google Classroom API. How would I do this in Apps Script? Thanks.

I want to fetch all coursework currently due and insert it, formatted, into a Google Sheet. That means all coursework that has a due date in the future. I’ve never used the Google Classroom API. How would I do this in Apps Script? Thanks.

Within a Classroom, an assignment has been created that contains a Sheet, which each student has a copy. I am trying to find a way, within the GAS bound to the sheet, to determine which Classroom course the Sheet was opened from.
The template Sheet that I am developing may be used in many Classrooms and by many students. I have got the file id from using the onOpen trigger: