The Scenario
Your retention team is running a win-back campaign next week. The plan: send 500 long-inactive subscribers a personalized email with a unique 15%-off coupon code. Klaviyo can generate unique codes from a coupon definition. The codes need to land in column B of your subscriber sheet, next to each subscriber's email in column A, so the flow can inject the right code into the right email.
The bad version:
- Locate Klaviyo's bulk coupon code creation API documentation and discover that it requires a job — you submit the job, wait for it to complete, then poll another endpoint to retrieve the generated codes.
- Write or find a script to handle the two-step async job pattern, run it, and download a JSON response with 500 code strings that you now have to parse and paste into the correct column.
- Match each code to its subscriber row manually, discover that the codes came back in a different order than the subscribers, and spend 30 minutes reconciling.
The campaign has a send date. The codes need to be in the sheet before the flow can go live. Nobody budgeted time for a polling script.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Google Sheet. It handles the async Klaviyo coupon job, waits for it to finish, retrieves the codes, and writes each one back into the sheet next to the right subscriber — in one prompt.
Generate 500 unique coupon codes for Klaviyo coupon ID abc123 and write each code into column B of this sheet next to the corresponding subscriber email in column A
What You Get
- A Klaviyo bulk coupon code job is submitted for 500 codes tied to the specified coupon.
- When the job completes, each code is written into column B on the row corresponding to the subscriber in column A.
- If fewer codes are generated than expected, a note at the bottom of column B explains the shortfall.
What If the Data Is Not Quite Ready
The coupon ID is not known — only the coupon name
Create a bulk coupon code job in Klaviyo for 300 codes tied to the coupon named "WINBACK15", then populate column C of the "Reactivation" sheet with the generated codes starting at row 2
You need different code batches for different subscriber segments
For rows in this sheet where column C says "90-day inactive", generate 200 Klaviyo coupon codes for coupon ID abc123 and write them into column D; for rows where column C says "180-day inactive", generate 200 codes for coupon ID def456 and write them into column E
Some rows already have codes from a previous run and should be skipped
Generate Klaviyo coupon codes for coupon ID abc123 for each subscriber in column A where column B is blank, write the new code into column B, and skip any row that already has a value in column B
Full win-back prep in one shot
For every row in the "Reactivation" sheet where column A has a valid email and column B is blank: generate a unique Klaviyo coupon code using coupon ID abc123, write the code into column B, then write today's date into column C to mark when the code was assigned — output a count of how many codes were generated at the bottom of column B
The campaign-ready sheet — subscriber emails with personalized codes attached — comes from one conversation, not from a polling script and a manual paste.
Try It
Get the 7-day free trial of SheetXAI and open your win-back subscriber sheet, then ask it to generate and assign Klaviyo coupon codes to every row in one pass. Also see how to bulk add subscribers to a Klaviyo list once the campaign is sent.