The Scenario
You're launching a partner program with 50 partners. Each partner gets a unique promo code to share with their audience — 15% off, code name based on the partner's brand name. The code names are already in Column A of an Excel workbook. You need every code created in Lemon Squeezy and the returned discount IDs written back to Column B so your partner ops platform can distribute them.
Creating 50 discount codes manually in the Lemon Squeezy dashboard means 50 form submissions — code name, percentage, expiry, save. If you make a typo on code 23, you delete it and start that one over.
The bad version:
- Start clicking Create Discount in the Lemon Squeezy dashboard
- Enter the code name from Column A row 1, set 15% off, set the expiry
- Copy the returned discount ID into Column B row 1
- Repeat 49 more times, switching between the browser and the workbook for every row
- Make a typo on code 31 (wrong percentage), delete it, recreate it, update Column B
Fifty codes. Fifty form submissions. Three hours that should have been thirty seconds.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Excel workbook. It reads Column A and connects to Lemon Squeezy through its built-in integration to create all 50 discount codes and write the returned IDs back.
Generate 50 Lemon Squeezy discount codes using the code names in Column A, all set to 15% off and expiring in 30 days — write each discount ID back into Column B
What You Get
- Column B: the Lemon Squeezy discount ID for each created code
- All 50 codes created with the same settings (15% off, 30-day expiry) in a single pass
- Error messages written to Column B for any row that failed, so you can identify and fix them
What If the Data Is Not Quite Ready
You want a fixed 20% instead of 15%
Create a Lemon Squeezy discount for each row in Column A using that value as the coupon code with 20% off for store ID in cell B1 — write the returned discount ID into Column B
Different partners have different discount percentages
Create a Lemon Squeezy discount for each row in this workbook using the code name in Column A and the percentage in Column B — write the returned discount ID into Column C and any errors into Column D
You want to skip rows where Column B already has a value
For each row where Column B is blank, create a Lemon Squeezy discount using the code name in Column A with 15% off expiring in 30 days — write the returned ID into Column B
Full partner campaign setup in one shot with summary
Create a Lemon Squeezy discount code for each row in Column A using the code name as-is, set to 15% off with an expiry of June 30, 2026 — write the returned discount ID into Column B, any errors into Column C, and after all rows are done write a count of successes into cell E1
Fifty codes. Partner program launch ready this afternoon.
Try It
Get the 7-day free trial of SheetXAI and open the Excel workbook with your partner code names, then ask it to create all the Lemon Squeezy discounts and write the IDs back. You can also pull discount redemption data later to track which partner codes drove the most revenue.