Google Classroom Notifications

[Teppei]

Hi. I use Google classroom at my school. And I often hear from my students that it’s hard to catch up with the latest information on each classrooms ( at my school they have at least 5-7 classes on Google classroom). 
I know they can get notifications or emails from Google classroom when they get a new post or tasks. 
I want to make an App which we can get the latest information on one screen ( in my image Gmail’s home function: they can check the latest info as a list)

I’m new to App Sheet, so I searched many websites but I couldn’t find any clues. So if you have any good ideas, I’m happy to hear that. 
thank you

[TeeSee1]

A quick thought...

3 Tables:

STUDENTS with ENUMLIST column, ref to CLASSES that lists the classes a student is taking

CLASSES (parent)

 CLASS NOTIFICATIONS (child)

   create a VC (ex. [class notification latest flag]) with the following expression

[class notification id]
=
MAXROW(
 "CLASS NOTIFICATIONS",
 "notification datetime",
 [ref to class] = [_THISROW].[ref to class]
)

Create a slice on CLASS NOTIFICATIONS that lists only the latest notifications of the classes that each student is taking

AND(
 IN(
  [ref to class], 
  LOOKUP(
   USEREMAIL(),
   "STUDENTS",
   "student email",
   "ENUMLIST ref to Classes"
  )
 ),
 [class notification latest flag] 
)