Weekly summary of "Done" items+subitems via API (To Slack)?

I’d need a solution to send a weekly summary of all the items+subitems with “Done” status to a certain channel in Slack :face_with_peeking_eye:

The basic Slack integration only supports item status (no subitems…) and the nature of the automation is kinda flooding the Slack channel (every Done status sends the message), as there’s no way to “summarize” the statuses. So, I though if the API could be the solution here :slight_smile: I could be terribly wrong, but please bare with me.

Is there something like that already available/examples somewhere?

You could definitely do this! You’d need to build an integration recipe template with a custom action to send a message in Slack. We have an “Every time period” trigger so you can configure it to run every week.

You should start by building a simple integration recipe template and then develop from there. Here’s what I recommend:

  1. Build a simple integration with our quickstart guide - Follow this tutorial to build a simple integration template with a custom action. You’ll be building the recipe “When a column changes, capitalize text”. It will give you some basic code to start connecting with the monday integration framework.

  2. Connect your custom action to the Slack API - We have an example Slack app here that you can get tips from, although it’s pretty outdated so your mileage may vary.

Hope that helps.

@olli.raatikainen if an add-on is an option, I suggest taking a look at the Analytics & Reports by Screenful. With it, you can easily create reports (also from subitems) and schedule them to be sent to Slack.