The Scenario
You're a product manager planning the next wave of in-app surveys. The idea is to target the feature adoption survey at users who haven't activated a key workflow yet — but only if they're on the Growth or Enterprise plan. You know Refiner has segments. You're not sure which segments exist, what they're named, or how many users are in each. You need to figure that out before you can write the targeting logic.
The bad version:
- Open Refiner's segments view and click through each one individually to read the description and member count.
- Copy the names and descriptions into a doc, then try to identify which segments overlap with the criteria you care about.
- Go back to Refiner to get the exact segment IDs you'll need when configuring the survey targeting.
There are 20 segments. Clicking through all of them is 20 minutes of work that produces a doc you'll immediately transfer into a sheet anyway.
The Easy Way: One Prompt in SheetXAI
SheetXAI lives inside your Google Sheet and talks to Refiner's segments API directly. You get the full inventory without clicking through the UI.
List all Refiner segments and write the segment name, description, and ID into this sheet
What You Get
- Column A: segment name
- Column B: segment description text
- Column C: segment ID (used when configuring survey targeting)
- One segment per row; header row in row 1
- All segments returned including inactive ones — filter in the sheet as needed
What If the Data Is Not Quite Ready
You need member counts alongside the names to know which segments are worth targeting
List all Refiner segments and write segment name in column A, description in column B, member count in column C, and segment ID in column D. Sort by member count descending.
You only want segments that contain more than 50 members
List all Refiner segments where member count is greater than 50. Write segment name in column A, member count in column B, and segment ID in column C.
You want to compare segment names against a list of plan tiers you already have in the sheet
List all Refiner segments and write segment name in column A and segment ID in column B. Then in column C, write Yes if the segment name contains Enterprise or Growth, otherwise write No.
You need the full picture — segments plus a count of active surveys currently targeting each
List all Refiner segments. Write segment name in column A, member count in column B, and segment ID in column C. Then write the number of currently active surveys that target this segment in column D. If none, write 0.
Segment audits work best when you can see both the inventory and the usage at once. Build the full picture into one prompt instead of assembling it across two separate exports.
Try It
Get the 7-day free trial of SheetXAI and open the Google Sheet where you're planning your next survey campaign, then ask it to pull your full Refiner segment list with member counts. You can also audit your active survey configurations or bulk-update contact attributes before launching.