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 Google Sheet waiting.
The bad version:
- You open Capsule and navigate to Opportunities
- You filter by milestone, but Capsule's UI does not let you filter by value threshold at the same time
- You export the full CSV, open it in Sheets, filter manually, delete twenty columns you do not need, reformat the dates
- Finance emails asking for probability included — you go back to Capsule and check whether that field is in the CSV
- It is not in the export 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 spreadsheet that queries Capsule CRM with your exact filter and writes only the fields you need, in the shape you need them.
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 this sheet 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. No CSV, no column cleanup.
What You Get
A filtered sheet 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, which is how the board pack is ordered
The sheet plugs straight into the finance team's weighted forecast formula. No reformatting, no column matching, no date conversion.
Need to add a Weighted Value column? Add one instruction to the prompt.
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 this sheet. 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 sheet. 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, not one combined list.
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 in the same document.
Pull all open Capsule CRM opportunities in the Proposal milestone above £10,000. Write them into this sheet 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 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 sheet, 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 Google Sheets overview.