Automatic Attendance List for Classroom

Hello Everyone,

I am trying to build a scenario that triggers when an app like telegram receives a message from the teacher saying who were the students that attended the class. For example: “These are the students that attended the class: John, Mary, Elizabeth etc”. I would like that the names of the students to be extract and then filled in a google sheet that will be the attendance control.

My idea was a simple excel sheet, where each student would be a line and the columns would be the date of the class.

I also need this sheet to be able to send me a report of the attendance control of each student on the last 12 months for example numbers and percentage.

Can someone give some direction how to build something like this?

My best regards

1 Like

For the first thing you want to do, you basically need to set up a scenario that iterates through the list of students in that specific class then match them with the ones sent on the telegram group.

After that, you can easily pull the student attendance data from the sheet and send it to your self.

Hi @Arthur_Monteiro

You can do this using Make.com by setting up a scenario that starts when a message comes in from Telegram. The message will be something like “These are the students that attended the class: John, Mary, Elizabeth…” and you can use a tool like ChatGPT or a text parser to pull out just the student names. Then, connect Google Sheets where each student has a row and each date is a column, and mark attendance for the day. You can also set up a summary sheet or use formulas to calculate each student’s attendance over the last 12 months and even send yourself a report.

Best regards,
Msquare Automation
Platinum Partner of Make
@Msquare_Automation

2 Likes