The Scenario
The product strategy lead just forwarded you a calendar invite for a planning workshop with eight product managers happening in four days. The ask: bring a one-stop view of every active objective, which key results sit under each one, and how many features are linked to each objective. You're the PMO analyst. You've never pulled this data out of Productboard before. You know it's in there. You do not know which API calls get it out.
The bad version:
- Ask the Productboard admin for an export. They send you the objectives CSV, which has no key result data.
- Try the key results view — there's no export button.
- Manually match objectives to key results by opening each objective card and writing down the linked key result names. There are 23 active objectives.
- Realize you also need feature counts, which aren't in either of the two exports.
The workshop is in four days. You've now spent three hours building the scaffold of a spreadsheet that still isn't finished, and you haven't done the actual analysis yet.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Google Sheet. It reads your sheet and calls the Productboard API on your behalf through its built-in integration. You don't need to know the endpoint structure.
List all Productboard objectives and write each objective's name, status, owner, timeframe, and description into Sheet1 columns A through E
Then follow up:
For each objective in Sheet1, list all linked features in Productboard and write the feature count into column F and the feature names (comma-separated) into column G
What You Get
- Every active objective written as a row in Sheet1 with its core metadata.
- Column F with the integer count of features linked to that objective.
- Column G with the feature names joined, so you can scan which features are driving each objective.
- Objectives with no linked features show 0 in column F and blank in column G — no silent omissions.
What If the Data Is Not Quite Ready
You only want objectives with at least one linked feature
List all Productboard objectives and write name, status, owner, and description into Sheet1. Then for each objective, check whether any features are linked — if none, mark column E "no-features" and remove that row from the final output range I will use for the workshop.
You also need the key result names under each objective
For each objective in Sheet1 column A, fetch the linked Productboard key results and write the key result names and their current status into Sheet2 with the objective name in column A, key result name in column B, and key result status in column C.
The timeframes on objectives are using IDs instead of labels
Fetch all Productboard timeframe definitions and write ID-to-label mapping into Sheet3. Then when pulling objectives into Sheet1, replace any raw timeframe ID in column D with the matching label from Sheet3.
The full build for the planning workshop
Pull all active Productboard objectives into Sheet1 with name, status, owner, and timeframe label. For each, count linked features and list their names. Then pull all key results into Sheet2 with parent objective name, key result name, key result status, and progress value. Sort Sheet2 by objective name A to Z, then by key result name A to Z.
Two structured sheets, ready to share before the workshop.
Try It
Get the 7-day free trial of SheetXAI and open any Google Sheet you're preparing for a planning session — then ask SheetXAI to pull your Productboard OKR structure directly into it. See also exporting key results or the hub overview.