Opportunities
Read each opportunity’s milestone, deal value and currency, probability, expected close date, closed date, owner and contact.
Capsule connector · Sales pipeline reports
Bring Capsule opportunities and contacts into your reports and AI assistants: milestone, deal value and currency, probability, expected close date and owner, plus when each contact was last contacted.
Updated November 2026
| Opportunity name | Milestone | Deal value |
|---|---|---|
| Kestrel Metrics - annual plan | Proposal | $18,400 |
| Brightwell rollout | Negotiation | $42,000 |
| Larkspur pilot | Won | $6,500 |
One Capsule account is the data source. Reports show records as they are now; report dates don’t filter them.
Read each opportunity’s milestone, deal value and currency, probability, expected close date, closed date, owner and contact.
List contacts with type, job title, organisation, email, owner and created date.
See when each contact was last contacted, so cold relationships stand out.
Each deal keeps its own currency, so multi-currency pipelines add up correctly.
2 reporting datasets, each with its own fields. Pick one in the app, then choose your columns.
Every Capsule CRM opportunity with its milestone, deal value and currency, win probability, expected and actual close dates, linked contact or organisation, owner and creation date (UTC).
Every Capsule CRM contact and organisation with type, job title, organisation, first email address, owner, creation date and last contacted date (UTC).
20 report fields across 2 datasets.
Search the available fields. Hover or tap a field to see what it means.
No fields match. Try another search or choose All.
Use Datapipe’s MCP access as your Capsule reporting tool. Ask about milestones, close dates and follow-up.
Example
Which open opportunities are past their expected close date, and who owns them?
List opportunities not won or lost whose expected close date has passed, with milestone, deal value, currency and owner, sorted by value.
A Capsule personal access token from My Preferences, API Authentication Tokens. It sees what that Capsule user can see.
Read-only. Records are shown as they are now, not past milestone moves. Up to 20,000 rows per report.
Create your free account, then choose Capsule in Data sources.
Paste your Capsule token.
Choose opportunities or contacts and a destination: a sheet, Data Studio, ChatGPT or Claude.
Add both to the same project. Each keeps its own report, so you can check them side by side or ask ChatGPT or Claude a question that needs both.
Opportunities with milestone, value, currency, probability, close dates and owner, and people and organisations with email, job title and last contacted date.
No. It only reads them.
Each deal keeps its own currency, so totals can be kept separate by currency.
No. Reports show the current milestone. Refresh on a schedule to keep your own record in a sheet.
Free to start. Paid plans add more data sources and refresh faster.
Free and Starter refresh once a day. Pro refreshes every hour. Agency refreshes every 15 minutes on the first 50 data sources.
One for each Capsule account you add to a project. Adding the same account to another project counts again. Reports and destinations do not use extra data sources.
Start free, add Capsule and bring opportunities and contacts into the tools you already use.