The Scenario
It's the morning of the company-wide OKR review. You're the director of engineering and you've been asked to present the current state of all 15 engineering objectives — name, key results, initial value, current observed value, and target. That data is in Shortcut. The presentation deck needs a table. The table doesn't exist yet.
The bad version:
- Open Shortcut. Navigate to Objectives. Click the first one. Start copying: name, key results, current value, target. Open a Google Sheet. Paste. Format.
- Go back to Shortcut. Click objective 2. Repeat.
- Get to objective 9 and realize the format you chose for key results doesn't accommodate multiple key results per objective neatly. Redesign the layout mid-copy.
- Finish at objective 15 and realize three of the "current values" you copied were the targets, not the observed values. Fix them.
The review starts in an hour. The table is still wrong.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Google Sheet. It connects to Shortcut, pulls all objectives and their key results, and lays them out in the sheet in one pull.
Open the SheetXAI sidebar and type:
List all Shortcut objectives and for each one list its name, state, and associated key results with current and target values in this sheet — one row per key result, with the objective name repeated in column A
What You Get
- One row per key result, with the parent objective name in column A
- Objective state in column B
- Key result description in column C
- Initial value in column D, current (observed) value in column E, target value in column F
- Headers in row 1
- A count in the sidebar of how many objectives and key results were found
What If the Data Is Not Quite Ready
You want one row per objective, not per key result
Get all Shortcut objectives and export their name, state, and all key result descriptions as a semicolon-separated list in column C. Put initial, current, and target values for the first key result in columns D–F. Write one row per objective.
You only want objectives that are in progress
Get all Shortcut objectives with status "in progress" and list their name, key results, current values, and target values in this sheet — one row per key result
You need to calculate percentage progress for each key result
Pull all Shortcut objectives and key results into this sheet. For each key result row, calculate progress as (current value minus initial value) divided by (target value minus initial value), formatted as a percentage, and write it into column G.
Full OKR snapshot with a summary row per objective
Pull all Shortcut objectives and their key results. Write one row per key result with objective name, key result description, initial, current, and target values. After all key result rows for each objective, insert a summary row showing the objective name and the average progress across its key results.
The point is that pulling OKR data out of Shortcut shouldn't take longer than presenting it.
Try It
Get the 7-day free trial of SheetXAI and open a blank sheet before your next OKR review, then ask it to pull the objectives. See also Export Shortcut Epics to a Google Sheet for Roadmap Review or return to the Shortcut integration overview.