The Scenario
It is the first week of July. Your sales ops analyst has been asked to put together a Q1 vs Q2 conversion rate comparison by rep — won leads, lost leads, total value won, conversion rate, and the delta between the two quarters. The ask came in yesterday. The data is in Nutshell. The comparison workbook does not exist yet.
The bad version:
- You export Q1 lead data from Nutshell as a CSV, open it in Excel, and start building a pivot table.
- The CSV has all outcomes mixed together — you need to filter to won and lost, group by rep, then calculate conversion rate manually with a formula.
- You export Q2, repeat the same steps on a second worksheet, and then write VLOOKUP formulas to pull the two periods together for comparison.
By the time the workbook is done, you've touched four files and written formulas that will break the moment anyone renames a column.
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, can pull filtered, period-scoped lead reports and write the calculated results directly — without you building a single formula.
Open SheetXAI in the sidebar and ask:
Fetch the Nutshell leads report for Q1 (January through March) filtered to won and lost outcomes — for each rep write their name, leads won, leads lost, total value won, and conversion rate into this workbook
What You Get
- One row per rep showing their Q1 won count, lost count, total value won, and conversion rate.
- Conversion rate calculated as won / (won + lost) and written directly into the workbook.
- Clean column headers ready for comparison without additional formatting.
- Values written as static output, not formula references — no breakage risk.
What If the Data Is Not Quite Ready
You need Q2 added alongside Q1 for direct comparison
Do the same for Q2 (April through June) in columns F through J, then in column K calculate the change in conversion rate between Q1 and Q2 for each rep
One rep changed names mid-year
Pull the Q1 and Q2 won/lost report by rep — if two rep names look like the same person with a typo or name change, merge them into one row before writing the comparison
You want to flag reps whose conversion rate dropped significantly
After writing the Q1 and Q2 comparison, add a column that flags any rep whose conversion rate dropped by more than 10 percentage points between the two quarters
Full period-over-period report in one shot
Fetch won and lost Nutshell leads for Q1 and Q2, group by rep, calculate conversion rate for each period, write both periods into this workbook side by side with a delta column, and flag any rep with a conversion rate decline above 10 points
When the comparison needs to be ready for a performance review, describe the full output — the calculation and the conditional logic — in one prompt.
Try It
Get the 7-day free trial of SheetXAI and open any blank workbook before your next rep review — then ask it to pull the Nutshell won/lost report and calculate the comparisons. You can also build a forward-looking revenue forecast or pull the full open pipeline for a QBR using the same approach.