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.

Person - Target audience: Beginner
Clock - Estimated time: 20 minutes | Data collection ~2 weeks

You will learn
Peltarion logo - Build a custom dataset using Slack.
Peltarion logo - Create a dashboard with the predictions from your Peltarion models.

Mood tutorial flow. Set trigger
Mood tutorial flow. Set trigger
Figure 1. Use Zapier to collect posts from a Slack channel, run messages through a Peltarion model, and build a dashboard that shows the average mood.

Set up your data collection from Slack

  1. Create an account in Zapier and click on Make a zap.

  2. For your trigger step, select Slack followed by New public message posted anywhere.

  3. Connect the account and test the trigger.


Make a positivity prediction in Peltarion

  1. Connect the flow to Peltarion by choosing the Peltarion app in Zapier.

  2. Press Choose an event and select Prediction.

  3. At this point, you can choose whether to build your own AI model or use one of our deployments for now.

Sign in to Peltarion button
  1. 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:
      https://a.azure-eu-west.platform.peltarion.com/deployment/48b898d0-9c52-4894-a802-287f5bffd1aa/forward

    • Token:
      61778919-19fb-433d-9e06-c20a461f9fc4

  2. As Review input to the model, select Text.

  3. Once the account has been connected using the information above, test the trigger.

Test and continue button

Extract timestamp

  1. Add a step to your Zap and select Formatter by Zapier and set Action Event to Date / Time

  2. Set format values Input to Slack TS (you might need to search for TS).

  3. Paste the following date string to the To Format field: YYYY-MM-DD HH:mm:ss

  4. Select X in the To Format.

  5. Test the step and make sure you get an output on the format above.


Collect data in Google Sheets

  1. Create a spreadsheet somewhere in your Google Drive. Add the following headers:

    • Timestamp

    • Peltarion Prediction

  2. Add a fourth step to your Zapier flow and select Google Sheets and your account.

  3. Go back to Zapier and select action Create Spreadsheet row(s)

  4. 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.

  5. Now wait and collect information for some time ClockClockClockClock (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.

Peltarion mood dashboards

Final words

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.

Was this page helpful?
YesNo