Back to Crustdata in Google Sheets
SheetXAI logo
Crustdata logo
Crustdata · Google Sheets Guide

Bulk Enrich Contact Records With Title and Seniority From a Google Sheet

2026-05-14
5 min read

The Scenario

A conference you sponsored last month just sent you the attendee list as a CSV — 300 rows with first name, last name, and company. Your SDR team wants sequences running by end of week, but the list has no titles, no LinkedIn URLs, and no seniority data. Without that, your reps are going in blind, guessing who is a buyer and who is a coordinator.

The bad version:

  • Open LinkedIn, search each person by name and company, find their current role, and paste the title and profile URL into the sheet
  • Run into three people named "Michael Chen" at companies with common names and spend time figuring out which one attended your session
  • Get through 40 rows on day one, realize the task will bleed into next week, and decide to just send sequences to the full list without enrichment

Sequencing 300 contacts without title data means your reps will waste calls and emails on people who cannot make a buying decision.

The Easy Way: One Prompt in SheetXAI

SheetXAI is an AI agent inside your Google Sheet. It reads your contact list and calls Crustdata's person enrichment endpoint for each row — matching on name and company and returning title, LinkedIn URL, and seniority level.

For each row in my sheet with a person's first name in column A, last name in column B, and company in column C, use Crustdata person enrichment to fill in their current job title in column D, LinkedIn URL in column E, and seniority level in column F. Flag any rows where no match was found in column G.

What You Get

  • Column D: current job title from Crustdata's live dataset
  • Column E: LinkedIn profile URL
  • Column F: seniority level (C-suite, VP, Director, Manager, IC)
  • Column G: a "no match" flag on any row where Crustdata could not resolve the person — so your reps know which contacts need manual review rather than receiving blank cells and guessing

What If the Data Is Not Quite Ready

Some rows have only a first name — the last name column is blank

For rows where column B is blank, attempt Crustdata person enrichment using first name and company name only — write the match confidence into column H and flag any rows where confidence is below 80 percent

The company column has inconsistent formatting — some rows say "Acme" and others say "Acme Inc."

Before running Crustdata enrichment, normalize company names in column C by stripping legal suffixes and extra punctuation, then enrich each contact and write title, LinkedIn URL, and seniority into columns D, E, and F

You want to split the enriched list by seniority tier for different sequence tracks

Use Crustdata to enrich all 300 contacts in this sheet, then create two new sheets: one called Senior Contacts with everyone at Director level or above, and one called IC Contacts with everyone below Director — include name, company, title, and LinkedIn URL in each sheet

One prompt to enrich, score, and route the full list

For each contact in columns A through C, use Crustdata person enrichment to add title, LinkedIn URL, and seniority into columns D, E, and F. Then add a sequence assignment in column H: contacts at VP or above go to "Executive Track", Directors and Managers go to "Mid-Market Track", and everyone else goes to "Broad Track".

The routing logic runs alongside the enrichment in the same pass.

Try It

Get the 7-day free trial of SheetXAI and open your attendee list or inbound lead sheet, then ask it to bulk-enrich every contact row using Crustdata's person data. Once titles and seniority levels are filled in, you can ask it to segment the sheet by tier and prep it for import into your sequencing tool.

Stop memorizing formulas.
Tell your spreadsheet what to do.

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

Learn more