The Scenario
You are three weeks into a new account executive role. The previous AE handed off a Google Sheet with 100 contacts — names, emails, and not much else. Your manager wants you to run a personalized outreach campaign next week, which means you need job titles, seniority levels, and enough company context to write something that doesn't read like a mail-merge.
The handoff sheet has column A for email. That's the whole foundation.
The bad version:
- Open RocketReach and search each email one by one, copy the title, seniority, company name, and employee count into the sheet for each row.
- Row 15: the email returns a match but the company listed is a subsidiary you don't recognize. You write it down anyway and hope it's right.
- Row 40: you realize you forgot to add a company employee count column before you started. You go back to the top and add it. Now you have to re-check the rows you already did.
This is not preparation for an outreach campaign. This is a data project. And data projects do not belong in the AE workflow two weeks before quarter end.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Google Sheet. It reads your contact list and pulls combined person and company data from RocketReach in a single operation — title, seniority, and firmographics together. Open the SheetXAI sidebar:
Here is the prompt for this task:
For each email in column A of my 'Contact List' sheet, call RocketReach to get the person's title, seniority, company name, and company employee count — write results into columns B through E
What You Get
- Column B: job title from the RocketReach person profile.
- Column C: seniority level (Director, VP, C-Suite, etc.).
- Column D: company name as verified by RocketReach.
- Column E: employee count from the RocketReach company profile.
- Rows where RocketReach returned no match are flagged so you know which contacts need manual review.
What If the Data Is Not Quite Ready
Some emails bounced or are clearly invalid
Before enriching, check each email in column A of my 'Contact List' sheet — flag any that are missing an @ sign, use a personal domain like gmail.com or yahoo.com, or appear malformed by writing "Invalid" to column F — then run the RocketReach lookup only for rows that passed
You want industry in addition to company size
For each email in column A of my 'Contact List' sheet, look up the person in RocketReach and write title to column B, seniority to column C, company employee count to column D, and the company's primary industry to column E
You need to join against a second tab of account tiers
Look up each email in column A of my 'Contact List' sheet via RocketReach to get employee count — write it to column D — then check the employee count against the tier definitions in my 'Account Tiers' sheet and write the matching tier label (SMB, Mid-Market, or Enterprise) into column E
Enrich, segment, and draft an outreach signal in one shot
For each email in column A of my 'Contact List' sheet, fetch the RocketReach person and company data — write title to column B, seniority to column C, and employee count to column D — then write a one-sentence outreach signal to column E based on their seniority and company size, such as "Director-level at a 200-person fintech company"
Combining the enrichment and the signal generation in one prompt means your sheet is ready for sequencing without a second pass.
Try It
Open your Google Sheet of contacts and Get the 7-day free trial of SheetXAI — ask it to enrich each email with title, seniority, and company firmographics from RocketReach. Related reading: the spoke on bulk email enrichment, or the hub overview for all the ways to connect RocketReach to Google Sheets.