The Scenario
You are a program manager at a nonprofit that sold 300 branded T-shirts through their Raisely campaign store to raise additional funds. The campaign just closed. The fulfilment vendor is waiting for the order sheet before they can start picking and packing.
They need: buyer name, email, item name, size, quantity, and payment status — one row per order. And they need it today.
The slow version:
- Log into Raisely, find the orders section for the campaign
- Export — realize the export only shows basic order info, not item-level detail
- Go back into each order individually to see the line items
- Note the size and quantity for each, add them to the sheet manually
- Two hours in. 60 orders processed. The vendor calls asking where the file is.
The fast version is one prompt.
The Easy Way: One Prompt in SheetXAI
SheetXAI pulls all Raisely product orders including line-item detail and writes the fulfilment sheet for you.
Open the SheetXAI sidebar and type:
List all orders from my Raisely campaign 'merchandise-store' and import buyer name, email, product name, quantity, size, and payment status into this sheet. Filter for status 'paid' only. Sort by buyer surname ascending.
SheetXAI calls the Raisely API, expands the line-item data per order, filters for paid orders only, and writes the fulfilment sheet sorted alphabetically. The vendor gets the file within minutes of the campaign close.
What You Get
A complete fulfilment sheet, filtered to paid orders:
- Buyer name and email — one row per order line item
- Product name — item description from the Raisely store
- Quantity — how many units per line item
- Size — if applicable, the variant selected by the buyer
- Payment status — only paid orders appear
Line-item detail included. A buyer who ordered a large T-shirt and a hat appears as two rows — one for each product — so the picking list maps directly to individual items.
Want a summary tab showing total units per product and per size? Ask for it in the same prompt.
What If the Data Is Not Quite Ready
Order data from a campaign store has edge cases that matter for the fulfilment team.
When some orders have not cleared payment yet
A few orders show "pending" because the payment is still processing. The vendor should not pick those yet.
Import all orders from 'merchandise-store'. Write paid orders to the 'Fulfilment' tab. Write pending orders to a 'Pending' tab for monitoring. Skip refunded and cancelled orders.
When the vendor needs a pick-list grouped by product and size
The fulfilment team works more efficiently if they see all Large T-shirts together, then all Medium T-shirts, rather than in buyer order.
Import all paid orders from 'merchandise-store'. Write to the 'Fulfilment' tab grouped by product name, then by size within each product. Add a subtotal row per product showing total units.
When ticket types need to be separated from merchandise
The campaign sold both event tickets and merchandise through the same store. Fulfilment only cares about merchandise.
Import all paid orders from 'merchandise-store'. Filter to product categories tagged as 'merchandise' only — exclude anything tagged as 'ticket'. Write to the 'Fulfilment' tab sorted by buyer surname.
When the vendor also needs a summary of total units per SKU
Before the vendor can confirm stock availability, they need a count: how many of each product and size variant were sold.
Import all paid orders from 'merchandise-store' into the 'Fulfilment' tab. Also write a summary to the 'SKU Summary' tab showing product name, size, and total units sold for each variant. Sort SKU summary by product name then size.
The pattern: pull, filter, and format for the person who has to act on the data. The fulfilment vendor does not want raw API JSON — they want a sorted tab they can hand to the warehouse.
Try It
Get the 7-day free trial of SheetXAI and ask it to pull your Raisely campaign store orders into a fulfilment sheet. The Raisely integration is included in every plan. See also how to import donations for board reporting or the Raisely in Google Sheets overview.