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 a Google Sheet 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 Google Sheet. It pulls all available Goody collections via the API — not the browsable UI — and writes the full list into your sheet with the fields that actually matter for a tier comparison: collection ID, name, and product count.
List all Goody collections and write their collection ID, name, and number of products into columns A through C of this sheet
What You Get
- Every available Goody collection written into columns A through C: 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 in column A are the values you'll reference when you're ready to place orders for each tier, so the sheet 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 sheet
Your tier structure is already in a tab 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 tab 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 sheet is ready to hand off for order creation.
Pull all available Goody collections into this Excel sheet so I can compare them and choose one for each of the three recipient tiers in my campaign — columns A through C for collection ID, name, and product count, plus an empty column D called 'Tier Assignment' and a column E that shows the account count for each tier from the 'Account Tiers' tab
Try It
Get the 7-day free trial of SheetXAI and open the Google Sheet 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.