The Scenario
Your growth team wrapped a successful product launch campaign. The VP of Growth wants to send a $25 spot bonus to the 80 top-performing referral members who drove the most signups during the campaign window. The list is already in an Excel workbook — member IDs in column A, reward amounts in column B, reward rule ID in column C.
What's not in the workbook yet: any of the actual rewards issued in Referral Rock.
The bad version:
- Open Referral Rock, navigate to the manual reward issuance screen.
- Enter the member ID, select the reward rule, type the amount, confirm.
- Repeat 80 times, in a browser tab that times out if you step away for more than 15 minutes.
Eighty manual entries, each requiring three field fills and a confirmation click. The last ten are always the ones with typos.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Excel workbook. It reads the member IDs, reward amounts, and rule IDs from your workbook and issues each reward through Referral Rock in one pass.
Issue a reward to each member in this worksheet using member ID in column A, reward amount in column B, and reward rule ID in column C, then write the result of each issuance into column D
What You Get
- Column D fills with "issued" or an error note for each of the 80 rows.
- All rewards go through in one operation — no browser timeout, no mid-task restart.
- Failed rows get a specific error in column D so you can investigate the exceptions without re-running the full set.
What If the Data Is Not Quite Ready
The reward amounts in column B need to be formatted as cents rather than dollars
Issue rewards to each member in this worksheet using member ID from column A and rule ID from column C; multiply the dollar amount in column B by 100 to convert to cents before sending, and write the result into column D
You only want to issue rewards to members with "active" status and need to check first
For each row in this worksheet, verify the member status in Referral Rock using member ID in column A — only issue the reward if status is "active", using amount from column B and rule ID from column C; write "issued" or "skipped (inactive)" into column D
The rule ID is the same for all 80 rows and lives in a single header cell instead of column C
Issue a reward to every member in this worksheet using member ID from column A, reward amount from column B, and rule ID from cell E1, then write the result into column C
Validate amounts, skip ineligible members, issue rewards, and summarize in one shot
In this worksheet, skip any row where column B is blank or zero; for remaining rows, issue a reward to the Referral Rock member in column A using amount from column B and rule ID from column C; write the result into column D; then write a summary into cell F1 showing total rewards issued and total dollar value
A single prompt that ends with a summary cell means the VP of Growth gets the confirmation number without a separate count.
Try It
Open your post-campaign bonus workbook and get the 7-day free trial of SheetXAI. Ask it to issue all 80 spot bonuses to Referral Rock members in one pass. Related tasks: exporting rewards data for liability reporting and fetching pending payout data for AP reconciliation — both in the Referral Rock hub.