Task time analysis: Automated overspend time insights for ClickUp and more
Needs changesNeeds changes. This template uses 1 thing(s) that n8n 3.0 removes: AI Agent v1 (old agent modes). 1 breaking item(s) found. Static check, last run 2026-10-19.
What this workflow does
This AI workflow has 33 nodes and runs manually, when you click “Execute workflow”. Along the way it connects OpenAI Chat Model and ClickUp.
How it runs
Trigger: Manually, when you click “Execute workflow”.
- Get Clickup Tasks (ClickUp): get many
- Filter out unnecessary data from Tasks (Code): runs custom JavaScript code
- If: checks a condition and branches into true / false
- Fetch Time entries via task IDs (HTTP Request): calls an HTTP API
- Modify Task data (Code): runs custom JavaScript code
- Fetch Master comments (HTTP Request): calls an HTTP API
- Modify Time entries data (Code): runs custom JavaScript code
- Merge: merges the data from its input branches
- Loop Over Master comments (Loop Over Items (Split in Batches)): loops over the items in batches
- Generate Prompt with Time entires (Code): runs custom JavaScript code
…plus 17 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:
- AI Agent v1 (old agent modes) in Generate time insights (v1.9), Generate Reason checklist (v1.9): replace with Latest AI Agent node (Tools Agent). For SQL Agent, use a Postgres or MySQL tool with a recent AI Agent.
Rather not rewrite it? Many of these flows can be rebuilt in Make (free plan).
| Removed in 3.0 | Replace with |
|---|---|
| AI Agent v1 (old agent modes) Generate time insights (v1.9), Generate Reason checklist (v1.9) | Latest AI Agent node (Tools Agent). For SQL Agent, use a Postgres or MySQL tool with a recent AI Agent. |
Nodes used (12)
- Manual Trigger
n8n-nodes-base.manualTrigger - OpenAI Chat Model
@n8n/n8n-nodes-langchain.lmChatOpenAi - Simple Memory
@n8n/n8n-nodes-langchain.memoryBufferWindow - Convert to File
n8n-nodes-base.convertToFile - ClickUp
n8n-nodes-base.clickUp - HTTP Request
n8n-nodes-base.httpRequest - Code
n8n-nodes-base.code - If
n8n-nodes-base.if - Loop Over Items (Split in Batches)
n8n-nodes-base.splitInBatches - Merge
n8n-nodes-base.merge - No Operation, do nothing
n8n-nodes-base.noOp - AI Agent
@n8n/n8n-nodes-langchain.agent
From the author
This workflow automatically analyses tasks to uncover why the actual time spent exceeds the original estimates. It connects with ClickUp(Can do with any PMS like JIRA, Asana, Monday and more) and other project management tools to generate clear insights on…