The Scenario
Your campaign landing page ran for three weeks and collected 40 inbound form submissions. Each one is sitting in an Excel workbook — company name, contact email, estimated deal value, source, and the rep each should go to based on territory. Your job is to get all 40 into Nutshell as leads before the sales team starts their Monday calls.
The bad version:
- You open Nutshell, click "New Lead," and start filling in the first form — description, estimated value, source, pipeline, assigned rep.
- Six fields per record. Forty records. You get through 11 before you realize you forgot to set the pipeline on the first three and have to go back.
- Two hours later, the leads are in. Three have duplicate contact records because the email already existed in Nutshell and the import wizard didn't warn you.
The marketing team is already asking for confirmation. You're still clicking.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Excel workbook. It reads your inbound sheet and, through its built-in Nutshell integration, creates all 40 leads in one operation — linking each to an existing contact if one already exists.
Open SheetXAI in the sidebar and ask:
Read my Excel inbound-inquiry sheet (Company, Contact Email, Deal Value, Source, Assigned Rep) and bulk-create one Nutshell lead per row, linking each to the matching contact if one already exists
What You Get
- One Nutshell lead per row, created with description, value, source, and rep assignment from your workbook.
- Existing contacts matched by email and linked to the new lead automatically — no duplicates created.
- Returned lead IDs written into a result column so you can track which rows succeeded.
- Rows that fail — missing required field, invalid rep name — flagged with an error note rather than silently skipped.
What If the Data Is Not Quite Ready
Rep names in the workbook don't match Nutshell exactly
Before creating leads, check that each rep name in the Assigned Rep column matches a Nutshell user — for any that don't match, write NO MATCH in the result column and skip that row
Deal values are formatted inconsistently
Normalize the Deal Value column before creating leads — strip dollar signs and commas, convert any ranges to the midpoint, then bulk-create the Nutshell leads with the cleaned values
Some submissions came from the same company and should share an account
Create Nutshell leads for all 40 rows — group contacts by company name, create one company account per unique company before linking contacts, then create the lead records
Full inbound-to-CRM pipeline in one shot
Normalize deal values, check rep names against Nutshell users and flag mismatches, group contacts by company to avoid duplicate accounts, then bulk-create all valid Nutshell leads and write the lead ID or error into the result column
When the sales team needs leads loaded before Monday morning, describe the full operation in one prompt.
Try It
Get the 7-day free trial of SheetXAI and open your next campaign response workbook — then ask it to push every row into Nutshell as a lead. You can also bulk-import contacts, bulk-tag leads for pipeline segmentation, or bulk-update lead statuses after deals close.