The Scenario
Sprint retrospective is in two hours. An engineering manager needs to know how many tasks each developer completed in the last sprint — by name, completion date, and section — from an Asana project, pasted into the velocity tracker in Excel before the retro starts.
He inherited this task from the previous agile coach. There are no instructions. There is a spreadsheet. There is a retro scheduled.
The bad version:
- Open the Asana project, find the completed tasks view, try to filter by the sprint date range.
- Scroll through the completed task list, reading names and assignees. Type them into the velocity tracker.
- Realize halfway through that the Asana view is sorted by completion date and not by assignee, so you keep jumping around in the Excel sheet.
- Finish with numbers that add up to 43 completed tasks. The previous sprint tracker says 41 and 47. You're not sure if this sprint's number is right or if you missed some.
Velocity data is only useful if you trust it. A manual pull from a UI designed for task management rather than data export is not a trustworthy source.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your Excel workbook. It reads the project GID and sprint cutoff date from the workbook, pulls all completed tasks in the window, and writes them into your velocity tracker — clean, complete, and countable.
For each project GID in the Excel 'Projects' table, pull tasks completed in the last 14 days and write them into the 'Velocity' sheet with: project name, assignee, task name, completed_at date.
What You Get
- One row per completed task in the specified window, across all listed projects
- Columns: project name, assignee email, task name, completed_at date
- Subtasks excluded by default unless you ask for them — counts reflect story-level completions
- The "Velocity" worksheet is cleared before writing — no row stacking across runs
What If the Data Is Not Quite Ready
You want the count per assignee as a summary, not the raw task list
Fetch all completed tasks from Asana project [ID] completed after the date in cell B1 of this workbook. Write the raw task data (name, assignee, completion date, section) into the 'CompletedTasks' worksheet. Then write a per-assignee summary to the 'Velocity' worksheet showing task count for each person.
You want story points included if they are stored as a custom field
Pull all completed tasks from Asana project [ID] completed after the date in cell B1. For each task, write name, assignee, completion date, section, and the value of the custom field "Story Points" into the 'CompletedTasks' worksheet. Write 0 if no story point value is present.
You need to compare two sprints side by side in the same workbook
Fetch tasks completed in Asana project [ID] between the dates in cells B1 and B2 and write them into the 'Sprint1' worksheet (project name, assignee, task name, completed_at). Then fetch tasks completed between cells B3 and B4 and write them into the 'Sprint2' worksheet using the same columns.
Pull completed tasks, summarize by assignee, flag velocity outliers, and calculate team average in one prompt
Fetch all completed tasks from Asana project [ID] completed after the date in cell B1. Write raw task data to 'CompletedTasks'. In 'Velocity', write one row per assignee with task count. In column C of 'Velocity', write "Below Average" for any assignee whose count is more than 30% below the team average. Write the team average to cell D1.
One prompt that builds the retro data, the summary, and the outlier flag before the meeting starts.
Try It
Get the 7-day free trial of SheetXAI and open your velocity tracker workbook — ask SheetXAI to pull the last sprint's completed task data from Asana before the retro. You can also look at how to import sprint backlog hierarchy for the next sprint's planning, or return to the Asana hub for the full list of workflows.