Using Google App Scripts in Google Sheets to Automate Your Gradebook

Here I create a Google Sheets document with grades from a fictitious class. I then create an App Scripts that runs through everyone's email address and emails them their grade.
Code location as of 11/21/2022
github.com/cmo...

[@arthurarmecin9760]

hi, what will I do if there is a one student who dont have an email. what should I do to skip that student ?

[@CarlosMontalvo251]

You'll have to add an if statement that checks to see if an email is valid. Another option is to put your email in the field and just have the code email you that way you'll know who doesn't have an email. Also what student doesn't have an email?

[@oussamalimayem-yx4qf]

Hi

[@oussamalimayem-yx4qf]

Can I have your email i want to help me in a programing problem in matlab

[@CarlosMontalvo251]

I cannot help individual viewers like this anymore.

[@MAYUMEGAMES]

Linke

[@CarlosMontalvo251]

github.com/cmontalvo251/BlackBox/blob/main/classroom/Google_Sheets_Automated_Email.gs

[@curtwaters6569]

p̴r̴o̴m̴o̴s̴m̴ 😞

[@CarlosMontalvo251]

Unfortunately your text did not come out right. This is what it looks like on my machine. "promosm"