The Scenario
Your campaign landing page ran for three weeks and collected 40 inbound form submissions. Each one is sitting in a Google Sheet — 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 that the leads are loaded. You're still clicking.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Google Sheet. 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:
Create a Nutshell lead for each row in this sheet using description from column A, estimated value from column B, source from column C, and assign to the rep in column D — write the returned lead ID into column E
What You Get
- One Nutshell lead per row, created with description, value, source, and rep assignment from your sheet.
- Existing contacts matched by email and linked to the new lead automatically — no duplicates created.
- Returned lead IDs written into column E so you can track which rows succeeded.
- Rows that fail — missing required field, invalid rep name — flagged with an error note in column E rather than silently skipped.
What If the Data Is Not Quite Ready
Rep names in your sheet don't match Nutshell exactly
Before creating leads, check that each rep name in column D matches a Nutshell user — for any names that don't match, write NO MATCH in column E and skip that row rather than assigning to the wrong person
Deal values are formatted inconsistently
Normalize the values in column B before creating leads — strip dollar signs and commas, convert any ranges like "10k-20k" 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 in column A, 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 in column B, check rep names in column D against Nutshell users and flag any mismatches, group contacts by company to avoid duplicate accounts, then bulk-create all valid Nutshell leads and write the lead ID or error into column E
When the sales team needs leads loaded before Monday morning, describe the full operation — the normalization, the validation, the creation — in one prompt.
Try It
Get the 7-day free trial of SheetXAI and open your next campaign response sheet — 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.