Understand the mood of your team with Slack data
Build a mood dashboard using Slack data to track how your team is doing.
Use Zapier to collect posts from a Slack channel, run messages through a Peltarion model, and build a dashboard that shows the average mood. With this "positivity score" you can see how your employees’ communication tonality changes over time.
Now you’ll know when to initiate a team activity to cheer everyone up.
- Target audience: Beginner
- Estimated time: 20 minutes | Data collection ~2 weeks
- Tutorial type: Learn AI & platform
- Problem type: Text classification
You will learn
- Build a custom dataset using Slack.
- Create a dashboard with the predictions from your Peltarion models.
Set up your data collection from Slack
Create an account in Zapier and click on Create a zap.
"Create a custom Zap" (Open editor)
For your trigger step, select Slack followed by New Public Message Posted Anywhere.
Click Continue and connect the account and test the trigger.
Make a positivity prediction in Peltarion
Connect the flow to Peltarion by choosing the Peltarion app in Zapier.
Press Choose an event and select Prediction.
At this point, you can choose whether to build your own AI model or use one of our deployments for now.
If you want to use our deployment (based on the Movie review feelings tutorial), here is the information you’ll need for connecting the account.
Peltarion Deployment URL:
As Review input to the model, select Text.
Once the account has been connected using the information above, test the trigger.
Add a step to your Zap and select Formatter by Zapier and set Action Event to Date / Time
Set format values Input to Slack TS (you might need to search for TS).
Paste the following date string to the To Format field: YYYY-MM-DD HH:mm:ss
Select X in the To Format.
Test the step and make sure you get an output on the format above.
Collect data in Google Sheets
Create a spreadsheet somewhere in your Google Drive. Add the following headers:
Add a fourth step to your Zapier flow and select Google Sheets and your account.
Go back to Zapier and select action Create Spreadsheet row(s)
Set the Spreadsheet you just created and the active Worksheet.
Select data to import. To keep the actual messages unseen while generating an overall idea of the mood you can import:
The Timestamp, TS time, from Slack.
The Sentiment Class Probabilities Positive, from Peltarion Predictions to get the positivity prediction.
Now wait and collect information for some time (we needed just two weeks, as a lot of our work happens on Slack)
Create dashboard in Google sheets
When you’ve collected enough data, you should create a mood dashboard according to your needs.
If you want, you can copy anything you like from our mood dashboard in this Google sheet.
That’s it! You now have a way to get a better sense of how your employees are feeling through the tone in their communication, and you can therefore choose when to initiate a virtual office activity to cheer everyone up.
Want to play more with Zapier and Peltarion? Check out the tutorial Verify images with Zapier and Peltarion.