The Scenario
You run the loyalty program for a health and beauty retailer. Last quarter, you ran a promotion where customers who hit a spend threshold earned a $25 credit on their existing gift card. You have 60 customers in a Google Sheet, each with a gift card code and the top-up amount they earned.
The campaign wrapped up three days ago. The finance team approved the payouts. The loyalty platform manager told you to get it done by end of week so customers see the credit before the next promotional email goes out.
The slow version:
- Log into Gift Up! and find the first gift card code
- Locate the top-up or balance adjustment function
- Enter the amount, confirm, go back
- Mark that row in the sheet as done
- Go to the next code. Repeat 60 times.
- You finish Friday afternoon, exhausted, and realize you cannot remember whether you did row 43 or row 44 last.
The fast version is one prompt.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your spreadsheet that reads the code-and-amount pairs and applies each top-up in Gift Up!, writing the new balance back to the sheet so you have a clean record.
Open the SheetXAI sidebar and type:
For each row in this sheet where column A is a Gift Up! gift card code and column B is a top-up amount, add that amount to the gift card balance and write the new balance into column C.
SheetXAI reads each row, calls the Gift Up! API to add the specified amount to that card, and writes the resulting new balance into column C. All 60 rows in a single run.
What You Get
A completed top-up log with updated balances confirmed by Gift Up!:
- Column C — the new balance Gift Up! returned after each top-up, not an estimate
- Error rows — if a code does not exist or the API call fails, column C shows the reason
- A record the finance team can audit — the sheet shows code, top-up amount, and resulting balance, all in one place
The new balance comes from Gift Up!, not from a formula. If a card had $12.50 remaining and you topped it up by $25, column C shows $37.50 as confirmed by the platform.
What If the Data Is Not Quite Ready
Loyalty program exports are rarely clean. The code list might have gaps, the amounts might need validation, and some cards might have been voided. SheetXAI handles it all in the same prompt.
When some gift card codes in the sheet are voided or expired
Before adding money to a card, you want to check its status. Topping up a voided card would create a problem.
For each row, check the Gift Up! gift card status before applying the top-up. If the card is voided or expired, write "SKIPPED — card inactive" in column C. If the card is active, apply the top-up amount from column B and write the new balance into column C.
When top-up amounts should be capped
Finance approved a maximum top-up of $50 per customer. Some rows in the sheet have amounts above that from a data entry error.
For each row, apply a top-up in Gift Up! using the value in column B, but cap it at $50. If column B is greater than $50, use $50 instead and write a note in column D explaining the cap was applied.
When you need to reactivate voided cards before topping up
Some of the 60 customers had their cards voided during a system migration and need to be reactivated first.
For each row in column A, check the gift card status in Gift Up!. If voided, reactivate it first, then apply the top-up from column B. If already active, apply the top-up directly. Write the final balance into column C and the action taken — "reactivated and topped up" or "topped up directly" — into column D.
When you need to process top-ups, validate every result, and produce a finance summary in one prompt
Full top-up run, per-row status, and a summary table for the finance sign-off — all at once.
For each row, check the Gift Up! gift card status. Skip voided or expired cards and write "SKIPPED" in column C. For active cards, apply the top-up amount from column B, capped at $50, and write the new balance into column C. After processing all rows, add a summary below the data: total amount topped up, count of successful top-ups, count of skipped rows, and count of rows where the cap was applied.
The pattern: describe the full operation including the validation logic and the summary you need, and SheetXAI handles the edge cases row by row without a second pass.
Try It
Get the 7-day free trial of SheetXAI and open your loyalty top-up sheet, then ask it to process the balance additions in Gift Up!. The Gift Up! integration is included in every SheetXAI plan. For related workflows, see how to bulk-void flagged gift cards or the Gift Up! in Google Sheets overview.