Track employee performance KPIs from ClickUp with GPT-4.1 and Google Sheets
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 7 nodes and runs on a schedule (every day). Along the way it connects ClickUp, OpenAI and Google Sheets.
How it runs
Trigger: On a schedule (every day).
- Get many folders (ClickUp): get many (folder)
- Loop Over Items (Loop Over Items (Split in Batches)): loops over the items in batches
- Get many tasks (ClickUp): get many
- Message a model (OpenAI): uses OpenAI
- Code: runs custom JavaScript code
- Append or update row in sheet (Google Sheets): append or update
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 (6)
- Schedule Trigger
n8n-nodes-base.scheduleTrigger - ClickUp
n8n-nodes-base.clickUp - Loop Over Items (Split in Batches)
n8n-nodes-base.splitInBatches - OpenAI
@n8n/n8n-nodes-langchain.openAi - Code
n8n-nodes-base.code - Google Sheets
n8n-nodes-base.googleSheets
From the author
How it works This workflow runs on a schedule to collect task data from ClickUp and evaluate employee performance using AI. Tasks are analyzed to generate structured summaries, productivity metrics, and KPI scores. JavaScript logic refines and standardizes…