Send open action items to users in a Slack Message

[CherrelleTucker]

Description

Non-tech savvy users are confused when looking at spreadsheets and don't want to take time to become oriented. To reduce their mental load, send open action items to them in a slack message.

Examples or References

Deliverable

• [x] Greeting message
• [x] Numbered list
• [x] Open Action Items
• [x] No duplicate items Items grouped by meeting (MO, SEP, Assessment HQ, DevSeed, AdHoc)

Implementation Considerations

Slackbots are only available in paid accounts. The majority of the actions are coded in Google Apps Script, then sent to Slack using an "Incoming webhook" URL. Each user will need their own copy of the Script and of the SlackBot. Previously attempted formatting shows that slack does not recognize italics, bold, underlined or hyperlinked text. Hyperlinks can be included and be active, but cannot be shortened (like this)

For the cleanest look, and to avoid user mental fatigue, links to source aren't recommended to be included at this time.

Related Issues

No response

[CherrelleTucker]

Items grouped by meeting (MO, SEP, Assessment HQ, DevSeed, AdHoc) removed as requirement unless requested as a feature in the future. Introduces complexities with formatting that aren't a priority at initial deployment.