The Scenario
Your sales director has a standing commitment to share a three-month revenue forecast with the executive team at the start of every quarter. The forecast lives in Nutshell. The executive presentation lives in PowerPoint. The bridge is an Excel workbook that needs to show expected revenue by month and by rep — and it needs to exist before the 9 AM sync tomorrow.
The bad version:
- You pull up Nutshell's forecast report, set the date range, and export a CSV.
- The CSV has leads sorted by creation date, not expected close date. You write a SORT function to reorder them, then SUMIF to group by month, then another SUMIF to group by rep.
- You spend 45 minutes building formulas that reference columns by letter, knowing they'll break the moment anyone changes the export format.
The forecast data exists. Reshaping it into a presentation-ready table is where the time goes.
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 the forecast report and write the output already grouped and summarized — no formulas required.
Open SheetXAI in the sidebar and ask:
Pull the Nutshell forecast data into my Excel revenue model sheet, bucket leads by expected close month, and add a summary row per month with total forecasted value and lead count
What You Get
- One row per lead in the forecast period, with rep name, expected close month, and expected value.
- A summary block per month below the data showing total forecasted value and lead count.
- Values written as static output — no formula dependencies, no breakage risk.
- Clean headers that the exec team can read without translation.
What If the Data Is Not Quite Ready
You need a rep-level breakdown within each month
Fetch the Nutshell forecast for the next three months — for each rep, write their expected close month, lead count, and total expected value into this workbook, sorted by month then by rep name alphabetically
Some leads have no expected close date
Fetch all open Nutshell leads — write the ones with an expected close date in the next three months into the main table and add any leads with no expected close date to a separate worksheet labeled Undated
You need the full view split across two worksheets
Write the row-level forecast detail into the Detail worksheet and a summary by month and by rep into the Summary worksheet — both pulled from Nutshell's forecast for the next three months
Full exec forecast workbook in one shot
Fetch the Nutshell forecast for the next three months, write row-level detail into the Detail worksheet with rep, expected close month, and value, write a monthly summary table into the Summary worksheet with total forecasted value and lead count per month, and add a rep-level total for the three-month period at the bottom of the Summary worksheet
When the 9 AM sync is tomorrow and the workbook doesn't exist yet, describe the full output in one prompt.
Try It
Get the 7-day free trial of SheetXAI and open a blank workbook before your next forecasting session — then ask it to pull the Nutshell forecast and format it for leadership. You can also export the full open pipeline for a QBR, pull a won/lost conversion report by rep, or identify dormant accounts for re-engagement.