<aside> 👩🏻‍💻

Category: Order Management / Workflow Automation / Customer Operations

Tools used: Google Sheets, Google Forms, Google Apps Script

Timeline: Ongoing

Environment: Independent comic and retail business managing recurring customer subscription orders

</aside>

The Problem

Customer pull list management was paper based, fragmented, difficult to maintain, and heavily dependent on manual updates and tribal knowledge

The existing workflow lacked:

• any digital footprint
• centralized customer tracking
• standardized intake methods
• scalable pull list organization
• printable fulfillment outputs
• operational visibility into customer requests
• structured handling of adds/removals/variants
• maintainable workflows for ongoing updates

Customer requests were coming from multiple directions and formats, creating high risk for:

• missed titles
• duplicate entries
• fulfillment inconsistencies
• operational confusion
• poor maintainability over time

The business needed a lightweight system capable of functioning as both a customer order database and operational fulfillment tool without requiring dedicated retail management software.