Generate board-ready workforce analytics and talent reports with GPT-4o
Ready for 3.0Ready 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 18 nodes and runs on a schedule (every week at 06:00). Along the way it connects OpenAI Chat Model.
How it runs
Trigger: On a schedule (every week at 06:00).
- Load Employee Dataset (Data table): get
- Aggregate: combines items into one
- Build Skill Similarity Index (Code): runs custom JavaScript code
- Prepare Analytics Dataset (Code): runs custom JavaScript code
- Main Orchestrator Agent (AI Agent): runs an AI agent, with model: Orchestrator Chat Model; 2 tools (Talent Strategy Agent, Workforce Analytics Agent); output parser: Board Report JSON Schema
- Prepare Report Storage (Edit Fields (Set)): sets 7 fields: report_id, report_date, executive_summary…
- Store Workforce Report (Data table): uses Data table
- Optional Report Delivery (HTTP Request): calls an HTTP API (POST)
Services it uses
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 (12)
- Schedule Trigger
n8n-nodes-base.scheduleTrigger - Data table
n8n-nodes-base.dataTable - Aggregate
n8n-nodes-base.aggregate - Code
n8n-nodes-base.code - AI Agent
@n8n/n8n-nodes-langchain.agent - OpenAI Chat Model
@n8n/n8n-nodes-langchain.lmChatOpenAi - Structured Output Parser
@n8n/n8n-nodes-langchain.outputParserStructured - AI Agent Tool
@n8n/n8n-nodes-langchain.agentTool - Code Tool
@n8n/n8n-nodes-langchain.toolCode - Calculator
@n8n/n8n-nodes-langchain.toolCalculator - Edit Fields (Set)
n8n-nodes-base.set - HTTP Request
n8n-nodes-base.httpRequest
From the author
Intelligent workforce analytics and talent strategy report automation How It Works This workflow automates end-to-end workforce analytics and board-level talent strategy reporting using a multi-agent AI orchestration system. Designed for HR leaders, people…