Prevent employee burnout with AI analysis of Slack and tasks data to Google Sheets
Needs changesWhat this workflow does
This workflow has 20 nodes and runs on a schedule (every 2 hours). Along the way it connects Slack, Google Sheets and Postgres.
How it runs
Trigger: On a schedule (every 2 hours).
- Calculate Analysis Period (Code): runs custom JavaScript code
- Fetch Employee List (HTTP Request): calls an HTTP API
- Start Employee Loop (Loop Over Items (Split in Batches)): loops over the items in batches
- Fetch Slack Messages (Slack): work with search
- Generate Message Summary (Code): runs custom JavaScript code
- AI Tone Analysis (OpenAI): message
- Format Data for Privacy (Edit Fields (Set)): sets or maps fields
- Fetch Attendance Data (HTTP Request): calls an HTTP API
- Calculate Attendance Metrics (Code): runs custom JavaScript code
- Fetch Task Completion Rates (HTTP Request): calls an HTTP API
…plus 9 more steps. See the full node list below.
Services it uses
Before you upgrade to n8n 3.0
1 thing in this workflow is removed in n8n 3.0. Fix it before you upgrade:
- OpenAI (legacy) in AI Tone Analysis, AI Stress Level Prediction: replace with OpenAI node (AI section).
Rather not rewrite it? Many of these flows can be rebuilt in Make (free plan).
| Removed in 3.0 | Replace with |
|---|---|
| OpenAI (legacy) AI Tone Analysis, AI Stress Level Prediction | OpenAI node (AI section) |
Nodes used (10)
- Schedule Trigger
n8n-nodes-base.scheduleTrigger - Code
n8n-nodes-base.code - HTTP Request
n8n-nodes-base.httpRequest - Loop Over Items (Split in Batches)
n8n-nodes-base.splitInBatches - Slack
n8n-nodes-base.slack - OpenAI
n8n-nodes-base.openAi - Edit Fields (Set)
n8n-nodes-base.set - Google Sheets
n8n-nodes-base.googleSheets - If
n8n-nodes-base.if - Postgres
n8n-nodes-base.postgres
From the author
Monitor employee stress levels from Slack and tasks to Google Sheets This workflow functions as an automated "Chief Wellness Officer," helping HR teams and managers prevent employee burnout before it happens. It aggregates data from communication channels and…