The Scenario
The retrospective is in two hours. You promised the team a velocity trend chart covering the last eight sprints. The data lives in Jira — sprint names, start and end dates, story points completed — but it has never been in a Google Sheet before. Your agile coach persona is supposed to facilitate, not spend the morning pulling numbers out of Jira one sprint at a time.
The bad version:
- Open Jira, navigate to the board, click Reports, find the Velocity Chart.
- Screenshot the chart because Jira doesn't export it cleanly.
- Manually read each bar's value from the chart, type the numbers into a sheet row by row.
- Realize sprint 4 is cut off and the axis is ambiguous, so the numbers you typed might be off by a few points.
The chart you hand-built on a screenshot interpretation is not a number anyone should put in a retrospective deck. And building it again next sprint means doing this whole thing over.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your Google Sheet. It reads the sheet and through the Jira integration fetches actual sprint data — not a chart screenshot — and writes the raw numbers into your cells.
List the last 8 completed sprints on Jira board 42 and write sprint name, start date, end date, and total story points of completed issues into columns A, B, C, D.
What You Get
- Eight rows, one per sprint, with sprint name in column A, start date in B, end date in C, and total story points completed in D.
- Points are summed from actual completed issues in each sprint — the same number Jira's velocity chart would show, not a visual estimate.
- Dates are in ISO format, ready to be parsed by a SPARKLINE or chart range.
- With the raw data in the sheet, you can build whatever chart shape the retrospective needs.
What If the Data Is Not Quite Ready
You want both committed points and completed points for each sprint
The retrospective needs to show whether the team is consistently over- or under-committing.
For each of the last 8 completed sprints on Jira board 42, write the sprint name, total story points of all issues added to the sprint, and total story points of completed issues into columns A, B, and C.
The sprint names in Jira are inconsistent and you want a cleaner label
Sprint names like "Sprint 2025-Q1-W3" need to become "Q1 Sprint 3" in the sheet.
Fetch the last 8 completed sprints on Jira board 42 and write sprint name, start date, and completed story points into columns A, B, D. In column A, simplify the sprint name to a short label like 'Sprint 1', 'Sprint 2', incrementing chronologically.
You already have sprint names in column A and want to fill in the story points
The sheet has eight sprint names typed in already but no point data.
For each sprint name in column A of my Velocity sheet, search Jira for all Done issues in that sprint on board 42 and sum their story points, writing the total into column B.
Kill chain: fetch velocity, calculate rolling average, flag declining sprints
Fetch the last 8 completed sprints on Jira board 42 and write sprint name and completed story points into columns A and B. In column C, calculate the 3-sprint rolling average. In column D, flag any sprint where completed points are more than 20% below the rolling average with 'Declining'.
One prompt pulls the data, does the math, and adds the flag — no formulas to write by hand after the fact.
Try It
Get the 7-day free trial of SheetXAI and open a blank Google Sheet before your next retrospective, then ask it to pull the last eight sprints from your Jira board and write the velocity numbers in. See also: how to pull Jira project versions for release planning and how to export team workload by assignee.