Does anyone use an automation tool to send dashboards into Slack?

[Dominique Koller]

We can't seem to find a good tool that would allow us to automate messages containing dashboard components from Jira dashboards into Slack. We have analyzed using Troopr but it just seems to basic. 

If you've been able to produce a more refined automation system (say from Jira to Google Sheets and from there to Slack) I'm also interested!!! 

The main objective is to send daily sprint updates into Slack, automatically. 

Would really appreciate anyone's help!!! Thank you.

[Rachel Wright]

Hi @Dominique Koller, I was looking for interesting older Jira questions and yours popped up! I've done something similar to what you're asking in a couple different ways:

Way 1: Using the built-in Jira Cloud automation rules

I'd need to know more about what data you're trying to report on, but for my use case, I wanted a list of all items and story points in the current sprint. I used the following settings:

• A "Scheduled" trigger to run the automation at the start of each work day.
• A "Lookup work items" action to find issues in open sprints in a specific Jira space using JQL.
• A "Send message" action to send info to Slack (or an "Edit work item" action to send info to a specific Jira item or a "Send email" action, etc.) 
  • A little snippet of code to display and format the information. I used:

h3. Items and story points in the current sprint
_As of {{now.convertToTimeZone("America/Denver").longDateTime}}_

*Item count:* {{lookupIssues.size}}
*Total story points:* {{lookupIssues.Story Points.sum}}

*Included items:*
{{#lookupIssues}}
* Story Points: {{Story Points.format("0")}}{{^last}} {{/}} {{key}}
{{/}}

Way 2: Using the free Katalon Studio app - https://katalon.com/

I'm not affiliated with Katalon - I just loved using their product for testing aspects of managing the Jira application! I once used this to automatically login to Jira and either scrape specific pages for specific info or take screenshots. Katalon can do this on any website, so I'd bet it could work for your Jira to Google Docs to Slack use case too. More info about taking screenshots is here: https://docs.katalon.com/katalon-studio/keywords/keyword-description-in-katalon-studio/web-ui-keywords/webui-take-screenshot You can also connect Katalon directly to Slack.

I hope something in here helps you get closer to a desired result!

Rachel Wright
Author, Jira Strategy Admin Workbook