Hanna Hosk
← All projects

Company KPI portalEight numbers, always up to date

A scorecard that shows a company's eight key numbers as on track or not, pulled from the CRM, time reporting and invoicing.

For
Consulting firm, internal tool
Year
2026
Status
Live
SourcesSyncStorageShown inHubSpot CRMHarvesttime reportsInvoice sheetDaily syncand webhookPostgresdaily partsDashboard ina HubSpot cardMCP serverAI readings(text only)
Data is synced every day, stored as daily parts, and worked out by tested code. Swipe sideways to see all of it.

Problem

The numbers lived in several tools and were put together by hand, so nobody had a current picture.

What I built

Connectors that sync data every day, tested code that does the maths, and a dashboard that runs inside a HubSpot card. Colleagues can also reach it from their own AI tools through an MCP server.

Result

Live since August 2026. Seven of the eight numbers use real data, and the sheet data updates the moment it changes.

Stack

  • Next.js 16
  • TypeScript
  • Postgres
  • Better Auth
  • MCP
  • HubSpot API
  • Harvest API
  • Google Sheets
  • Vercel

More projects

Moiwak, a startupMoiwak portalRead more ↘Open source, my own toolPipeline guardrailsRead more ↘Furniture supplierPrice-list portalRead more ↘