Build Google Sheets + Google Forms Warehouse Productivity Tracking System Job Description We operate a growing apparel warehouse that fulfills online orders and processes inventory transfers between retail stores. We are looking for someone experienced with Google Sheets, Google Forms, and simple workflow automation to help us build a simple but powerful warehouse productivity tracking system. The goal is to create a system that allows warehouse employees to quickly log their work throughout the day, while management can see clear productivity dashboards. What we need built 1. Google Form for warehouse staff Employees should be able to quickly submit tasks they completed such as: - Boxes unpacked / put away - Items picked for orders - Orders packed The form should include: - Employee name - Task type (dropdown) - Quantity completed - Transfer or order reference (optional) - Timestamp (automatic) 2. Connected Google Sheet (auto-recording data) The form responses should feed into a structured Google Sheet that organizes the data cleanly. 3. Productivity dashboard The spreadsheet should automatically calculate: - Total boxes processed per employee - Total units picked - Total orders packed - Productivity per employee per day - Productivity per hour (if possible) 4. Daily and weekly performance summary We want simple tables showing: - Employee leaderboard - Total warehouse output - Task breakdown 5. Ease of use for warehouse staff The system must be extremely simple for staff to use: - One quick form submission per task batch - Mobile friendly - Ideally accessible via QR code or shortcut 6. Simple manager dashboard Warehouse manager should be able to see at a glance: - Who worked the most - Who picked the most units - Who unpacked the most boxes - Overall warehouse productivity Nice to have (optional): - Basic automation - Conditional formatting - Clean dashboard visuals - Suggestions to improve efficiency Ideal candidate We are looking for someone who: - Has strong Google Sheets and Google Forms experience - Has built dashboards or operational tracking systems before - Understands warehouse operations or productivity tracking - Can design a simple system that non-technical staff can easily use Please include examples of Google Sheets dashboards or tracking systems you have built. This project may expand into additional workflow and operational systems in the future.