The Scenario
You work in revenue operations and someone dropped a Google Sheet 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 sheet, 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 Google Sheet. It reads your domain list and pulls employee count data from RocketReach across all rows at once — then applies the segmentation logic you specify. Open the SheetXAI sidebar:
Here is the prompt for this task:
For each company domain in column A of my 'Target Accounts' sheet, look up the company in RocketReach and write the employee count into column B and the size range into column C
What You Get
- Column B: the numeric employee count from RocketReach for each domain.
- Column C: the RocketReach size range label (1-10, 11-50, 51-200, 201-500, 501-1000, 1001-5000, 5001+).
- Rows where RocketReach returned no company match are flagged in a separate column so they don't silently fall through the segmentation.
What If the Data Is Not Quite Ready
You want SheetXAI to apply the tier logic directly
For each domain in column A of my 'Target Accounts' sheet, 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 sheet of account owners
Look up each domain in column A of my 'Target Accounts' sheet via RocketReach, write employee count to column B and tier label to column C, then check each domain against the 'Account Owners' sheet 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 of my 'Target Accounts' sheet, 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 Google Sheet 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 Google Sheets.