Task time analysis: Automated overspend time insights for ClickUp and more

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 overspending trends. Save time, improve planning accuracy, and boost team productivity with automated task time analysis with two types of reports.

- “Why needed extra time?” – Reasons users requested extensions or faced blockers.

- “Why went over estimate?” – Reasons the actual work exceeded the original estimation.

🔧 Workflow Overview

1. Manual Trigger Kick off execution by clicking “Test workflow”.

2. Fetch Relevant Tasks Calls ClickUp to retrieve all tasks in specified states (“internal review” or “in progress”) that belong to designated folders and assignees.

3. Filter by Overrun Filters tasks to include only those where timespent > timeestimate.

4. Gather Details For each overrun task: - Fetch time entries via ClickUp API. - Fetch all comments, including threaded replies. - Retain only essential task fields and reformat timestamps.