This is what I am aiming/hoping for.
The way I am seeing this (with my limited ability in Slack bot development + SQL + R + Connect combined), is a phased project.
step 1: have jobs on connect that run validations against data in a DB and send a text message to slack
step 2: have jobs on connect that run validations against data in a DB and send a text message to slack with a rmarkdown/pdf
step 3: Have slack bot that can be called from within a slack channel to query for available reports/shinyapps from connect
step 4: have an ability to check available shinyapps/markdowns, after user selects a desired one, have ability to display app/report parameters, collect and update the app/report and publish the report/app back in the slack channel.
Currently, I think I can get to 1 and 2 with the slackr package. However 3 and 4 are bit more involved for my current level of understanding to execute. would be happy to work with someone on Rstudio if you are interested.