Send Kudos from #kudos to Google Slide

[CherrelleTucker]

Description

We want to make it as easy as possible to recognize their team members. Investigate sending Kudos from the Kudos channel to a Google Slide, utilizing Google Apps Script and Slack Apps.

Examples or References

No response

Deliverable

• [ ] Comments sent to the most recently available Google Slide Presentation, Slide 5 Investigating formatting can come after it's proven that the initial attempt will work.

Implementation Considerations

Sprint review slides are generated on Fridays after a Sprint review. Kudos shouldnt begin to be added until the following day.

Starting action: comment is added to kudos channel. Bot collects comment Bot accesses Impact Sprint review folder: FY24 1_sfpauI_Py-iXARaSqyKCYHOCT_jP3Cy Recognize that files are titled YYYY-MM-DD and that YYYY-MM-DD is a date. Access the Google Slide presentation with title containing date closest to today. Add a shape Add the comment from the slack message to the shape.

Related Issues

No response

[CherrelleTucker]

Possible build option:

Start with a Slack Workflow

1. Emoji reaction in channel #kudos
2. Send to Sheet -- Variables available for transfer
   • Link to message that was reacted to
   • Link to the parent message
   • The channel where the reacted message is in
   • The reaction used
   • time workflow started
   • timestamp of the reacted message
   • user who reacted to the message
   • user who sent the message that was reacted to

This would be better if it could copy over the content of the message.

Sheet: Collect information

Google Apps Script

1. Collect information from Sheet
2. Access Slide Presentation
3. Add Shape
4. Add comment

[CherrelleTucker]

19

[CherrelleTucker]

Built without Slack workflow because copying the content of the message is a non-negotiable requirement.