The Scenario
You sell HR software. Your target is fast-growing companies that are hiring fast enough to have real pain. You have a list of 300 account domains in a Google Sheet — your total addressable pool for this quarter. Before you can prioritize the outreach calendar, you need to know which ones are actually growing.
Your manager wants the top 100 fastest-growing accounts segmented and ready for the BDR team by Friday.
The bad version:
- Open RocketReach for the first domain, navigate to the company profile, find the growth metrics section, read the headcount growth percentage, copy it, switch back to Sheets, find the right row, paste it. Repeat 299 more times.
- Domain 25: RocketReach shows a 6-month metric but not a 12-month one. You're not sure whether to use the shorter window. You pick 12 months and leave domain 25 blank.
- Domain 60: the growth percentage is negative. You flag it mentally as "shrinking" and realize you have no column for that yet.
You are a venture sales rep. You should be calling the people on the list, not building the list from scratch by hand every quarter.
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 headcount growth metrics from RocketReach across all 300 rows at once. Open the SheetXAI sidebar:
Here is the prompt for this task:
For each company domain in column A of my 'Target Accounts' sheet, fetch the RocketReach growth metrics and write the headcount growth percentage over the last 12 months into column B
What You Get
- Column B: the 12-month headcount growth percentage from RocketReach for each domain.
- Rows where RocketReach returned no growth data are flagged clearly so they don't silently fall out of your ranking.
- All 300 rows enriched in one pass.
What If the Data Is Not Quite Ready
You want to sort by growth rate immediately after enrichment
For each domain in column A of my 'Target Accounts' sheet, fetch the RocketReach 12-month headcount growth percentage and write it to column B — then sort the entire sheet by column B descending so the fastest-growing accounts appear at the top
You want to pull both 6-month and 12-month signals
For each domain in column A, fetch RocketReach growth metrics and write the 6-month headcount growth rate to column B and the 12-month rate to column C — flag any account where the 6-month rate is more than 10 percentage points higher than the 12-month rate as "Accelerating" in column D
You want to combine growth signal with employee count to filter out micro-companies
For each domain in column A, fetch the RocketReach employee count and write it to column B, then fetch the 12-month headcount growth rate and write it to column C — filter out any company with fewer than 25 employees and write "Too Small" to column D for those rows
Enrich with growth rate, rank, and draft a prioritization note in one shot
For each domain in column A of my 'Target Accounts' sheet, fetch the RocketReach 12-month headcount growth percentage — write it to column B — rank all 300 accounts by growth rate and write the rank to column C — then write a one-line priority note to column D for the top 50 accounts, for example: "Growing 45% YoY — strong ICP signal for headcount-driven HR pain"
One prompt builds the data, ranks the accounts, and generates the prioritization notes your BDR team can actually use without opening another tool.
Try It
Open your Google Sheet with target account domains and Get the 7-day free trial of SheetXAI — ask it to pull headcount growth metrics from RocketReach and surface your fastest-growing prospects. Related reading: the spoke on enriching accounts with funding data, or the hub overview for all the ways to connect RocketReach to Google Sheets.