The Scenario
You work in revenue operations and someone dropped an Excel workbook in your inbox this morning with 300 company domains and a note: "need these segmented into SMB, mid-market, and enterprise before the BDR team's Monday kickoff." It's Friday at 10 AM.
The segmentation criteria are straightforward — under 50 employees is SMB, 50-500 is mid-market, over 500 is enterprise. What's not straightforward is where the data comes from.
The bad version:
- Open RocketReach, search each domain one by one, find the employee count on the company profile, write it to the workbook, move on.
- Domain 30: RocketReach returns a range (201-500 employees) instead of a specific number. You write "201-500" into the employee count column and realize your tier formula is going to break.
- Domain 60: you've been at this for an hour and you're not even 20% through. The BDR team is already asking if the list is ready.
RevOps is supposed to be about making the process work. Not about manually populating 300 rows that a tool should be filling automatically.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Excel workbook. It reads your domain list and pulls employee count data from RocketReach across all rows at once. Open the SheetXAI sidebar:
Here is the prompt for this task:
Enrich the 300 company domains in my 'Account Tiers' sheet (column A) with RocketReach employee counts — write the count to column B and add a tier label (SMB/Mid-Market/Enterprise) to column C
What You Get
- Column B: the numeric employee count from RocketReach for each domain.
- Column C: the tier label applied based on your segmentation criteria.
- Rows where RocketReach returned no company match are flagged so they don't silently fall through the segmentation.
What If the Data Is Not Quite Ready
You want to specify custom tier thresholds
For each domain in column A, get the RocketReach employee count — write the count to column B — then apply this logic and write the tier to column C: under 50 is SMB, 50 to 500 is Mid-Market, over 500 is Enterprise
Some domains are subdomains or have www prefixes that confuse the lookup
Before looking up each domain in RocketReach, strip any www. prefix or known subdomain patterns from the values in column A — write the cleaned domain to a new column B — then run the RocketReach company lookup using the cleaned domain and write employee count to column C
You need to join the tier labels against a second worksheet of account owners
Look up each domain in column A via RocketReach, write employee count to column B and tier label to column C, then check each domain against the 'Account Owners' worksheet and write the assigned BDR name to column D if there is a match
Enrich, tier, and flag high-priority accounts in one shot
For each domain in column A, fetch the RocketReach employee count — write it to column B and the tier to column C — then flag any enterprise accounts (over 500 employees) that also appear in my 'High Value Verticals' list in column D as "Priority"
One prompt handles enrichment, segmentation, and prioritization without a second pass.
Try It
Open your Excel workbook with company domains and Get the 7-day free trial of SheetXAI — ask it to enrich each domain with RocketReach employee counts and write the tier labels. Related reading: the spoke on enriching accounts with tech stack data, or the hub overview for all the ways to connect RocketReach to Excel.