The Scenario
Sprint retrospective is tomorrow. Your engineering manager wants velocity, scope creep score, and completion rate for each of the last 10 sprints — pulled from the monday-dev board into Google Sheets so the team can see trends during the retro. The data is all in monday.com's sprint tracking. Getting it into a Sheet without writing a script is the question.
The bad version:
- Open monday.com's dev view, navigate to the sprint report for the oldest sprint in scope.
- Note the velocity manually — it's displayed in the UI but there's no export button.
- Open a new Sheet row, type in the sprint name, the dates, the velocity number.
- Move to the next sprint, repeat.
- Discover that sprint 6 has a different data model because the team changed their estimation approach mid-quarter.
- Spend time reconciling the inconsistency.
- Finish with 10 rows of manually typed data for a chart that should have taken five minutes.
Sprint data is in monday.com. The retro deck needs it in a Sheet. Between those two facts is too much manual work.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Google Sheet. It reads what you need, talks to monday.com through its built-in integration, and writes sprint summary data into the Sheet — no UI copying, no manual transcription.
Fetch the last 10 completed sprints from my monday-dev sprints board and write sprint name, timeline, total items planned, items completed, and velocity into the 'Sprint History' sheet
What You Get
- One row per sprint in 'Sprint History.'
- Columns for: sprint name, start date, end date, items planned, items completed, velocity.
- Sprints ordered by end date descending (most recent first).
- A completion rate percentage calculated as a derived column.
What If the Data Is Not Quite Ready
You also need scope creep score and the AI recommendation for each sprint
Pull sprint summaries for all sprints completed this quarter from my monday.com dev board and write scope creep score and top AI recommendation for each into the 'Retrospective' sheet alongside the standard velocity fields
Two sprints were run simultaneously by different sub-teams and need to be combined
Fetch the last 10 completed sprints from my monday-dev board. Where two sprints share the same date range, combine their item counts and velocity into a single row and note "Combined" in column G
You need a chart-ready format with the data normalised across sprints
Fetch the last 10 completed sprints from my monday-dev board. Write sprint name, items planned, items completed, and velocity into 'Sprint Chart Data'. Normalise velocity to a 0-100 scale across the 10 sprints and write the normalised value into a fifth column
Kill chain: fetch sprints, flag outliers, add a trend column, and format for the retro deck
Fetch the last 10 completed sprints from my monday-dev board and write to 'Sprint History' with columns: name, start date, end date, planned, completed, velocity, scope creep score. Add a 'Trend' column that shows whether velocity increased, decreased, or held steady vs the previous sprint. Bold the header row and apply conditional formatting: green if velocity increased, red if decreased.
Pull, annotate, and format in one prompt — the Sheet is ready to drop into the retro deck.
Try It
Get the 7-day free trial of SheetXAI and open a blank Google Sheet before your next retrospective, then ask SheetXAI to pull the sprint history from your monday-dev board. See also: Aggregate board data into a dashboard and the monday.com hub overview.