Youtech
Client Portal Redesign
Transforming a Google Sheets mirror into a streamlined asset inventory platform for internal teams and clients.
OVERVIEW
Project context
Youtech managed its asset inventory in Google Sheets. When a new client portal platform was built to replace it, the result was essentially a direct copy of the spreadsheet experience — functional but without any of the clarity or ease of use that a purpose-built tool should offer. I was brought in to identify the gaps and redesign the experience for both internal team members and clients.
PROBLEM STATEMENT
The challenge
The platform mirrored the structure of Google Sheets without adapting to the needs of either audience using it. Data entry was slow and confusing, critical information wasn't surfaced on landing, and there was no meaningful communication or tracking built in. The redesign needed to work for power users managing data and clients who needed clarity at a glance.
RESEARCH
Internal discovery
Key findings
Data entry required too many clicks for simple fields — the process was unnecessarily slow
Moving from Google Sheets to the new portal felt unclear — familiar patterns were gone without better replacements
The most important information wasn't immediately visible on landing
No built-in communication or tracking made it hard to understand what had changed and when
Speed and clarity were the top shared priorities across all user groups
DESIGN PROCESS
Three-phase rollout
Bug fixes & stabilization
Audited the existing platform and documented all bugs and errors in a structured Google Sheet
Coordinated with the development team to resolve all issues before client-facing launch
Began migrating internal logs into the stabilized system for live use
UI refresh & UX overhaul
Intentionally light visual refresh
Restructured the user journey and introduced new features to solve the problems that surfaced in discovery
Prototype & developer collaboration
Built interactive prototypes covering primary actions: adding, editing, and deleting data rows
Mapped micro-interactions for form entry to give development a clear step-by-step reference
Ran collaborative walkthroughs with dev to validate feasibility and surface edge cases before build
OUTCOME
Results
The redesigned portal moved from a spreadsheet facsimile to a purpose-built tool with a guided data entry experience, real-time SEO data, and visibility into activity and ownership that the original platform entirely lacked.
WORK
Project assets
Original designs
Design components
Final project