The Scenario
Your sales team closed 25 deals this week — some won, some lost. Each one is in an Excel workbook with the lead ID, the outcome, the close reason, and the competitor involved where relevant. Your manager wants all of them updated in Nutshell before the Monday morning pipeline sync. You have 25 records and no appetite for clicking through each one.
The bad version:
- You open Nutshell, search for the first lead ID, open the record, change the status to Won or Lost, select the outcome reason from the dropdown, save.
- Four clicks minimum per record. Twenty-five records. That's 100 clicks in the best case, before the search step.
- Halfway through, you realize the dropdown options in Nutshell don't match exactly what your reps wrote in the workbook. You spend 10 minutes cross-referencing.
The deals are done. The admin work is what's standing between you and the weekend.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Excel workbook. It reads the deal-close workbook and, through its built-in Nutshell integration, updates all 25 lead statuses in one operation.
Open SheetXAI in the sidebar and ask:
Read my Excel deal-close sheet (Lead ID, Won or Lost, Competitor, Close Reason) and bulk-update each Nutshell lead status with the matching outcome and competitor map
What You Get
- All 25 Nutshell leads updated to their correct final status — won or lost.
- Outcome reasons applied where the field accepts free text.
- Competitor names logged to the lead's competitor map where present.
- Any lead IDs that don't match a Nutshell record flagged in a result column rather than silently skipped.
What If the Data Is Not Quite Ready
Outcome reasons don't match Nutshell's dropdown values
Before updating lead statuses, check each close reason against the valid Nutshell outcome reason options — for any that don't match exactly, use the closest available option and note the substitution in the result column
The workbook includes some leads still in negotiation
Only update Nutshell leads where the Won or Lost column clearly says won or lost — skip rows where it is blank or says pending, and write SKIPPED in the result column for those rows
Competitor data needs to be logged alongside the outcome
Update each lead status using the Won or Lost column for outcome and the Close Reason column for reason — for rows with a value in the Competitor column, also add the competitor to the lead's competitor map in Nutshell
Full deal-close batch in one shot
Skip rows where the outcome column is blank or pending, map close reasons to the closest valid Nutshell option and note substitutions, log competitor names where present, then update all remaining lead statuses in one operation
When the pipeline sync is Monday morning, describe the full close operation in a single prompt.
Try It
Get the 7-day free trial of SheetXAI and open your next deal-close workbook — then ask it to push all the status updates to Nutshell at once. You can also pull a won/lost conversion report by rep or export the full pipeline for a QBR.