📊 Google Spreadsheet Improvement – Case Study

Product Goal:

Empower small business owners and individual users to organize and act on spreadsheet data more easily and intelligently.

Business Goal:

Increase engagement and daily active usage (DAU) of Google Sheets in the long-tail segment of users using Sheets for lightweight business and personal productivity tasks.

🎯 Target Users & Segmentation

Segment Description Use Case Examples Prioritization (USA Score: 1-5)
Small Businesses Track operations, expenses, inventory, customer info OSAT nonprofit founder tracking tutors/tutees 🟢 5 – High need, high frequency
Students Assignments, club rosters, deadlines Academic planning, student orgs 🟡 3 – Medium need
Personal Use Household budgeting, event planning Budget sheets, birthday plans 🟡 2 – Low need

Focus Persona:

Small nonprofit founder (e.g., OSAT) managing a tutoring organizationusing Google Sheets + Google Forms + Gmail.

🔍 User Journey (OSAT Founder)

  1. Review Google Form submissions for tutor/tutee signups
  2. Manually clean data: remove duplicates, correct errors
  3. Send confirmation emails with matched pairs
  4. Record pairings in master spreadsheet
  5. Revisit and update after a week (check for inactivity)

😖 Key Pain Points