Start free

Capsule connector · Sales pipeline reports

Read & reportRead-only source

See your Capsule pipeline by milestone, owner and close date.

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.

  • Forecast weighted pipeline by close month
  • Find open deals past their expected close date
  • Ask ChatGPT or Claude which contacts are going cold
CapsuleSheetsData StudioChatGPTClaude

Start free Explore the data

Updated November 2026

Capsule reportSample data
Opportunity nameMilestoneDeal value
Kestrel Metrics - annual planProposal$18,400
Brightwell rolloutNegotiation$42,000
Larkspur pilotWon$6,500
Refreshes on your schedule in Google Sheets

Capsule reporting for one account

One Capsule account is the data source. Reports show records as they are now; report dates don’t filter them.

Opportunities

Read each opportunity’s milestone, deal value and currency, probability, expected close date, closed date, owner and contact.

People and organisations

List contacts with type, job title, organisation, email, owner and created date.

Follow-up

See when each contact was last contacted, so cold relationships stand out.

Currencies

Each deal keeps its own currency, so multi-currency pipelines add up correctly.

Report datasets and details

Reports you can build

2 reporting datasets, each with its own fields. Pick one in the app, then choose your columns.

  • Opportunities
  • Parties
What each dataset reports
  • Opportunities

    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).

  • Parties

    Every Capsule CRM contact and organisation with type, job title, organisation, first email address, owner, creation date and last contacted date (UTC).

Metrics and dimensions

20 report fields across 2 datasets.

Search the available fields. Hover or tap a field to see what it means.

Send Capsule data anywhere

Google SheetsGoogle SheetsA sheet that refreshes every morning.
Data StudioData StudioCharts that read the same numbers.
BigQueryBigQueryA warehouse table for the same columns.
ClickHouseClickHousePush rows into ClickHouse over HTTPS with an API key.
AWS S3AWS S3Write report files to your S3 bucket with IAM access keys.
Amazon RedshiftAmazon RedshiftLoad rows into Redshift via the Data API with IAM keys.
FireboltFireboltPush rows into Firebolt over HTTPS with a Service Account.
PostgreSQLPostgreSQLWrite report rows into PostgreSQL with database credentials.
MySQLMySQLWrite report rows into MySQL with database credentials.
SnowflakeSnowflakePush rows into Snowflake over HTTPS with a PAT token.
Databricks SQLDatabricks SQLLoad rows into Databricks SQL with a Personal Access Token.
Cloudflare R2Cloudflare R2Write report files to your R2 bucket with access keys.
Excel / CSVExcel / CSVA Drive file you can open in Excel.
ClaudeClaudeAsk Claude about these numbers in a sentence.
ChatGPTChatGPTAsk ChatGPT about these numbers in a sentence.
APIAPIRead the same rows from your own tool.
Don't see yours? Use CSV or APIDownload the rows, or read them from your own tool.

Connect Capsule to ChatGPT or Claude for pipeline questions

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.

Start with Capsule

What you need

A Capsule personal access token from My Preferences, API Authentication Tokens. It sees what that Capsule user can see.

What to know

Read-only. Records are shown as they are now, not past milestone moves. Up to 20,000 rows per report.

How it works

  1. Create your free account, then choose Capsule in Data sources.

  2. Paste your Capsule token.

  3. Choose opportunities or contacts and a destination: a sheet, Data Studio, ChatGPT or Claude.

Works well with Capsule

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.

Questions

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.

Keep your pipeline honest.

Start free, add Capsule and bring opportunities and contacts into the tools you already use.

Start free See setup requirements