The Scenario
It's 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 sheet does not exist yet.
The bad version:
- You export Q1 lead data from Nutshell as a CSV, open it in Sheets, and start building a pivot table.
- You realize the CSV includes all outcomes mixed together — you need to filter to won and lost, then group by rep, then calculate conversion rate yourself with a formula.
- You export Q2, repeat the same steps on a second tab, and then write VLOOKUP formulas to pull the two periods together for comparison.
By the time the sheet 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 Google Sheet. It reads the sheet and, through its built-in Nutshell integration, can pull filtered, period-scoped lead reports and write the calculated results directly into your sheet — 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 sheet
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 sheet.
- Clean column headers so the data is ready to compare without additional formatting.
- No formula dependencies — the values are written as static output, not references.
What If the Data Is Not Quite Ready
You need the Q2 data 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 due to a name correction
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 L 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 (January through March) and Q2 (April through June), group by rep, calculate conversion rate for each period, write both periods into this sheet 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 you want — the calculation and the conditional logic — in one prompt.
Try It
Get the 7-day free trial of SheetXAI and open any blank sheet before your next rep review — then ask it to pull the Nutshell won/lost report and calculate the comparisons for you. You can also build a forward-looking revenue forecast or pull the full open pipeline for a QBR using the same approach.