Daily Summary E-Mail Workflow | All Un-Read in-app Notifications

Hello, I’m working on a feature to send each user a daily email summary with a list of all un-read notification records. Since ‘notificationInAppMessages’ is a hidden/ system data collection (and I would rather avoid making it visible) I am considering using a SQL node to retrieve these records. Has anyone tried to implement something like this? Would love to hear from your experiences before I go down the rabbit hole here. Thanks!

We have nocobase for our daily activities; we also use hosted open source n8n specifically jobs like this; check it out; very easy to create visual cron jobs and send emails

I think nocobase and n8n work well together

1 Like