based on git template Classroom-to-Sheets - Integrate classroom details on Google Sheets ✅
The program is completely written from scratch.
Example report:
This script will have to run with the project owner as the person with the google classroom information.
OR
If you deploy it as a web app and the "run as the user option" is selected and the user accepts the permissions then anyone can use it.
See https://vanburen.brooklyncoop.org/google-classroom-history for an example of a deployed running application.
The only thing that should be changed is the SHARE_EMAIL constant and you can set it to a parent's email address and anyone one's email address.
Also this makes an assumption that homework is what we want to focus on.
It also assumes that homework has "hw" or "homework" etc. in the title or it is due early in the morning.
It is sad but apparently true that google classroom or may be the administrators in our test cases do not clearly distinguish homework from classwork.
Enjoy and feel free to modify, like, comment and subscribe!!!
As always, we look forward to see what you can build!!!
const SHARE_EMAIL="PARENT-OR-OTHER-EMAIL-HERE"; // e.g., "parent@gmail.com"
-
📚 Our son is using google classroom and we want to help organize the home projects.
-
🎓 Still, we need to add upcoming assignments and certain class details manually.
This script will have to run with the project owner as the person with the google classroom information.
OR
If you deploy it as a web app and run as the user option is selected and the user accepts the permissions then anyone can use it.
See https://vanburen.brooklyncoop.org/google-classroom-history for an example of a deployed running application.
The only thing that should be changed is the SHARE_EMAIL constant and you can set it to a parent's email address and anyone one's email address.
Also this makes an assumption that homework is what we want to focus on.
It also assumes that homework has "hw" or "homework" etc. in the title or it is due early in the morning.
It is sad but true that google classroom or may be the administratiors do not clearly distinguish homework from classwork.
Enjoy and feel free to modify, like, comment and subscribe!!!
As always, we look forward to see what you can build!!!
const SHARE_EMAIL="PARENT-OR-OTHER-EMAIL-HERE"; // e.g., "parent@gmail.com"
It is built using the:
Google Classroom API
Google Spreadsheet API
Google App Scripts
-
Create a New Google Sheet
-
In the Extensions Menu -> Select App Scripts
-
All the Details will be displayed with a single click!
- I used Google Cloud Classroom API, Google Spreadsheet API, and Google App Scripts to integrate the services and create this Hack!
- To host my repository ofcourse :)