The Scenario
Your sales development team just finished a verification run. Three hundred confirmed prospects are sitting in an Excel workbook — email, first name, last name, company, lead source — ready for an email sequence. Before the sequence starts, your ops lead wants every one of them created as a Hunter lead, assigned to the named list for their SDR's territory. The list names are in cells F1 through F4.
Doing this one by one in Hunter's UI is not a real option. There are 300 rows.
The bad version:
- Open Hunter's leads section, click "Add lead," fill in email, first name, last name, company, lead source, assign to list. Save.
- Go back. Click "Add lead." Fill in the same fields. Save.
- 300 times. At 90 seconds per entry that's 7.5 hours. Your right index finger will remember this week for the rest of your career.
This work exists to set up the sequence. It is not the sequence.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Excel workbook. It reads your prospect data and through its Hunter integration it can create Hunter leads in bulk, assign them to named lists, and handle the field mapping without you opening Hunter's UI once.
For each row in this Excel file, upsert a Hunter lead with the email in column A and attributes from columns B–E, creating a new leads list from cell G1 if it doesn't already exist.
What You Get
- Every row in your workbook created as a Hunter lead with the correct email, name, company, and lead source fields.
- All leads assigned to the specified list — or the appropriate territory list based on a column mapping.
- A status column written back to the workbook indicating "created," "updated," or "error" for each row.
What If the Data Is Not Quite Ready
Leads need to go to different lists based on their territory
You have four SDRs with their own Hunter lists, and column E has the territory name for each lead.
Create a Hunter lead for every row using email in column A, first name in column B, last name in column C, and company in column D. Assign each lead to the Hunter list whose name matches the territory in column E. If a list doesn't exist yet, create it. Write the assigned list name and creation status (existing or new) to column F.
Some rows might already exist as Hunter leads and you want to update, not duplicate
Your list includes a mix of net-new prospects and re-engaged contacts from last quarter.
For each row, check if a Hunter lead already exists with the email in column A. If it does, update the company to column D and add a note with the lead source from column E. If it doesn't exist, create a new lead with all fields from columns A–E and assign it to the list in cell F1. Write "updated" or "created" to column G for each row.
You want to add custom attributes beyond the standard fields
Hunter's leads support custom attributes. You have a column H with an "ICP score" that your ops lead wants attached to each lead record.
Create a Hunter lead for every row using email in column A, first name in column B, last name in column C, and company in column D. Assign all leads to the list in cell F1. For each lead, also set a custom attribute called "ICP score" with the value from column H. Write confirmation status to column I.
You want verification + lead creation + list assignment in one shot
You're not confident the list has been verified recently and you don't want unverified emails in your Hunter sequences.
For each row in my workbook, first verify the email in column A with Hunter. If the verification status is VALID, create the lead with first name from column B, last name from column C, company from column D, and assign it to the list in cell F1. If the status is RISKY or INVALID, write the status to column E and skip the lead creation. Write "created" or "skipped: [reason]" to column F for every row.
Combining verification and creation in one prompt means your Hunter leads list starts clean — no bounce risk baked in from day one.
Try It
Get the 7-day free trial of SheetXAI and open any Excel workbook where you have a verified prospect list ready to push into Hunter as leads. Ask SheetXAI to create them in bulk and assign them to the right lists. See also bulk email verification or return to the Hunter overview.