The Scenario
You're three weeks into planning a 200-client appreciation campaign and you've been asked to put together a shortlist of gift options — products available in Goody, filtered to stay under the $75 per-recipient budget, with a column showing what the total spend would look like at 200 units each.
Nobody handed you a catalog. The budget constraint is real. The stakeholder review is Thursday.
The bad version:
- Open Goody's product browser in a tab, start scrolling through available products, and manually note the ones that appear to be under $75 — name, price, category — in a Google Sheet column by column.
- Realize the product browser doesn't have a price filter, so you're squinting at each listing and reading the price before deciding whether to log it.
- Calculate the 200-unit cost by hand for each product that makes the cut, which means multiplying price × 200 for every row you enter.
You have 200 clients, a budget gate, and a Thursday deadline. Browsing a product catalog by hand and running multiplication for each row is not a defensible use of your calendar.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your Google Sheet. It reads your context — including the recipient count you've already entered into the sheet — and uses its built-in Goody integration to pull the full catalog, apply the price filter, and calculate the total cost column for you in one prompt.
Fetch all active Goody products and write product name, price, category, and availability into columns A–D, then filter to only show products under $75
What You Get
- Columns A through D populated: product name, unit price, category (food & drink, wellness, branded merchandise, etc.), and current availability status.
- Only products with a unit price below $75 appear — anything over the threshold is excluded before it hits the sheet.
- The list reflects current Goody catalog state, so discontinued or out-of-stock products don't land in your shortlist.
- You can sort by price or category immediately after the pull without any cleanup.
What If the Data Is Not Quite Ready
You need the 200-unit total cost next to each product
The shortlist is for a stakeholder who thinks in total budget, not per-unit price. You need a column that shows what each product would cost at full campaign scale.
Pull the full Goody product catalog into this sheet and add a column showing the estimated total cost for sending each product to all 200 recipients based on the count in cell F1
You want products grouped by category
The stakeholder presentation has three sections — food, branded goods, and wellness. You need the catalog sorted accordingly, not as a flat alphabetical list.
Fetch all active Goody products under $75, write name, price, and category into columns A–C, then sort the results so all products in the same category are grouped together
The budget varies by recipient tier
Tier 1 clients get a $100 budget. Tier 2 clients get $60. You want two separate filtered views on different tabs.
Fetch all active Goody products, write the full catalog to a tab called 'All Products', then create a tab called 'Tier 1' with only products under $100 and a tab called 'Tier 2' with only products under $60 — include name, price, and category in both
Catalog pull, cost calc, and category filter in one shot
You want the filtered catalog, the 200-unit totals, and only the food & drink category — all in one pass so you can send the sheet to the stakeholder without further editing.
Pull all active Goody products in the 'Food & Drink' category under $75, write product name, unit price, and estimated total cost at 200 recipients (using cell F1 as the count) into columns A–C, sorted by unit price ascending
One prompt, one pass, presentation-ready output.
Try It
Get the 7-day free trial of SheetXAI and open the Google Sheet where you're building your campaign gift shortlist, then ask it to pull the Goody catalog filtered to your budget. If you're ready to place orders after choosing a product, see how to create a gift order batch from your recipient list.