[notifications] Notification dispatcher Cloud Function

[davidgamez]

Description

Scheduled function that evaluates subscriptions and sends a weekly email digest via Brevo.

After #1690 is completed, we can create sub-issues in this issue per notification type