The Scenario
You are a sales director. The weekly pipeline call is at 2 PM on Friday. It is Friday at 11 AM.
Your sales data lives in Capsule CRM. Every opportunity has a name, a value, a milestone, a probability, an owner, and an expected close date. You need all of it in an Excel workbook — filtered, sorted, and formatted — before the call so you can run the weighted forecast calculation your finance team built in Excel.
The bad version of Friday morning:
- You open Capsule and export a CSV
- You open it in Excel and discover it has forty columns you do not need and is missing the "owner" field
- You filter by status, delete the irrelevant columns, and reformat the dates to match Excel's date format
- Finance emails asking for probability included — you add it manually from the UI for each record
- Your phone starts ringing at 1:50 PM and the workbook is not ready
- You walk into the call with last week's numbers.
The fast version is one prompt.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your Excel workbook that pulls exactly the Capsule CRM data you need, in the shape you need it, without a CSV export.
Open the SheetXAI sidebar and type:
Pull all open opportunities from Capsule CRM and write them into the Pipeline tab of this workbook with columns for: opportunity name, party name, value, milestone, owner, probability, and expected close date. Sort by value descending. Exclude any opportunities with a status of Lost or Won.
SheetXAI calls the Capsule API, applies the filter, and writes the results directly into the Pipeline tab. No CSV, no column cleanup, no manual filtering.
What You Get
A clean workbook tab of every open opportunity with:
- Opportunity name, party name, value, milestone, owner, probability, expected close date — the fields your forecast formula needs
- Filtered to open only — no Won or Lost deals cluttering the view
- Sorted by value descending — biggest deals at the top
The tab plugs straight into the finance team's weighted forecast formula. No reformatting, no column matching, no date conversion.
Run the same prompt again next Friday. SheetXAI reads the new data from Capsule and overwrites the tab.
What If the Data Is Not Quite Ready
Pipeline data from Capsule is not always forecast-ready. SheetXAI can clean and compute in the same prompt.
When probability is missing for some milestones
Early-stage deals that entered the pipeline before probability was tracked.
Pull all open Capsule CRM opportunities. Where probability is blank, set it to 20% for Prospecting, 40% for Qualified, 60% for Proposal, 80% for Negotiation. Write all fields into the Pipeline tab including the imputed probability. Sort by weighted value (value × probability) descending.
When you need weighted value calculated in the workbook
You want a Weighted Value column added by SheetXAI, not manually after the fact.
Pull all open opportunities from Capsule CRM. Write them into the Pipeline tab with the standard columns, plus add a Weighted Value column that multiplies value by probability. Sort by Weighted Value descending. Put a SUM of Weighted Value at the bottom of that column.
When the call focuses on deals closing this quarter
Finance only cares about opportunities expected to close before 30 June 2026.
Pull all open Capsule CRM opportunities with an expected close date before 30 June 2026. Write them into the Pipeline tab sorted by close date ascending. Include opportunity name, party name, value, milestone, probability, and owner.
When you need a pipeline summary alongside the row data
The call opens with a one-paragraph summary before the row-by-row review.
Pull all open Capsule CRM opportunities. Write each one into the Pipeline tab with name, party, value, milestone, owner, probability, and close date. Then in cell A1 of the Summary tab write a one-paragraph pipeline summary covering total pipeline value, weighted forecast value, number of deals by milestone, and the top 3 deals by value.
The pattern: the prompt does the aggregation that used to happen after the export.
Try It
Get the 7-day free trial of SheetXAI and open any workbook, then ask it to pull your Capsule CRM pipeline into it. The Capsule CRM integration is included in every SheetXAI plan. See also how to update opportunity milestones after a pipeline review or the Capsule CRM in Excel overview.