Shopify Sales Dashboard with Automated Order Tracking

Developed a Shopify Sales Dashboard for an e-commerce client to automate order tracking and sales reporting. The goal was to streamline operations and monitor revenue in real-time. I built a Google Sheets solution with dynamic totals, status tracking, and a sales trend chart, mimicking Shopify API integration. Delivered in 48 hours, the dashboard saved the client 20+ hours/week on manual tasks, enabling better inventory decisions and a 15% increase in operational efficiency. Tech: Google Apps Script, Sheets formulas.