topic Re: Sending Graphs & Tables to Slack in Workato Pros Discussion Board

Sending Graphs & Tables to Slack

jessica-lie — Fri, 15 Jan 2021 12:45:15 GMT

[Dec 9, 2020] Joe Blanchett (Product Manager, Finance Systems at Seat Geek) posted:

Hello Automation Pros,

Has anyone found a way to deliver aesthetically pleasing graphs or charts via Slack? We have a few use cases for this, but most of all I’d like to deliver a table or bar graph of outbound payments on a periodic basis.

Re: Sending Graphs & Tables to Slack

jessica-lie — Fri, 15 Jan 2021 12:46:01 GMT

[Dec 10, 2020] Gordon Hu from WeGalvanize replied:

Hi Joe,

Are these tables/charts in the form of a “file”? If so, there is a custom connector to send a file to someone /channel via slack.

Re: Sending Graphs & Tables to Slack

jessica-lie — Fri, 15 Jan 2021 12:47:28 GMT

[Dec 10, 2020] Chi Jie Wee (CSM at Workato) replied:

Hi Joe,

Workato has a charts connector to generate a bar/pie chart. It's fairly basic so I'm not sure if it meets the "aesthetics" requirement.

This connector returns a chart URL, which unfurls into an image when posted in Slack.

The other option would be using tools like Tableau to generate the dashboard images, then using Workato to download these images using their API, and uploading the image as a file in Slack.

Re: Sending Graphs & Tables to Slack

jessica-lie — Fri, 15 Jan 2021 12:47:48 GMT

[Dec 10, 2020] Gordon Hu from WeGalvanize replied:

Hmn…learned another new thing today 😊 Thank you Chi!

I think we need an automation to auto recommend steps.

Input: a brief description of business request
Output: automated workato sample recipes for you to customize

Re: Sending Graphs & Tables to Slack

jessica-lie — Fri, 15 Jan 2021 12:49:04 GMT

[Dec 10, 2020] Gordon Hu from WeGalvanize replied:

It worked!

https://app.workato.com/recipes/1369225?st=425189

Re: Sending Graphs & Tables to Slack

jessica-lie — Fri, 15 Jan 2021 12:49:54 GMT

[Dec 10, 2020] Joe Blanchett (Product Manager, Finance Systems at Seat Geek) replied:

Thanks CJ! I didn't know bar charts were available. I'll give that a try.

Re: Sending Graphs & Tables to Slack

jessica-lie — Fri, 15 Jan 2021 12:51:25 GMT

[Dec 10, 2020] Bennett Goh (Product Manager at Workato) replied:

Hi Joe,

Just adding on to CJ's point, we also use Plotly for charts sometimes. Its a free API that allows you to customize even more (though you might need to do some transformations). Things like line charts are simple enough to do over there and you get back a simple PNG you can use in downstream actions.

Re: Sending Graphs & Tables to Slack

jessica-lie — Fri, 15 Jan 2021 12:52:13 GMT

[Dec 10, 2020] Gordon Hu from WeGalvanize replied:

Hey pros,

I filed a support ticket to let Workato know the S3 links that host the chart are publicly accessible (and hosted indefinitely?). This could be a small concern if the chart has sensitive information. The team is on it. Look forward to their solution.