The Scenario
The operations analyst on your team built a prioritization model in Excel last quarter. The model needs two inputs per feature: Effort and Impact. Both are custom fields in Productboard. There are 300 features. The model is sitting idle because nobody has fed it the data.
You've been asked to get the custom field values out. You open Productboard, find a feature, click into it, and see the Effort and Impact fields. You click the next feature. You do the math: 300 features, two fields each, manually. That's 600 cells. At ten seconds per cell, it's 100 minutes of clicking.
The bad version:
- Export the Productboard features CSV. Open it in Sheets. Notice Effort and Impact aren't in the export — they're custom fields and don't appear in the standard download.
- Search for a custom field export option. Find a help article that says custom field exports require an API call.
- Copy the feature IDs from the CSV. Paste them somewhere. Stare at the Productboard API documentation.
The model is still idle. The prioritization decision is still on hold. Someone eventually asks why.
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 — including custom field endpoints — through its built-in integration.
List all Productboard custom field definitions for features and write field name, type, and ID into Sheet1. Then list all custom field values for every feature and write feature name, Effort value, and Impact value into Sheet2
What You Get
- Sheet1 with your full custom field catalog — useful for reference and future pulls.
- Sheet2 with one row per feature: feature name, Effort value, Impact value.
- Features where Effort or Impact haven't been filled in show blank — you'll know exactly which records need attention before the model runs.
What If the Data Is Not Quite Ready
You need specific feature IDs to match against an existing sheet
For each feature ID in column A of this sheet, get the "Effort" and "Impact" custom field values from Productboard and write them into columns B and C
The custom field values are numeric scores but some features have text values instead
Pull Effort and Impact values for all Productboard features into Sheet2. If any Effort or Impact value is not a number, mark that cell "needs-review" so I can fix the source data in Productboard.
You want to include additional custom fields beyond Effort and Impact
First list all Productboard custom field definitions into Sheet1 with field name and ID. Then for each feature, pull all custom field values and write one column per field into Sheet2, using the field name as the column header.
The full model-ready pull
List all Productboard features into Sheet2 with feature ID in A and feature name in B. Then for each feature, pull the Effort custom field value into column C and the Impact custom field value into column D. Flag any row where either C or D is blank with "missing-data" in column E. Sort by feature name A to Z.
The model gets real data. The prioritization conversation can finally start.
Try It
Get the 7-day free trial of SheetXAI and open any Google Sheet connected to a prioritization model or scoring framework — then ask SheetXAI to pull your Productboard custom field values directly into it. See also exporting the feature roadmap or the hub overview.