How can I get HA to send me a list of events that happened overnight?

So I know this will be possible with HA but I just can’t work out how to get started. We’ve just started training our son to sleep without nappies and I’m interested in how many times during the night he gets up. I’ve already got a motion sensor which covers his route to the toilet so that gives me the answer but I was trying to work out how I can get HA to send me a notification in the morning with a list of the times that it was triggered between 2300 and 0600.

Is there a way to pull out the triggered events from the log and send them as a notification at 0700 every day?

Thanks!