Sending a well designed Slack alert is not only a good way to keep everyone in the loop, but also great to save the day when critical events happen in your data.
In Query.me Notebooks you can now base your Slack blocks on any amount of SQL-blocks, if statements and for loops, giving you complete control over when an Alert should be triggered and what it should contain.
How to use
1) Create or Edit the SQL-block in the Template: Unless you want to send multiple messages, your SQL should be a LIMIT 1. Every column returned by your query can become referenced data in your Slack message.
2) Create or Edit the IF statement in the Template. Reference the column and set a condition that should trigger blocks inside your statement. Feel free to combine IF and FOR, and also use more blocks, like Email, inside the statement.