n8n Team Morale Monitoring from Slack Messages with Gemini AI

This n8n workflow leverages Google Gemini AI to analyze team morale from Slack messages and provides a summary. It's designed to run on a schedule, process recent Slack messages, and then use AI to extract sentiment and key themes, which can then be used for further actions (e.g., reporting, alerts).

What it does

This workflow automates the following steps:

1. Triggers on a Schedule: The workflow starts at predefined intervals (e.g., daily, hourly).
2. Fetches Slack Messages: It retrieves messages from a specified Slack channel.
3. Processes Messages in Batches: Messages are processed in manageable chunks to avoid overwhelming the AI.
4. Analyzes with Google Gemini: Each batch of messages is sent to Google Gemini for sentiment analysis and to identify key morale indicators.
5. Aggregates Results: The individual AI analysis results are combined into a single output.
6. Prepares Data: The output from the AI is formatted and cleaned for further use.
7. Sends Summary to Slack: A summary of the team morale analysis is posted back to a designated Slack channel.

Prerequisites/Requirements

To use this workflow, you will need:

• n8n Instance: A running instance of n8n.
• Slack Account: With an app and bot token configured to read messages from a channel and post to a channel.
• Google Gemini API Key: An API key for Google Gemini (or a compatible LLM service configured in the Google Gemini node).

Setup/Usage

1. Import the Workflow:
   • Download the provided JSON file.
   • In your n8n instance, go to "Workflows" and click "New".
   • Click the three dots in the top right corner and select "Import from JSON".
   • Paste the workflow JSON content or upload the file.
2. Configure Credentials:
   • Slack: You will need to set up a Slack credential. This typically involves creating a Slack App, adding a Bot Token Scope (e.g., channels:history, chat:write), and installing the app to your workspace.
   • Google Gemini: Configure a Google Gemini credential with your API key.
3. Customize Nodes:
   • Schedule Trigger: Adjust the schedule to your desired frequency (e.g., every day, every hour).
   • Slack (Read Messages):
     • Select your Slack credential.
     • Specify the Channel ID from which to read messages.
     • Adjust the Limit and Lookback period as needed.
   • Google Gemini:
     • Select your Google Gemini credential.
     • Review the prompt to ensure it aligns with the type of morale analysis you want (e.g., "Analyze the sentiment of the following team messages and summarize the overall morale, highlighting any recurring themes or concerns: {{ $json.text }}").
   • Slack (Post Summary):
     • Select your Slack credential.
     • Specify the Channel ID where the morale summary should be posted.
     • Customize the Message field to present the AI's analysis clearly.
   • Edit Fields (Set) and Code: These nodes are used for data transformation and formatting. You may need to adjust them if the structure of your Slack messages or desired AI output changes.
4. Activate the Workflow: Once configured, activate the workflow to start monitoring team morale automatically.