The Scenario
You're running a holiday promotion. 50 VIP customers, each getting a gift card for a different amount based on their spend tier — amounts are already calculated and sitting in column A of a Google Sheet, customer emails in column B. The campaign email goes out Tuesday morning and the gift card codes need to be in the email.
Shopify's gift card creator lets you create one at a time. You have 50 to create, and you need the last four digits of each code to personalize the emails.
The bad version:
- Open the Shopify gift card section, click Issue gift card, enter the amount, enter the customer email, generate, note the last four digits.
- Copy the last four digits into your Google Sheet next to that customer's row.
- 50 times. Hoping you don't mismatch a row in the process.
The emails go to leadership for approval Monday afternoon. The codes need to exist before that review.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Google Sheet. It reads the gift card amounts and customer emails, creates each Shopify gift card via the API, and writes the gift card ID and last four digits back into the sheet — so your email personalization data is ready without any manual tracking.
Create a Shopify gift card for each row in my Gift Cards sheet using the initial value in column A and the customer email in column B — write the gift card ID and last 4 digits into columns C and D
What You Get
- A Shopify gift card created for each row, with the customer email assigned to the card.
- The gift card ID and last four digits written back into columns C and D for use in your campaign email merge.
- All 50 gift cards available in the Shopify admin immediately, with the customer association visible.
What If the Data Is Not Quite Ready
Amounts need to be validated — some cells may have been entered as text, not numbers
Create Shopify gift cards for each row in my Gift Cards sheet — treat column A as a number (strip any currency symbols or commas) — use customer email in column B — write the gift card ID and last 4 digits into columns C and D
Gift cards need an expiry date set three months out
Create Shopify gift cards for each row in my Gift Cards sheet using amount in column A and customer email in column B — set expires_on to 90 days from today — write the gift card ID and last 4 digits into columns C and D
The VIP list spans two tabs — Tier-1 and Tier-2 — with different amounts per tier
Create Shopify gift cards for all rows in my Tier-1 Rewards sheet (amount in column A, email in column B) and all rows in my Tier-2 Rewards sheet (same structure) — write the gift card ID and last 4 digits into columns C and D of whichever tab each row came from
Validate amounts, set expiry, create from both tiers, write IDs and codes
For each row in my Gift Cards sheet where column C is blank, create a Shopify gift card using amount in column A (converted to number), customer email in column B — set expires_on 90 days from today — write the gift card ID into column C and last 4 digits into column D
Doing the amount normalization and expiry logic inline means the cards are created correctly the first time.
Try It
Get the 7-day free trial of SheetXAI and open your VIP rewards spreadsheet before the campaign email review on Monday, then ask SheetXAI to create all 50 gift cards and write the codes back. Future loyalty campaigns will use the same pattern. Also worth reading: how to bulk create discount codes for a different kind of promotion, or the hub overview for all Shopify workflows.