The Scenario
The loyalty program director has been asked to review every perk currently live in Piggy before the team publishes a new VIP tier next week. The ask is specific: a single Excel workbook with every perk's name, ID, and type, sorted and ready for review. Nobody wants to scroll through the Piggy UI page by page to compile this manually.
The bad version:
- Open the Piggy perks catalog in the UI, start scrolling, write down perk names and IDs.
- Check whether there's an export option — there isn't in a format that opens cleanly in Excel.
- Spend 45 minutes building a manual list, realize you missed the perks on page 3, start over.
The review meeting is tomorrow. The catalog has to be current, complete, and in the workbook before the team sees it.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Excel workbook. It pulls the full Piggy perks catalog via the API and writes every perk into the workbook — one per row, all fields included, sorted and ready to review.
Fetch the full Piggy perks catalog and dump it into the Excel sheet 'Perks Catalog' with all available fields, then sort alphabetically by perk name
What You Get
- Row 1 of the 'Perks Catalog' worksheet gets auto-generated headers from the Piggy response fields.
- Every subsequent row is one perk from the catalog, with all available fields populated.
- The worksheet sorts alphabetically by perk name so the review is easy to navigate.
- If Piggy returns additional metadata (description, value, tier association), SheetXAI writes those fields into additional columns so nothing is lost.
What If the Data Is Not Quite Ready
You need the catalog sorted by type then alphabetically within each type
Fetch the full Piggy perks catalog and write it into the 'Perks Catalog' sheet with all available fields. Sort by perk type first, then alphabetically by perk name within each type. Add a header row
You need to compare the Piggy catalog against perks already listed in column A
Fetch the full Piggy perks catalog. For each perk, check whether its name appears in column A of the 'Perks Catalog' sheet. Write the Piggy perk details into columns B, C, and D. Mark perks that are in Piggy but not in column A with NEW in column E. Mark perks that are in column A but not in Piggy with MISSING in column E
You only want perks of a specific type
List all perks in Piggy where the type is discount. Write each perk's name, ID, and value into the 'Perks Catalog' sheet, one per row, sorted by value descending
Pull the full catalog, enrich with metadata, flag conflicts, and format for the review meeting
Fetch every perk from Piggy. Write the name into column A, ID into column B, type into column C, and any associated tier or segment data into column D of the 'Perks Catalog' sheet. Sort by type then alphabetically by name within each type. Add a header row. Write the total perk count into cell F1 and the count by type into cells F2 onward
A formatted, sorted catalog with the count summary in the header area means the director can hand it to the team without any prep work.
Try It
Open an Excel workbook and Get the 7-day free trial of SheetXAI. Ask it to dump your full Piggy perks catalog into a worksheet and sort it for review. For related workflows, see how to sync a product catalog into Piggy or the full Piggy integration overview.