I’m building a lightweight, browser-based tool that lives on our own hosting and is written purely in HTML, CSS and vanilla JavaScript (no WordPress or other CMS). The tool has three touchpoints: • an Order Submission form • a Refund Request form • a Status Tracking lookup Every interaction needs to read from or write to a single Google Sheet so that the sheet remains the live system of record. When a customer places an order or requests a refund, the form pushes the data to the appropriate tab. When someone enters an order number on the tracking page, the app pulls the latest row from the sheet and displays status details in real time. Access is restricted with Google account login; only users in a specific workspace domain should be able to reach the pages. Feel free to wire this through the standard Google Sign-In JavaScript library or an Apps Script web app if that streamlines permissions. Deliverables – Responsive HTML/CSS/JS for the three pages, ready to drop on a standard web host – Secure Google Sign-In flow that gates every page before content loads – Cleanly commented code showing where the sheet ID, range names and domain whitelist are set – Brief deployment read-me so I can swap in a new sheet or move the files without breaking anything If you already have experience talking to Google Sheets with Fetch, Axios or Apps Script and can keep the interface fast and minimal, I’d like to wrap this up quickly.