I need a Google Sheets-based system that lets my manufacturing team see, in real time, where every order sits on the floor and how much raw material we still have on hand. The sheet should automatically pull or accept new production data, log it without anyone typing rows manually, and then turn that live information into clear dashboards and scheduled reports. Key areas I must monitor are inventory levels and production schedules; everything else can stay out of scope for now. Automation should cover three pain-points: • Data entry – new jobs, completions, and stock movements flow in through scripts or App Sheet-style forms. • Report generation – shift summaries and weekly capacity charts appear and refresh on their own. • Notifications & alerts – low-stock warnings or overdue work orders land in email or Slack the moment they trigger. I already live inside Google Workspace, so please build with Apps Script, built-in connectors, or other code-light solutions that keep maintenance simple for me after the engagement ends. Acceptance criteria • A single spreadsheet (or connected set) that separates raw data, automated calculations, and user-facing dashboards. • Buttons or triggers that import new production lines, close jobs, and adjust inventory without manual typing. • Automatically generated PDF or Google Slides reports shared on a configurable schedule. • Real-time email/Slack notifications when inventory drops below preset reorder points or a task misses its planned completion date. • Clear, commented Apps Script code so my in-house staff can maintain small tweaks later. If you’ve already built similar manufacturing trackers or know clever ways to streamline shop-floor data capture, that’s a bonus—let me know.