The Scenario
A critical story just shipped three weeks late. You're the engineering manager and the post-mortem is tomorrow. The story was originally scoped as a two-point feature. Somewhere along the way it turned into a 13-pointer that touched five different engineers and went through four scope changes. You need the full change history — every field change, who made it, and when — in a spreadsheet so you can walk through the timeline with the team.
The bad version:
- Open the story in Shortcut. Find the activity feed on the right side. Start reading through the entries.
- Try to copy-paste the activity feed into a Google Sheet. The formatting doesn't survive the paste — you get a wall of unstructured text.
- Go entry by entry, manually typing: timestamp, changed by, field name, old value, new value. There are 34 change events on this story.
- Realize 8 of the entries are comment additions, not field changes, and you need to decide whether to include them in the timeline.
The post-mortem is tomorrow. You have 34 rows to fill in manually and no clean way to do it.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Google Sheet. It fetches the complete change history for the story from Shortcut and writes it into the sheet — one row per event, structured.
Open the SheetXAI sidebar and type:
Get the full change history for Shortcut story ID in cell A1 and write each change event into my sheet with columns for timestamp, changed by, field changed, old value, and new value
What You Get
- One row per change event in the story's history
- Timestamp in column A, the member who made the change in column B, the field that changed in column C, old value in column D, new value in column E
- Events sorted chronologically oldest to newest
- A sidebar count of how many change events were found
What If the Data Is Not Quite Ready
You want to exclude comment events and only show field changes
Get the change history for Shortcut story ID in cell A1. Filter out comment additions and only include field changes — estimate changes, state transitions, owner reassignments, label changes. Write timestamp, changed by, field, old value, and new value into this sheet.
You need to see only the scope-related changes (estimate and description)
Get the change history for Shortcut story ID in cell A1. Filter to only include changes to the estimate or description fields. Write each filtered event with timestamp, changed by, field, old value, and new value into this sheet.
You need the history for multiple stories to compare scope drift
For each story ID in column A of this sheet, fetch the change history from Shortcut. Write all change events into a single sheet with an extra column A showing the story ID, then columns for timestamp, changed by, field, old value, and new value. Events should be sorted by story ID then by timestamp.
Pull the history and automatically calculate how many times the estimate changed
Get the full change history for Shortcut story ID in cell A1. Write all change events into this sheet. Then in cell G1, write the total number of times the estimate field was changed, and in cell G2 write the initial estimate value and in G3 write the final estimate value.
The full audit trail — written out as a spreadsheet — is the thing that makes a post-mortem productive rather than a reconstruction from memory.
Try It
Get the 7-day free trial of SheetXAI and open a sheet with your story ID in cell A1, then ask it to pull the change history. See also Export Shortcut Iteration Stories to a Google Sheet or return to the Shortcut integration overview.