The Scenario
Sprint retrospective is tomorrow. The agile coach needs to know how many tasks each developer completed in the last two sprints — task name, assignee, completion date, section — pulled from the Asana project and pasted into the velocity tracker in Excel.
A new engineer joined three months ago and nobody's sure if his numbers look right compared to the rest of the team. The coach needs the data before the retro so she can look at it without it feeling like an accusation during the meeting.
The bad version:
- Open the Asana project, filter by "completed," set the date range for the last two sprints, hope the filter actually works.
- Export if there's an export option. If not, scroll through the completed task list, reading names, assignees, and dates, typing them into the velocity tracker one by one.
- Realize you filtered to the wrong project and have to start over.
- End up with numbers that might be right but you're not fully sure because completed task views in Asana aren't always easy to read once you've scrolled past a certain point.
Velocity data is only useful if it's accurate and complete. A manual pull from a UI that doesn't make it easy to verify completeness isn't a reliable foundation for a retro conversation.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your Google Sheet. It reads the project GID and date threshold from your sheet, pulls all completed tasks, and writes them into your velocity tracker — no UI scrolling, no manual entry.
Fetch all completed tasks from Asana project [ID] completed after the date in cell B1, and write task name, assignee, completion date, and section into this sheet.
What You Get
- One row per completed task, filtered to only those completed after the date in cell B1
- Columns: task name, assignee email, completed_at date, section name
- Subtasks are excluded by default unless you ask for them — so the numbers reflect story-level completions
What If the Data Is Not Quite Ready
You need to pull from multiple projects for a cross-team velocity view
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.
You want the count per assignee as a summary, not just the raw task list
Fetch all completed tasks from Asana project [ID] completed after the date in cell B1. Write the raw task data (name, assignee, completion date, section) into the 'CompletedTasks' sheet. Then write a summary to the 'Velocity' sheet showing each assignee's count of completed tasks.
You want to include story points if they're stored in 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 this sheet. If a task has no story point value, write 0.
Pull tasks, summarize by assignee, flag outliers, and calculate sprint velocity in one prompt
Fetch all completed tasks from Asana project [ID] completed after the date in cell B1. Write raw task data into 'CompletedTasks'. In the 'Velocity' sheet, write one row per assignee with their completed task count and average story points (from custom field). In column D of 'Velocity', write "Below Average" for any assignee whose count is more than 30% below the team average.
One prompt that generates the detail view, the summary, and the outlier flag your retro prep needs.
Try It
Get the 7-day free trial of SheetXAI and open your velocity tracker with the Asana project GID and sprint cutoff date — ask SheetXAI to pull the completed task data before your retro. You can also look at how to import subtask hierarchies for sprint planning, or see the full Asana workflow list in the hub overview.