Back to Bettercontact in Excel
SheetXAI logo
Bettercontact logo
Bettercontact · Excel Guide

Find Net-New Leads by Criteria in a Google Sheet and Write Them Back Automatically

2026-05-14
5 min read

The Scenario

You inherited a territory three weeks ago. The previous AE left a notes file, a handoff doc, and zero qualified contacts. Your manager wants a pipeline update by Friday. You need 150 VP of Engineering contacts at US software companies with 50–500 employees — verified emails, ready to sequence — and you need them in the workbook your manager already has access to, not in a separate tool nobody else can see.

The bad version:

  • Log into Bettercontact's Lead Finder UI, manually enter the search criteria, scroll through results, select the ones that match your ICP, export to CSV, open the CSV, reformat columns to match the existing workbook structure, and paste them in
  • Realize the export doesn't include LinkedIn URLs, go back into the UI and re-export with different settings, then re-paste and reconcile the duplicate rows that appeared because you ran two exports
  • Spend Friday morning doing this instead of the actual outreach prep your manager assumed was finished

The workbook was supposed to be the output, not a final step you still have to do manually. Your manager checks it during the sync and right now it has 11 rows in it.

The Easy Way: One Prompt in SheetXAI

SheetXAI is an AI agent inside your Excel workbook. It talks to Bettercontact's Lead Finder directly, runs the search based on your criteria, and writes the discovered leads — with verified contact fields — into your workbook. You don't leave the spreadsheet.

Find 150 VP of Engineering leads at US software companies with 50–500 employees — return first name, last name, company, email, LinkedIn URL — and write them into this workbook starting at row 2

What You Get

  • Rows 2–151 fill with discovered leads matching the search criteria
  • Each row includes first name, last name, company name, verified work email, and LinkedIn URL in the columns SheetXAI assigns (or the ones you specify)
  • If Bettercontact's Lead Finder returns fewer than 150 results for those exact criteria, SheetXAI notes the actual count and which criteria could be loosened to fill the gap
  • Duplicate emails are not written — if a lead from a previous search already exists in the workbook, the new row is skipped

What If the Data Is Not Quite Ready

You want to search by multiple seniority levels at once

VP is the target, but you'd also take Director and Head of Engineering.

Find leads at US software companies with 50–500 employees where job title is VP of Engineering, Director of Engineering, or Head of Engineering — write first name, last name, company, email, LinkedIn URL into this workbook and deduplicate by email

Your criteria live in the workbook itself

You have a worksheet called "Search Params" with columns for job title, industry, company size range, and country — one row per search segment you want to run.

For each row in the "Search Params" worksheet, run a Bettercontact Lead Finder search using the values in col A (job title), col B (industry), col C (company size), col D (country) — append all discovered leads into the "Results" worksheet and deduplicate by email across all searches

You want to exclude companies you already have in the CRM

There's a "Current Accounts" worksheet with a list of company domains you don't want to target again.

Find 150 VP of Engineering leads at US software companies with 50–500 employees, but exclude any company whose domain appears in the "Current Accounts" worksheet (col A) — write results into this workbook

The kill chain — search, deduplicate, enrich, and sequence-ready in one shot

For each row in the "Search Params" worksheet (job title col A, industry col B, company size col C, country col D): run a Bettercontact Lead Finder search, append results to the "Leads" worksheet, deduplicate by email, enrich any rows where phone is missing, add a "Status" column set to "Ready" for rows with both email and phone, and sort so "Ready" rows appear first

One prompt. No CSV downloads, no worksheet reconciliation, no reformatting.

Try It

If you're building a prospect list from scratch and the criteria already exist in your workbook, Get the 7-day free trial of SheetXAI and ask it to run a Lead Finder search and write the results back. Or see how to bulk enrich an existing list, and check the Bettercontact overview for the full picture.

Stop memorizing formulas.
Tell your spreadsheet what to do.

Join 4,000+ professionals saving hours every week with SheetXAI.

Learn more