The Scenario
It's the middle of the quarter. The strategy analyst has been asked to present OKR progress at Thursday's leadership sync. She needs a Google Sheet with all 45 key results, their progress percentages, owners, and parent objective names — something leadership can scan in the room without clicking through Productboard.
She opens Productboard's OKR section. Key results are nested under objectives. Progress percentages are visible on screen. There's no export option in the OKR module.
The bad version:
- Open Objective 1. Note the key results under it — three of them. Write them into the sheet manually. Progress for KR1: 62%. Owner: Marcus. Switch tabs.
- After 8 objectives and 23 key results, the screen times out and the Productboard session expires. Start from the last checkpoint.
- Submit the sheet 40 minutes before the meeting. Get a reply: "Can you add which objective each key result belongs to?" That column isn't there. Go back in.
The leadership sync starts in two hours and the data that should take minutes to pull has consumed most of the morning.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Google Sheet. It reads your sheet and calls Productboard's OKR API through its built-in integration.
List all Productboard key results and write key result name, parent objective name, status, progress, owner, and timeframe into this sheet, one row per key result
What You Get
- One row per key result across all objectives.
- Columns: key result name in A, parent objective name in B, status in C, progress value in D (as a percentage or raw number, depending on your Productboard setup), owner in E, timeframe in F.
- Key results with no owner show "unassigned" — nothing silent.
- All 45 key results, ready to sort and share.
What If the Data Is Not Quite Ready
You only want active key results (not archived or draft)
List all Productboard key results with status "active" and write key result name, parent objective name, progress, owner, and timeframe into this sheet. Exclude any key results with status "archived" or "draft."
You want to group by objective in the sheet
List all Productboard key results sorted by parent objective name A to Z. Write parent objective name in A, key result name in B, status in C, progress in D, and owner in E. Insert a blank row between each objective group.
The progress values are raw numbers and you need percentages
Fetch all Productboard key results and write key result name in A and the raw progress value in B. If the progress value is between 0 and 1, multiply by 100 and write the result as a percentage into column C. If it's already 0 to 100, copy it directly to column C.
The full mid-quarter review build
Pull all active Productboard key results into this sheet with parent objective name in A, key result name in B, status in C, progress percentage in D, and owner display name in E. Flag any key result where progress is below 25% in column F as "at-risk". Sort by parent objective name A to Z, then by progress ascending.
Leadership has a sortable, flagged view of every key result before the sync starts.
Try It
Get the 7-day free trial of SheetXAI and open any Google Sheet where you're tracking OKR progress — then ask SheetXAI to pull all your Productboard key results into it so Thursday's review has real numbers. See also exporting OKR objectives or the hub overview.