My Google Sheet already keeps our warehouse running—stock levels adjust in real-time, purchase and sales orders reconcile automatically, and every supplier detail lives in one place. All of that logic is handled through a dense mesh of array formulas, lookups, and triggers that has become tough to maintain. I want the same behaviour, but driven by clean, well-documented Google Apps Script instead of cell formulas. Here is what the sheet does today: • Stock level monitoring: incoming, outgoing, and on-hand quantities update instantly • Order management: purchase orders, sales orders, and fulfilment statuses update relevant tables • Supplier information tracking: each SKU ties back to its vendor profile In the Apps Script version I also need role-based user access controls so different team members (procurement, warehouse, management) only see or edit what they should. What I expect from you • Translate every critical formula or trigger into modular Apps Script functions • Create efficient onEdit or time-driven triggers so updates remain real-time • Build custom menus/buttons for common tasks (e.g., “Create PO”, “Receive Stock”) • Implement user access rules inside the script, not through sheet protection alone • Provide inline comments and a short README so future tweaks are straightforward Success criteria The scripted file must reproduce all existing inventory workflows with identical results, run without manual intervention, and include clear access segregation for at least three user roles. If you’ve refactored large formula-heavy sheets before or built warehouse tools in Apps Script, that experience will help us move quickly. Let me know how you’d approach migrating the logic and any past examples you can share.