The Scenario
You inherited a lead list from a sales rep who left in February. One hundred company website URLs in column A of an Excel workbook. No LinkedIn. No Twitter. No contact info. Just domains.
Your outreach tool needs social profile URLs to personalize sequences. Without them, you are sending generic messages. Your manager noticed the reply rate drop last quarter and asked what changed.
The bad version:
- Open each company website, look for a LinkedIn icon in the footer or header, right-click to copy the URL — except twenty of the sites have no social icons at all, and another ten link to broken or placeholder profiles
- Search LinkedIn manually for the ones where the footer link was missing — four searches in, you realize you cannot always tell which LinkedIn page matches the company versus a subsidiary or a similarly-named business
- Build a "needs manual research" list as you go, which ends up being 40 rows — meaning you still have 40 companies that need another pass
Your outreach sequence starts Monday. Forty unresolved rows means forty generic emails going out to leads you were supposed to have personalized.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Excel workbook. It reads the lead list, understands the URL column, and through its built-in ScrapingAnt integration it scrapes each company's homepage and extracts any social profile links it finds — then writes the results back with clear flags for anything it could not resolve.
Open the SheetXAI sidebar and ask:
For each website URL in column A, use ScrapingAnt to scrape the page and extract any LinkedIn and Twitter/X profile URLs, writing them into columns B and C, and put "Manual Research Needed" in column D for rows where neither was found
SheetXAI processes each URL through ScrapingAnt, parses the rendered page for social link patterns, and writes the results back. Column B fills with LinkedIn URLs. Column C fills with Twitter/X URLs. Rows where neither was found get flagged in column D so you know exactly which leads need a manual pass.
What You Get
- Column B: LinkedIn profile URL or blank if not found on the scraped page
- Column C: Twitter/X profile URL or blank if not found
- Column D: "Manual Research Needed" for any row where both columns B and C are empty
- A clean split between leads you can sequence immediately and leads that need one more look
What If the Data Is Not Quite Ready
Some company domains redirect to a subsidiary or regional site before the homepage loads
For each URL in column A, use ScrapingAnt with redirect following enabled, scrape the final resolved page, and extract LinkedIn and Twitter URLs from the rendered HTML
The lead list has duplicate company domains — deduplicate before scraping
Before scraping, check column A for duplicate domain values and flag any duplicates in column E with "DUPLICATE — skip"; then for all non-flagged rows, scrape for LinkedIn and Twitter URLs and write into columns B and C
Some LinkedIn URLs scraped are for individual employees, not the company page
For each LinkedIn URL found in column B, check whether the URL path starts with "/company/" and if not, overwrite column B with "Individual profile — verify" so the sales team knows to replace it
Full enrichment pass in one ask: scrape, classify, flag, and rank
For each URL in column A, use ScrapingAnt to extract LinkedIn URL into column B, Twitter URL into column C, and also look for a phone number or email address and write it into column E; flag "Manual Research Needed" in column D for any row missing both LinkedIn and Twitter; then in column F write "High" if LinkedIn was found and "Low" if neither social profile was found
One prompt handles the scraping, enrichment, and prioritization in a single pass.
Try It
If your lead list is sitting in an Excel workbook with nothing but company URLs — Get the 7-day free trial of SheetXAI and ask it to pull LinkedIn and Twitter links from every row using ScrapingAnt. Related reads: how to scrape competitor pricing into a workbook, and the full ScrapingAnt hub for more use cases.