Alert for failed query

I would like to get an alert in Slack whenever a scheduled query has failed for a number of subsequent times (or alternatively, hasn’t run for x amount of time). Is there a way to do this? Can’t find anything in de docs or in the alert settings.

There is work in progress on an email report:

Once this is done, it should be easy to add an option to report into Slack.