The Scenario
The quarterly engineering review is in three days. The engineering manager wants every completed sprint from the last quarter in a single Google Sheet — 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 sheet: 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 Google Sheet. 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 sheet.
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' sheet
What You Get
- One row per completed sprint in the Sprint Velocity sheet.
- Sprint name, start date, end date, planned item count, and completed item count filled from monday-dev data.
- Velocity rate (completed / planned) computable from the written columns without additional transformation.
- Any sprint that can't be fetched — wrong board ID, insufficient permissions — flagged with the specific error so you know which ones need attention before the review.
What If the Data Is Not Quite Ready
You also need the AI action items from each sprint retrospective
The review format requires action items, not just velocity numbers.
Pull the sprint summary for each sprint ID in column A of the 'Sprint Velocity' sheet and write the AI-recommended action items and scope creep percentage into columns F and G
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' sheet.
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' sheet 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' sheet. 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 a Google Sheet 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.