Operations dashboard

Yumedics Command Center

An operations dashboard for a 15-person field team that brings in invoices from Gmail and WhatsApp, so nobody retypes them.

Client: Yumedics and Yuderma
Role: AI Engineer Intern, Yumedics Labs
Year: 2025
Live: yumedics-dashboard.vercel.app (opens in a new tab)

Yumedics Command Center on desktop: a stock overview synced live from Google Sheets, with summary counts above a list of products and their stock levels. — Desktop, 1440px wide

Yumedics Command Center on a phone: the same stock summary and product list with a bottom tab bar. — Phone, 390px wide

The problem

Invoices reached the field team through Gmail and WhatsApp, and each one had to be entered by hand.

What I built

I built the dashboard as a web app on Vercel that uses Google Sheets as its data store through a Google Apps Script endpoint, with SheetJS for Excel files. Role-based access control limits what each person can see, and activity is tracked in real time.

Stack

JavaScript · HTML · CSS · Google Apps Script · Google Sheets · SheetJS · Vercel

Result

Manual data entry is gone from the invoicing workflow.