Send Mail Daily

I have an event table, I need to send an email to hosts of the event one day before the event starts with the event details and the list of attendees(This data I have in a separate table).
Is it possible to achieve this scenario?

Currently I am trying to do this via backend workflows, I am not able to figure out a way to filter the events table, get hosts and then send mail to those hosts.

Have a look at SendGrid, you can use dates in your database of the event - days(1) and have the email sent automatically. You do need a paid plan though

In the backend workflow, schedule an API workflow list to filter and email.
On the Schedule Date, get the Event Date, + Days - 1.

Hopefully that works for your use-case.

This topic was automatically closed after 70 days. New replies are no longer allowed.