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 Slides. The bridge between them is a Google Sheet 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 Sheets 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 on Slack, the sheet 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 Google Sheet. It reads the sheet 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:
Fetch all open leads from Nutshell and write lead description, pipeline stage, assigned rep, estimated value, and creation date into columns A through E of this sheet
What You Get
- One row per open lead, with description, stage, rep, value, and date in the columns you specified.
- 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.
- Row count written at the bottom so you can confirm nothing got cut off.
What If the Data Is Not Quite Ready
You need a summary by stage for the executive view
Fetch all open leads from Nutshell, write them into rows 2 onward with description in column A, stage in column B, rep in column C, and value in column D — then add a summary block below the last row showing total count and total value grouped by stage
You only want leads above a certain value threshold
Pull all open Nutshell leads with an estimated value above 10000, write them into this sheet with description, stage, rep, and value — sort by estimated value descending
You need to split the view by rep
Fetch all open Nutshell leads and write them into this sheet — after the last data row, add one summary line per assigned rep showing their lead count and total pipeline value
Full QBR sheet in one shot
Pull all open Nutshell leads, write description, stage, rep, estimated value, and creation date into columns A through E, sort by estimated value descending, add a summary block below the data showing total pipeline value and lead count by stage, and label everything clearly for a QBR audience
When the deck needs to be ready in an hour, ask for 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 sheet 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 or build a forward-looking revenue forecast the same way.