Uncover HN: Blueprint off Transactional Emails with SQL

SeekWell[1] honest added the flexibility to iterate over SQL results[2] and ship emails or Slack messages utilizing the data from every row. We’re utilizing it internally for transactional emails to potentialities that had been tricky to make in Intercom however easy to enact with SQL. Diversified spend cases may per chance well be issues look after:

– Triggering a Slack notification or Reports[3] for every row of a SQL consequence

– Assigning initiatives or sending data pushed messages to a community of internal potentialities / coworkers

– Sending an e-mail to a discipline of users that meet obvious criteria for your database or a Google Sheet

You’ve got fats protect an eye on over the HTML in the e-mail and can add data from the SQL row to the e-mail. You would also overview quick JavaScript snippets (e.g. conditional statements) sooner than the e-mail is rendered. The job may per chance well be scheduled to slither day to day, hourly or every 5 minutes and also you may per chance per chance well presumably add Triggers[4] that protect an eye on if the job runs (e.g. even as you happen to wished to quit the slither if but every other condition is met).

Let me know even as you happen to may per chance well need any questions! It’s doubtless you’ll well give it a proceed here[5].

[1] https://app.seekwell.io/

[2] https://www.notion.so/Vacation discipline-Lists-2bfd3807af62406f8eba2b2f68271e95

[3] https://www.notion.so/Reports-d4dcb303d28b400492741b5741fc2f86

[4] https://www.notion.so/Triggers-e4d9975bf79942948c115ade8788ec73

[5] https://app.seekwell.io/