The Scenario
You are a sales analyst. The finance team needs a weighted pipeline forecast for the board pack, due tomorrow at noon. They want all open Capsule CRM opportunities in the Proposal milestone above £10,000, with party name, opportunity name, value, probability, and expected close date.
You have a blank Excel workbook waiting.
The bad version:
- You open Capsule and navigate to Opportunities
- You export a CSV, open it in Excel, and discover it has forty columns you do not need
- You filter by milestone, delete the irrelevant columns, and reformat the dates to match Excel's date format
- Finance emails asking for probability — it is not in the CSV by default
- You add it manually from the UI for each opportunity
- You spend two hours on data prep for a table that should have taken ten minutes.
The fast version is one prompt.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your Excel workbook that queries Capsule CRM with your exact filter and writes only the fields you need.
Open the SheetXAI sidebar and type:
Search Capsule CRM for all open opportunities in the Proposal milestone with a value above £10,000. Write them into the Pipeline tab of this workbook with columns: Party Name, Opportunity Name, Value, Probability, Expected Close Date. Sort by value descending.
SheetXAI queries Capsule with the filter applied server-side, returns only the matching records, and writes the five columns you asked for into the Pipeline tab.
What You Get
A filtered workbook tab of opportunities ready for the forecast model:
- Party name, opportunity name, value, probability, expected close date — exactly the five columns
- Filtered to Proposal + above £10,000 — no manual filtering after the fact
- Sorted by value descending — biggest deals at the top
The tab plugs straight into the finance team's weighted forecast formula.
What If the Data Is Not Quite Ready
Filtered Capsule exports often need one more pass before they are board-pack ready.
When some opportunities are missing probability
Early-stage deals that got into the Proposal milestone before probability was set.
Search Capsule CRM for all open opportunities in the Proposal milestone above £10,000. For any record where probability is blank or zero, set it to 50% in the output. Write all fields plus Weighted Value (value × probability) to the Pipeline tab. Sort by Weighted Value descending.
When the board pack needs VIP-tagged contacts exported instead of pipeline opportunities
The exec team wants a separate tab of all Capsule parties tagged "VIP" for a targeted campaign.
Export all Capsule CRM parties tagged "VIP" to the VIP Contacts tab of this workbook. Include email, phone, last contacted date, and open opportunity count per party. Sort alphabetically by party name.
When you need the export split by owner for individual rep reviews
The sales director wants each rep's opportunities on a separate tab.
Pull all open Capsule CRM opportunities in the Proposal milestone above £10,000. For each unique owner, create a separate tab named after that owner and write their opportunities into it with the standard five columns. Add a Summary tab listing each owner, their total pipeline value, and their deal count.
When the forecast needs both pipeline data and a one-paragraph commentary for the board
Finance wants the data plus a short written summary of pipeline health.
Pull all open Capsule CRM opportunities in the Proposal milestone above £10,000. Write them into the Pipeline tab with party name, opportunity name, value, probability, and expected close date. Calculate total pipeline value and weighted forecast value. Then write a one-paragraph board-ready pipeline commentary in cell A1 of the Summary tab covering total value, weighted value, the strongest and most at-risk deals, and any patterns worth flagging.
The pattern: the data pull and the analysis that used to be two separate steps happen in one prompt.
Try It
Get the 7-day free trial of SheetXAI and open any workbook, then ask it to pull a filtered Capsule CRM export into it. The Capsule CRM integration is included in every SheetXAI plan. For related workflows, see how to update opportunity milestones after a pipeline review or the Capsule CRM in Excel overview.