School email overload, save from Gmail to Drive, AI daily Voice announcements based on the content?

My son has just started school and I’m struggling to stay on top of all the info. that comes in via email.

It would be useful to have a Sunday evening weekly AI announcement detailing what we have to sort that week. along with morning / evening reminders when I walk into the kitchen.

plan

  1. use Make.com to save all the school emails and attachments to Drive
  2. use an AI tool to create these briefings via Home assistant and trigger when I walk past my HA Voice preview edition.

I’ve kinda done the first bit, but it’s been a bit buggy in make.com TBH.

anyone have any ideas on how I can achieve the 2nd bit?

thanks

Neil