Automated Raw Materials Inventory and Issue Management

This n8n workflow automates raw materials inventory management, streamlining the receipt of materials, stock updates, approvals for material issuance, and low stock alerts. It integrates multiple services including Google Sheets, Supabase, webhooks, and Gmail to facilitate real-time inventory tracking and communication. The process begins with receiving raw material data via a webhook, standardizes and logs this data into Google Sheets, and updates stock levels in real-time. When stock levels fall below predefined thresholds, automatic low stock alerts are triggered via email. Additionally, the workflow manages material issuance upon approval, deducts stock accordingly, and maintains accurate records across Google Sheets and Supabase, ensuring efficient and error-free inventory management.