The Scenario
You're a sales development rep and your pipeline review is Monday morning. Your manager wants your 200-company lead list enriched with employee count and founding year before the call — she says it tells her whether you're targeting the right segment.
You've had this list in column A of your Excel workbook since last Wednesday. Enriching it felt like a "later" task until it became a "this weekend" task.
The bad version:
- Search company 1 on LinkedIn, find the company page, note the employee count and founding year, open another tab to cross-reference on Crunchbase, note the LinkedIn URL, paste three values across columns C, D, and E
- Repeat for company 2, find that LinkedIn shows a range while Crunchbase shows a specific number, decide which to use, write it down
- By company 15 you're skipping the Crunchbase cross-reference because it's adding 90 seconds per row
The review is in 36 hours. You have 185 companies left.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your Excel workbook. It reads your company list and uses its built-in ScrapeGraph AI integration to run SearchScraper on each company name, then writes the enrichment data directly into the columns you specify.
Paste this into the SheetXAI sidebar:
For each company name in column A, use ScrapeGraph AI SearchScraper to find the employee count, founding year, and LinkedIn company URL, then write results into columns C, D, and E
What You Get
- Column C fills with employee counts sourced from public web data
- Column D fills with founding years
- Column E fills with LinkedIn company page URLs
- Companies where SearchScraper returns ambiguous results get the best available value plus a note in column F
What If the Data Is Not Quite Ready
Some company names are ambiguous and match multiple companies
For companies in column A where the employee count in column C was written as a range rather than a single number, add the note "verify" to column F and flag the row for manual review
You need the enrichment segmented by employee band
After writing employee counts to column C, add a column G called Segment: write "SMB" for counts under 50, "Mid-Market" for 50-500, and "Enterprise" for counts above 500
You want to cross-reference founding year against a target cohort
For each company in column A, if the founding year in column D is before 2015, write "Established" in column H; if 2015 or later, write "Founded post-2015"
Full pipeline: enrich, segment, and flag gaps
For all 200 companies in column A: use ScrapeGraph AI SearchScraper to find employee count, founding year, and LinkedIn URL; write to columns C, D, and E; add a Segment label in column F based on employee count (under 50 = SMB, 50-500 = Mid-Market, over 500 = Enterprise); flag any row where SearchScraper returned no result in column G with "missing"; write a summary in cell H1 counting how many rows are in each segment
Your pipeline review now starts with data, not apologies.
Try It
If you have a company list in column A and a pipeline review before the week is out, Get the 7-day free trial of SheetXAI and ask it to enrich your workbook using ScrapeGraph AI SearchScraper. For related enrichment workflows, see bulk scrape competitor pricing or extract all sitemap URLs.