The Scenario
The QBR is at 2 PM. Your VP of Sales wants the full open-pipeline snapshot in a deck — 120 leads, each with stage, estimated value, assigned rep, and creation date. The data lives in Nutshell. The deck template lives in PowerPoint. The bridge between them is an Excel workbook that needs to exist in the next 40 minutes.
The bad version:
- You go into Nutshell, navigate to the leads report, set the filters, and export a CSV.
- The CSV opens in Excel with 23 columns you don't need and dates formatted as Unix timestamps.
- You spend 20 minutes deleting columns, reformatting dates, and reordering the fields to match the template layout.
With 20 minutes to go and the VP pinging you, the workbook is finally ready — but only because you got lucky with the filter settings on the first try.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Excel workbook. It reads the workbook and, through its built-in Nutshell integration, pulls live lead data directly without requiring a CSV export or column cleanup on your part.
Open SheetXAI in the sidebar and ask:
Pull every open lead from Nutshell into my Excel pipeline sheet, then add a summary row at the bottom showing total pipeline value and lead count grouped by stage
What You Get
- One row per open lead, with description, stage, rep, value, and date in clear columns.
- A summary block at the bottom of the worksheet showing total value and lead count per stage.
- No extra columns, no Unix timestamps, no reformatting.
- A live snapshot as of the moment you ran the prompt — ready to paste into a deck or share directly.
What If the Data Is Not Quite Ready
You only want leads above a certain value threshold
Pull all open Nutshell leads with an estimated value above 10000 into this workbook — write description, stage, rep, and value, sorted by estimated value descending
You need to split the view by rep for the exec summary
Fetch all open Nutshell leads and write them into this workbook — after the last data row, add one summary line per assigned rep showing their lead count and total pipeline value
You need a separate worksheet for the summary
Pull all open Nutshell leads into the Pipeline worksheet with description, stage, rep, estimated value, and creation date — then create a Summary worksheet with total pipeline value and lead count grouped by stage and by rep
Full QBR workbook in one shot
Pull all open Nutshell leads, write description, stage, rep, estimated value, and creation date into the Pipeline worksheet, sort by estimated value descending, and build a Summary worksheet with total pipeline value and lead count by stage and by rep — label everything clearly for a QBR audience
When the deck needs to be ready in an hour, describe the full formatted output in a single prompt — not step by step.
Try It
Get the 7-day free trial of SheetXAI and open a blank workbook before your next pipeline review — then ask it to pull the full Nutshell lead list and format it for your audience. You can also pull a won/lost conversion report by rep or build a forward-looking revenue forecast the same way.