The Scenario
You own a day spa. You just hired a new operations manager and her first project is to get the Gift Up! checkout catalog cleaned up and expanded. You currently have 12 service packages listed in a Google Sheet: name, price, description, and how many days from purchase the gift card should expire.
None of them exist in Gift Up! yet. The old system used paper gift certificates. This is the first time you are setting up Gift Up! properly. Your operations manager wants the catalog live by Monday, before the weekend foot traffic picks up.
The slow version:
- Log into Gift Up! and go to the Items section
- Click "Add Item," fill in the name, price, description, and expiry setting
- Click Save, go back, click Add Item again
- Repeat 12 times
- Realize on item 9 that you typed "90 days" expiry instead of "365 days" for the spa package — go back and fix it
- It is Sunday evening and she is still entering items.
The fast version is one prompt.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your spreadsheet that reads your catalog sheet and creates every Gift Up! item in one operation, writing the returned item ID back to the sheet so you have a record.
Open the SheetXAI sidebar and type:
Read columns A through D of this sheet — item name, price, description, and expiry days — and create a Gift Up! item for each row. Write the returned item ID back into column E.
SheetXAI reads all 12 rows, calls the Gift Up! item creation API for each one, and writes the item ID into column E as each item is created. By the end, you have 12 items live in Gift Up! and a sheet that maps item names to their IDs for future reference.
What You Get
Twelve live Gift Up! items, created from the sheet:
- Name — as written in column A
- Price — as specified in column B
- Description — as written in column C, formatted for the Gift Up! checkout page
- Expiry — set to the number of days from purchase specified in column D
- Column E — the Gift Up! item ID for each row, for future reference
You do not open the Gift Up! admin panel once. The sheet becomes your source of truth and column E gives you the IDs you will need if you ever want to create gift card orders from that item in bulk.
What If the Data Is Not Quite Ready
A catalog sheet drafted quickly tends to have inconsistencies. SheetXAI handles validation and creation in the same prompt.
When expiry days are missing for some items
A few rows have the name and price but the expiry column is blank because no decision was made yet.
Read columns A through D and create a Gift Up! item for each row. Where column D is blank, default to 365 days expiry. Write the returned item ID into column E and note "default expiry applied" in column F for those rows.
When some items should be set to "no expiry"
Your gift cards in some states cannot legally expire. Those rows are flagged in column E.
For each row, read the NoExpiry flag in column E. If it is "Yes," create the Gift Up! item with no expiry date. If it is "No" or blank, use the expiry days from column D. Write the item ID into column F.
When prices need rounding before creation
The spreadsheet has prices like $89.99 and $124.50 that your operations manager wants rounded to clean numbers in Gift Up!.
Before creating each item, round the price in column B to the nearest $5. Create the Gift Up! item with the rounded price, write the rounded price into column B (overwrite), and write the returned item ID into column E.
When you need to create all items, validate they appeared in Gift Up!, and generate a catalog summary in one pass
Create all 12 items, write item IDs, flag any failures, and produce a printable catalog summary with names and prices.
Read columns A through D and create a Gift Up! item for each row. Default to 365 days expiry where column D is blank. Write the returned item ID into column E. If a row fails, write the error reason in column F. After all rows are processed, add a formatted catalog summary below the data — item name, price, and ID — sorted alphabetically by item name.
The pattern: create the items and build the reference document in the same prompt, so your operations manager walks away with both the live catalog and the internal tracking sheet.
Try It
Get the 7-day free trial of SheetXAI and open your service catalog sheet, then ask it to create Gift Up! items from each row. The Gift Up! integration is included in every SheetXAI plan. For related workflows, see how to export Gift Up! promotions for campaign review or the Gift Up! in Google Sheets overview.