The Scenario
You run an ambassador program for a B2B software company. Every month you recognize the top 50 referrers in a leaderboard shared with the whole community. Last month you built it by hand: opened Referral Rock, looked up each ambassador individually, wrote the stats into an Excel workbook, sorted by referrals generated. It took the better part of a Friday afternoon.
The community newsletter goes out Monday morning. It is Thursday.
The bad version:
- Open Referral Rock, search for each of the 50 member IDs in your workbook one at a time.
- Copy shares, referrals generated, and rewards earned from each profile into the correct row.
- Sort the workbook, notice two members have the same referral count, go back and verify the tie-break stat manually.
Fifty lookups, one at a time, with tab-switching between every one of them. By row 30 you're making copy-paste errors you won't catch until someone flags the wrong name at the top of the leaderboard.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Excel workbook. It reads the member IDs already in your workbook and fetches stats from Referral Rock for all of them in one operation.
Look up detailed stats for each member ID in column A of the Leaderboard worksheet and write their total shares into column B, referrals generated into column C, and rewards earned into column D, then sort the rows by column C descending
What You Get
- Columns B, C, and D fill with live stats for each of the 50 member IDs.
- The rows sort by referrals generated descending — leaderboard order, ready to share.
- Any member ID that returned no data gets a note in column E so you can investigate without guessing which rows are missing.
What If the Data Is Not Quite Ready
You have member emails instead of member IDs in your workbook
For each email in column A of the Leaderboard worksheet, look up the corresponding Referral Rock member and write their total shares, referrals generated, and rewards earned into columns B, C, and D
You want stats filtered to the last 30 days only
Fetch Referral Rock stats for each member ID in column A scoped to the last 30 days, write total shares into column B, referrals generated into column C, and rewards earned into column D
Some member IDs in column A are blank or contain placeholder text
Look up Referral Rock stats for each member ID in column A — skip any row where column A is blank or contains the text "TBD" — and write shares, referrals, and rewards into columns B, C, and D
Deduplicate the member list, fetch stats, and rank in one shot
Remove any duplicate member IDs from column A of the Leaderboard worksheet, fetch total shares, referrals generated, and rewards earned from Referral Rock for each unique ID, write results into columns B through D, and sort by column C descending
Combining the dedup and the fetch in one prompt means you receive a clean, sorted leaderboard without a separate cleanup pass.
Try It
Open the Excel workbook you use for your ambassador leaderboard and get the 7-day free trial of SheetXAI. Ask it to fetch stats for each member ID and sort by referrals generated. For related tasks, see how to export the full member roster and how to bulk-enroll new members — both in the Referral Rock hub overview.