The Scenario
The marketing director sends a message Thursday afternoon: she needs the full referral program member roster — statuses, referral counts, and pending reward balances — in a sheet by Friday morning for the quarterly program review she's presenting to the exec team.
You go to Referral Rock, find the Members export, download the CSV, open it in Sheets, and realize the columns are in the wrong order and the reward balance is formatted as a string with a dollar sign baked in. Fixing it takes 20 minutes. Then she replies: can you add the sign-up date? You go back, re-export, and start over.
The bad version:
- Export the member list as CSV from the Referral Rock dashboard.
- Reformat column order, strip currency symbols, convert date strings to match the sheet's existing format.
- Re-export every time a new field is requested, discarding your formatting work.
There's a quarterly review at 9 AM. You could spend the evening doing three rounds of this, or you could spend three minutes on it.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Google Sheet. It reads the sheet and talks to Referral Rock directly — no CSV export, no reformatting step.
Pull all Referral Rock members for our program with their status, referral code, sign-up date, and pending reward balance into this sheet, starting at row 2, with headers in row 1
What You Get
- Row 1 gets clean column headers: Member Email, Status, Referral Code, Sign-Up Date, Pending Reward Balance.
- Data fills from row 2 downward — one row per member, up to the full 1,200.
- The pending reward balance arrives as a number, not a string with currency formatting baked in.
- The sheet is ready for pivot tables or filtering the moment the prompt completes.
What If the Data Is Not Quite Ready
You only want active members, not cancelled or paused ones
Fetch all Referral Rock members with status "active" and write their email, referral code, sign-up date, and pending reward balance into columns A through D of this sheet
You need members across multiple programs and want a program column
Pull members from all our Referral Rock programs and write email, program name, status, referral code, and sign-up date into columns A through E — one row per member
The sheet already has data in rows 1 through 50 and you want to append below it
Starting at the first empty row in this sheet, import all active Referral Rock members with their email, referral code, and pending balance — do not overwrite existing rows
Clean member emails, flag zero-balance rows, and pull the roster in one shot
Pull all Referral Rock members into this sheet with email, status, referral code, and pending reward balance; lowercase all emails in column A; mark any row where the pending balance is 0 with "no balance" in column E
One prompt handles the pull, the formatting, and the flag so you don't need a second pass before handing the sheet to the director.
Try It
Open the Google Sheet you use for program reviews and get the 7-day free trial of SheetXAI. Ask it to pull your full Referral Rock member roster into the sheet. For next steps, see how to export per-member stats for a leaderboard or how to pull the full referrals pipeline — both linked in the hub overview.