Build a HubSpot sales report with AI
Distinguish open pipeline from closed business and show the counts behind conversion figures, so your team can see exactly what each number covers.
Build a HubSpot sales report with AI by choosing between two very different questions: what closed last quarter, and what is still available to win today? One is a period result; the other is a snapshot. Mixing them can make a weak quarter look healthy.
The sales-reporting workflow reads deal records and groups the results by stage, owner or outcome. A useful report includes the denominator as well as the percentage, particularly when only a handful of deals closed.
What it does
- Count open opportunities at each pipeline stage.
- Compare won and lost deals in a defined period.
- Separate missing deal values from recorded amounts.
- Find open deals with close dates coming up.
- Show how many closed deals contribute to a win rate.
Install and use
- Use the official HubSpot Agent CLI with authorised deal access. The examples use jq and the companion bulk workflow for pagination. Confirm the portal, period and currency before adding amounts.
- Try: “Report last quarter’s closed deals. Show wins and losses separately, and list missing amounts rather than assuming they were zero.”
- Reconcile the count with the team’s saved view. If only the first results page was read, label it a sample until pagination is complete.
FAQ
Source
Made by HubSpot. Original skill: sales-reporting, published on GitHub under the Apache-2.0 licence.
View on GitHub