I have a niche classifieds site that I’m putting together, and I’m not sure of the best practice to solve this problem. I need to send out a daily newsletter with a varying number of entries consisting of one row and three columns. I want to use Zapier as a scheduler to trigger an API workflow that runs a backend search on my Bubble database, pulls the relevant data, and embeds it into a Sendgrid template for delivery to my subscribers.
Does anyone have experience doing something similar? Would I find a service like Mailchimp to be more streamlined? Thanks in advance for any assistance!