Email guests that have accepted my calendar invitation 7 days before meeting start


I am a newbie to, not a developer, and not an API guy.
I’m trying to find out if it’s possible to do what I want, and maybe a few pointers on how to do that:

Apps: Google Calendar & Gmail

Use case:
I would like that 1 week before any meeting starts, that all the guests that have “accepted” (Attendee Response Status = accepted) the meeting, would receive a meeting reminder containing the Date and time of the meeting and the meeting url (zoom link)
I don’t want to email any “tentative” “declined” or “NeedsAction” status guests, just the ones that have accepted.

can you point me in the right direction, please?

The way I’m seeing it is the following:
Check all events with start date = today +7days
get all emails, guest statuses, meeting link
Filter and disregard any statuses not equal to accepted
Only send email to the guests that “accepted”

later edit:
tried doing the first step, getting events starting 7 days from now using {{addDays(now; 7)}}

Message below the function window is “Also processes events starting before the specified start date and overlapping with this date.”, and I’m getting results 5 years back.