The Scenario
The board meeting is in eight days. The CPO asked for "a one-pager on our 12 initiatives — what's in each one, how many features are linked, which objectives they support." The data lives in Productboard. You're the product analyst who has to build this view. You've never exported initiatives from Productboard before. The initiatives section of the product looks great on screen and is completely opaque from an export perspective.
The bad version:
- Spend twenty minutes in Productboard menus looking for an export option that doesn't exist.
- Start a new spreadsheet and manually type each initiative name. There are 12 active ones.
- Switch back to Productboard, click into Initiative 1, count the linked features, switch back to the sheet, type the number.
- By initiative 7 you've lost track of whether you counted a recently archived feature or not.
The CPO's one-pager for the board is not the place to discover that your feature count was off by 4.
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 API through its built-in integration. You don't need to navigate the Productboard UI for every field.
List all active Productboard initiatives and write initiative name, status, owner, and description into columns A through D of this sheet
Then follow up:
For each initiative in this sheet, fetch the linked features from Productboard and write the feature count into column E and the feature names comma-separated into column F
What You Get
- Every active initiative as a row with its metadata in columns A through D.
- The integer feature count per initiative in column E — pulled live from Productboard, not estimated.
- Feature names joined in column F so you can spot which features are doing double duty across initiatives.
- Initiatives with zero linked features show 0 in E and blank in F — clearly flagged, not silently empty.
What If the Data Is Not Quite Ready
You also need the linked objectives for each initiative
For each initiative in column A, fetch the linked Productboard objectives and write the objective names (comma-separated) into column G and the objective count into column H
Some initiatives have been archived and should be excluded
List all Productboard initiatives where status is not "archived" and write initiative name, status, owner, and description into columns A through D. Skip any with status "archived."
The owner field is showing an ID instead of a name
After pulling initiatives into this sheet, fetch all Productboard users and write their user ID and display name into Sheet2. Then replace any raw user IDs in column C of Sheet1 with the matching display name from Sheet2.
The full board-ready build
Pull all active Productboard initiatives (status not archived) into this sheet — name in A, status in B, owner display name in C, description in D. Then for each initiative, write feature count in E and feature names in F, and linked objective names (comma-separated) in G. Sort by initiative name A to Z.
The one-pager source data, ready to format before the board deck deadline.
Try It
Get the 7-day free trial of SheetXAI and open any Google Sheet you're preparing for an executive or board presentation — then ask SheetXAI to pull all your Productboard initiative data in one go. See also exporting OKR objectives or the hub overview.