HubSpot Reporting & Dashboard Playbook

The problem

HubSpot lacks a public API for programmatically creating or reading native reports and dashboards. Developers and ops teams are forced to manually click through the UI to translate business KPIs into visual objects, creating a bottleneck for client reporting.

What it does

• Interprets raw business KPIs into specific HubSpot report configurations and object associations.
• Navigates the HubSpot Report Builder via browser automation to select data sources and properties.
• Configures complex filters, including handling silent comma-delimiters that break standard UI inputs.
• Assembles custom reports into executive dashboards with specific layout logic and sharing permissions.
• Performs visual verification by reading rendered dashboard tiles to ensure data integrity.

Frameworks & tools

Requires an agent with live browser automation capabilities (Playwright, Selenium, or Puppeteer). Optimized for mid-tier models like Claude Sonnet 5 for UI-heavy tasks.

Why this beats prompting it yourself

Standard LLM prompts struggle with the specific flakiness of the HubSpot UI and the lack of an API. This skill includes logic for UI retries, specific naming conventions, and validation steps that prevent "no data" errors common in automated reporting.

Use cases

• Building weekly pipeline health dashboards for sales leadership.
• Creating cross-object reports that link Deal data with custom object properties.
• Translating board-level KPI requests into specific HubSpot visualization types.
• Standardizing reporting layouts across multiple client portals.

Known limitations

Requires a browser-capable agent as HubSpot provides no API for reports. The dashboard attachment panel can be flaky, occasionally requiring a manual final click to save.