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 Google Sheet 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 ("51-200 employees") 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 Google Sheet. 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 so you know which rows to verify manually before the review
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 sheet using ScrapeGraph AI SearchScraper. For related enrichment workflows, see bulk scrape competitor pricing or extract all sitemap URLs.