Hi @PSterkenburg,
Instead of sending a notification (which would be very complex to set up), have you considered sending a recurring report on a weekly cadence instead? Share or export reports and dashboards
This has a much lower complexity, reduces notifications, is less prone to error overall.
Best regards!