For teams that run on Capsule CRM
Capsule CRM sales report by email each week
Capsule CRM has dashboards and reports you open in the app, and you can export a chart as CSV or image for a monthly report. Sending a report on a schedule, or with your custom fields and tags in it, is done by hand.
How it goes today
- Open the dashboard and export each chart as CSV or image.
- Paste the numbers into a spreadsheet or slide.
- Add custom fields and tags by hand, because the breakdown export leaves them out.
- Email the result to the team.
How it can go
The numbers you pull each month arrive in your inbox.
Each Monday, and on the first of the month, you get one email per team or for the company: opportunities won and lost with their value and lost reason, the open pipeline per milestone, what is expected to close in the next 30 days, and deals that have not changed milestone for longer than you set. The notes and completed tasks of each salesperson are counted next to it. You choose the custom fields and tags it splits on, and a spreadsheet with the lines is attached.
Say this in ChatGPT, Claude or Copilot
Your chat gets connected to Hypamoon first, with this request filled in. You paste your Capsule CRM key in the portal, never in the chat.
With Hypamoon, each Monday and on the first of the month, email me a sales report from Capsule CRM: opportunities won and lost with value and lost reason, the open pipeline per milestone, what is expected to close in the next 30 days, and deals that have not changed milestone for longer than I set. Count the notes and completed tasks per salesperson, split it on the custom fields and tags I choose, and attach the lines as a spreadsheet.
You create a personal access token yourself in Capsule CRM under My Preferences, API Authentication Tokens. It works with the rights of the user who made it, so an administrator is the easiest choice. It stays yours.