Automation Pick-up Service
Overview
The Automation Pick-up Service is a high-performance web application designed to bridge the gap between traditional manual inventory management and modern digital workflows. By leveraging Google Sheets as a lightweight, real-time database, it allows business owners to manage their stock effortlessly while providing customers with a sleek, real-time ordering experience.
The Problem It Solves
Many local businesses and growing service operations struggle with manual spreadsheet coordination, stock discrepancies, and delayed customer pickup notifications. This app replaces manual entry by building an automated public catalog synced in real-time with Google Sheets, notifying customers instantly when their order is ready, and reducing administrative overhead by 90%.
Core Features
- Public Inventory System: A high-performance product catalog pulled directly from Google Sheets, ensuring data consistency without complex database overhead.
- Secure Ordering Workflow: Integrated with Firebase Authentication for secure customer accounts and order tracking.
- Admin Fulfillment Hub: A dedicated dashboard for store owners to manage pending orders, update fulfillment status, and monitor business performance.
- Automated Event Triggers: Real-time email notifications powered by Resend, alerting customers when orders are placed and ready for pickup.
- Glassmorphic UI: Built with Tailwind CSS 4 and Framer Motion for a premium, responsive aesthetic that feels alive.
Technical Architecture
The system operates on four technology pillars:
- Identity: Secure user management via Firebase Auth.
- Database: Google Sheets API for a flexible, collaborative data source.
- Automation: Vercel Serverless Functions orchestrating order flows and email triggers.
- Frontend: React + Vite for a blazing-fast user experience.