DEV Community

Zoe Lin
Zoe Lin

Posted on

Ops Hub — Notion MCP Dashboard for Assets, Subscriptions & Daily Digest

#devchallenge #notionchallenge #mcp #ai

Notion MCP Challenge Submission 🧠

This is a submission for the Notion MCP Challenge

What I Built

Ops Hub is a Notion-first dashboard for asset and subscription operations (built with Notion MCP + Python).

It helps centralize scattered operational info (devices, warranties, renewals) into one workspace and turns it into a daily workflow:

  • Assets Ops: track equipment (3C / appliances), maintenance schedule, warranty dates, and manuals.
  • Subscription Ops: track renewals, pricing, and generate cancellation drafts.
  • Daily Digest: one command generates a Daily Digest — YYYY-MM-DD page in Notion with:
    • KPI summary (counts + upcoming renewal cost)
    • actionable lists with deep links to the exact items

All outputs stay inside Notion, so it’s easy to review and act (human-in-the-loop friendly).

Video Demo

Show us the code

GitHub Repo

Run locally (Poetry):

cp .env.example .env
poetry install
poetry run python -c "from homeops_mcp.server import create_daily_digest; print(create_daily_digest(14))"
Enter fullscreen mode Exit fullscreen mode

How I Used Notion MCP

Notion is the source of truth (databases, views, templates, and the dashboard). The MCP server turns Notion context into an automated ops workflow:

  • Reads Notion databases to find:

    • assets due for maintenance soon
    • warranties expiring soon
    • subscriptions renewing soon (within N days)

  • Writes back into Notion:

    • status fields like Next Action and Lifecycle Stage
    • helpful notes like Manual Notes (maintenance guidance) and Cancel Instructions (cancellation draft)

  • Generates a Daily Digest page in Notion with KPIs + clickable action lists, so I can review everything in one place.

This makes the workflow feel like “superpowers”: I stay in Notion, run one command, and get an updated dashboard plus a daily report ready to act on.

Data Model (Notion Databases)

Assets

  • Maintenance: Last Maintenance + Maintenance Interval (days) → Next Maintenance (formula) → Next Maintenance Date (calendar)
  • Ops fields: Next Action, Lifecycle Stage
  • Docs: Manual Notes, Manual URL, Warranty End

Subscriptions

  • Renewal tracking: Renewal Date, Billing Cycle, Status
  • Ops fields: Next Action
  • Output: Cancel Instructions (draft)

Daily Digest (Auto Report)

A single run creates a Daily Digest — YYYY-MM-DD page in Notion with:

  • KPI Summary (maintenance / renewals / renewal cost / warranty)
  • Clickable action lists linking to the exact items

Generated by create_daily_digest(14) and saved as a child page under the dashboard.

Tech Stack

  • Python (MCP server)
  • Notion MCP + Notion API
  • Poetry (dependency & virtualenv)

Top comments (0)