All products

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

  1. 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.
  2. Try: “Report last quarter’s closed deals. Show wins and losses separately, and list missing amounts rather than assuming they were zero.”
  3. 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