Operations dashboard · 2025

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
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.

Yumedics Command Center on a phone: the same stock summary and product list with a bottom tab bar.

The problem

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

What I built

A web app on Vercel that stores data in Google Sheets through a Google Apps Script endpoint, with SheetJS for Excel files. Role-based access control limits what each person sees, 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.