Templates / Analyze workforce data and generate planning reports with GPT-4o

Analyze workforce data and generate planning reports with GPT-4o

Ready for 3.0

by Cheng Siong Chin ✓ · 87 views · created 2026-02-16 · HR, AI Summarization

Ready for 3.0. This template uses no nodes that n8n 3.0 removes. No removed nodes, versions or helpers found. Static check, last run 2026-10-19.

What this workflow does

This AI workflow has 22 nodes and runs on a schedule (every week at 09:00). Along the way it connects OpenAI Chat Model.

How it runs

Trigger: On a schedule (every week at 09:00).

  1. Workflow Configuration (Edit Fields (Set)): sets 4 fields: organizationName, criticalAttritionThreshold, capacityGapThreshold…
  2. Generate Mock Workforce Data (Code): runs custom JavaScript code
  3. Workforce Intelligence Agent (AI Agent): runs an AI agent, with model: OpenAI Model - Intelligence Agent; 2 tools (Capacity Forecasting Tool, Attrition Risk Calculator Tool); output parser: Intelligence Analysis Output Parser
  4. Aggregate: combines items into one
  5. Planning Orchestration Agent (AI Agent): runs an AI agent, with model: OpenAI Model - Planning Agent; 2 tools (Mobility Analysis Agent Tool, Executive Reporting Agent Tool); output parser: Planning Recommendations Output Parser
  6. Check Critical Workforce Signals (If): checks a condition and branches into true / false
  7. Format Final Workforce Report (Edit Fields (Set)): sets 7 fields: reportTitle, reportDate, organization…
  8. Flag for Human Review (Edit Fields (Set)): sets 4 fields: reviewRequired, reviewReason, reviewInstructions…
  9. Wait: pauses until webhook

Services it uses

OpenAI Chat Model

Before you upgrade to n8n 3.0

Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.

Nodes used (11)

From the author

How It Works This workflow automates workforce intelligence analysis and strategic planning for HR directors, workforce planners, and operations managers in enterprises managing distributed teams. It solves the challenge of transforming raw workforce data…

Excerpt from Cheng Siong Chin's description on n8n.io.

View the original on n8n.io → Check your own copy

Get the weekly “what broke” email

New templates, newly broken ones, and n8n release changes. One short email a week.

Form not loading? Subscribe here.