The Scenario
You're the demand gen manager for a B2B SaaS company, and the growth team's VP of Marketing LinkedIn campaign kicks off in six days. You need 200 verified contacts — VP of Marketing at US SaaS companies with 50 to 500 employees — dropped into a Google Sheet with name, email, company, and LinkedIn URL. Your usual approach is to buy a list from a data vendor, wait two days for delivery, clean out the bad emails, and hope the company-size filter was applied correctly.
The bad version:
- Submit a list request to your data vendor, wait 48 hours, download a CSV with 400 rows.
- Open the file, filter for the right size range, discover the vendor included Canadian companies despite the "US only" filter, manually delete 80 rows.
- Import the cleaned list into your email validator, wait another hour, find that 30% of the emails failed verification.
The campaign brief needed to go to copy yesterday. You are sitting here managing a vendor relationship when the data is already in Lemlist's database.
The Easy Way: One Prompt in SheetXAI
SheetXAI connects directly to Lemlist's built-in B2B people database, so you can search with exact filters and write results into your Google Sheet in one step — no vendor, no waiting period, no separate validation step.
Search the Lemlist people database for VP of Marketing contacts at US SaaS companies with 50 to 500 employees and write first name, last name, email, company, and LinkedIn URL into columns A through E for the first 200 results
What You Get
- Up to 200 rows written starting from row 1, each containing first name, last name, email address, company name, and LinkedIn profile URL.
- Results already filtered by title, country, industry, and company size — no post-download cleanup needed.
- Any result without a verified email either omitted or flagged, depending on how you phrase the prompt.
- Your Google Sheet populated and ready to hand off to sequencing or copy within minutes.
What If the Data Is Not Quite Ready
You need a different persona or geography
Search the Lemlist people database for CTOs at fintech companies in Europe with fewer than 100 employees and write first name, last name, email, and company name into columns A through D — one row per contact
You only want results where a LinkedIn URL is present
Search Lemlist for VP of Marketing contacts at US SaaS companies with 50 to 500 employees — write first name, last name, email, company, and LinkedIn URL into columns A through E, but only include rows where a LinkedIn URL was returned
You want to tag each result with the search filter that found them
Search the Lemlist people database for two segments: VP of Marketing at SaaS companies with 50 to 200 employees (tag: "SMB") and VP of Marketing at SaaS companies with 201 to 500 employees (tag: "Mid-Market") — write all results into this sheet with name, email, company, LinkedIn URL, and segment tag
Full search plus duplicate check in one shot
Search Lemlist for VP of Marketing contacts at US SaaS companies with 50 to 500 employees, write first name, last name, email, company, and LinkedIn URL into columns A through E — then check each email against the existing list in Sheet2 Column A and mark duplicates in Column F as "EXISTING"
The pattern is to describe the filters, the fields, and any post-search check in a single prompt. You get a clean, deduplicated sheet without touching the data yourself.
Try It
Get the 7-day free trial of SheetXAI and open the Google Sheet where your prospect lists live, then ask SheetXAI to search Lemlist's people database with whatever persona and geography your next campaign targets. See also: how to enroll your new list into a campaign, or return to the hub overview.