The Scenario
You're a partnerships manager at a creator economy platform and you're building a micro-influencer program on Reddit. A junior team member pulled together 30 Reddit usernames from community posts, newsletters, and a few competitor comment sections. The names are in column A of your Excel workbook. Before you reach out to any of them, you need to know whether they're worth engaging: total karma, breakdown between post and comment karma, account age. Anything under 1,000 total karma or under a year old gets filtered out. You're supposed to have a shortlist ready for the weekly agency call tomorrow.
The bad version:
- Open Reddit in a tab, type each username into the search bar or manually visit reddit.com/user/username for each one, note the karma numbers and account creation date, switch back to the workbook, type them in
- Do this 30 times, realize halfway through that four of the usernames have been deleted or suspended and you have no idea what to write for those rows
- Spend 20 minutes formatting the karma numbers because some come with commas and some don't
The agency call is tomorrow. The shortlist should already be done.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Excel workbook. It reads the usernames in column A and through its built-in Reddit integration it can fetch the profile data for each one and write it directly into adjacent columns.
For each Reddit username in column A, fetch the user's profile and write total karma, post karma, comment karma, and account creation date into columns B through E — if the account is deleted or suspended, write "Unavailable" in column B
What You Get
- Column B: total karma
- Column C: post karma
- Column D: comment karma
- Column E: account creation date
- Deleted, suspended, or shadow-banned accounts flagged with "Unavailable" in column B rather than left blank
What If the Data Is Not Quite Ready
You want account age in months or years, not just the creation date
The raw date is hard to read at a glance when you're scanning 30 rows.
For each Reddit username in column A, fetch total karma, post karma, comment karma, and account creation date — write them into columns B through E — then in column F calculate and write how many months the account has been active rounded to the nearest month
Some usernames have "u/" prefixes that need to be stripped first
The list was copied from comment threads and half the entries start with "u/".
For each entry in column A, strip the "u/" prefix if present — then fetch total karma, post karma, comment karma, and account creation date for each cleaned username and write them into columns B through E
You want to apply your eligibility filter inline
Instead of filtering manually after the pull, you want a pass/fail column applied during the enrichment.
For each Reddit username in column A, fetch total karma, post karma, comment karma, and account creation date — write them into columns B through E — in column F write "Eligible" if total karma is above 1,000 and the account is more than 12 months old, otherwise write "Ineligible"
Full vetting pipeline: enrich, filter, and surface top candidates in one pass
For each Reddit username in column A, fetch total karma, post karma, comment karma, and account creation date — write them into columns B through E — in column F write "Eligible" if total karma is above 1,000 and account age is over 12 months, otherwise "Ineligible" — sort the rows so all Eligible accounts appear first ordered by total karma descending
One prompt delivers the enriched, filtered, and sorted shortlist your agency call needs without a separate sort step.
Try It
Get the 7-day free trial of SheetXAI and open any Excel workbook with Reddit usernames in column A, then ask it to pull the karma data and flag each account as eligible or ineligible for your outreach program. Related spoke: Identify Top Commenters on a Reddit Post. Back to the overview: Reddit + Excel.