The Scenario
You're the corporate gifting coordinator and you've just been handed a brief for a campaign with three client tiers — platinum, gold, and standard — each of which needs a different Goody collection. You have a list of which accounts fall into which tier. You don't know which Goody collections exist or which ones fit each segment.
Your manager's calendar shows a slot blocked for "gifting sign-off" at 2 PM.
The bad version:
- Open Goody's collections browser in a new tab. It shows collection names and a thumbnail grid of products, but no product count, no pricing summary, no way to sort or filter by size or category.
- Start writing collection names into an Excel workbook by hand — one row at a time — along with notes on what you can see from the thumbnail preview.
- Realize you've spent 45 minutes building a comparison table and you're not confident you've captured all available collections, because the browser doesn't have a "show all" mode.
The sign-off meeting is in two hours. The table you built by hand is incomplete and you know it.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your Excel workbook. It pulls all available Goody collections via the API — not the browsable UI — and writes the full list into your workbook with the fields that actually matter for a tier comparison: collection ID, name, and product count.
Pull all available Goody product collections into this Excel sheet so I can compare them and choose one for each of the three recipient tiers in my campaign
What You Get
- Every available Goody collection written into the workbook: collection ID (for use in order creation), display name, and product count.
- The list comes from the API, so it's complete — you're not missing collections that happened to be off-screen in the browser.
- Collection IDs are the values you'll reference when you're ready to place orders for each tier, so the workbook does double duty as both a planning document and an order input.
- You can sort by product count immediately to see which collections are the most curated versus the most expansive.
What If the Data Is Not Quite Ready
You need a column for average product price
Product count alone doesn't tell you whether a collection fits a $50 budget or a $150 one. You need pricing context.
Pull all Goody collections and write collection ID, name, number of products, and average product price into columns A–D of this sheet, then sort by average price ascending
You want to assign a collection to each tier in the same workbook
Your tier structure is already in a sheet called "Account Tiers." You want the collection comparison next to it so you can pick and confirm in one view.
Pull all available Goody collections into a sheet called 'Collections' with columns for collection ID, name, and product count, then add a column D called 'Assign to Tier' that I can fill in manually for each row
You need to filter collections by minimum product count
Some of your platinum clients expect variety — a collection with fewer than 10 products won't feel curated enough. You want to exclude the smaller ones from the comparison.
List all Goody collections with more than 10 products and write collection ID, name, and product count into columns A–C, sorted by product count descending
Full comparison, tier assignment, and order-ready output in one shot
You want the collection list, a column for your tier assignment, and the account count for each tier already filled in — so the workbook is ready to hand off for order creation.
Pull all available Goody collections and write collection ID, name, and product count into columns A–C, add an empty column D called 'Tier Assignment', and add a column E that shows the account count for each tier from the 'Account Tiers' sheet
Try It
Get the 7-day free trial of SheetXAI and open the Excel workbook where you're planning your tiered gifting campaign, then ask it to pull the full Goody collections list so you can assign one to each segment. Once you've made your selections, see how to create the order batch from your recipient list or check the product catalog for budget planning.