The Scenario
The quarterly engineering review is in three days. The engineering manager wants every completed sprint from the last quarter in a single Excel workbook — sprint name, start and end dates, planned item count, completed item count, and AI-recommended retrospective action items — so the leads can review velocity trends and agree on action items before the meeting. You have eight sprints sitting in the monday-dev board. You have no clean way to get them out.
The bad version:
- Open each sprint in monday-dev one at a time, read the summary panel, and type the numbers into a tracking worksheet: start date, end date, planned, completed.
- Realize the sprint summary view doesn't show AI-recommended action items in an exportable format — that text only shows in the sprint retrospective modal.
- Open each retrospective modal, read the AI output, and manually paste the relevant action items into a notes column, reformatting as you go.
Eight sprints. Eight summaries. Eight retrospective modals. The meeting is in three days and this was not the priority you had planned for Tuesday.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Excel workbook. It reads your sprint board, pulls completed sprint metadata through the monday-dev API, and writes the full velocity table — including AI action items — directly into your workbook.
Pull the sprint summary for each sprint ID in column A of my Excel sheet and write the AI-recommended action items and scope creep percentage into columns B and C
What You Get
- One row per completed sprint in the Sprint Velocity worksheet.
- Sprint name, start date, end date, planned item count, and completed item count filled from monday-dev data.
- AI-recommended action items and scope creep percentage written into the workbook.
- Any sprint that can't be fetched flagged with the specific error so you know which ones need attention before the review.
What If the Data Is Not Quite Ready
You need the full metadata first, not just action items
You don't have sprint IDs in column A yet — start by pulling the list of completed sprints.
Fetch metadata for the last 8 completed sprints from my monday-dev sprints board and write sprint name, start date, end date, planned items, and completed items into the 'Sprint Velocity' worksheet
Sprints span two quarters and you only want Q1
The board has sprints going back further than you need. Filter by date range.
Fetch all completed sprints from my monday-dev board where the end date falls between 2026-01-01 and 2026-03-31. Write sprint name, start date, end date, planned items, and completed items into the 'Q1 Sprints' worksheet.
You need to flag sprints where completion rate was below 70%
Low-velocity sprints are the ones the leads want to discuss. Surface them automatically.
For each row in the 'Sprint Velocity' worksheet where column E (completed) divided by column D (planned) is less than 0.7, write 'LOW VELOCITY' in column H. Leave column H blank for sprints above 70%.
The full quarterly review prep in one shot
Fetch the last 8 completed sprints from my monday-dev board. For each, write sprint name, start date, end date, planned items, completed items, AI action items, and scope creep percentage into the 'Sprint Velocity' worksheet. In column I, calculate the completion rate (completed/planned) and write 'LOW VELOCITY' if below 0.7. Sort results by start date ascending.
Metadata, AI output, and business logic flags in one prompt, ready for the review meeting.
Try It
Get the 7-day free trial of SheetXAI and open an Excel workbook with your monday-dev sprint board IDs, then ask it to build the quarterly velocity report before your engineering review. Related: generating a cross-board status snapshot or bulk-importing task lists into monday.com.