Raw Materials Inventory Management with Google Sheets, Supabase & Approvals

This n8n workflow streamlines raw materials inventory management for small to medium businesses by automating stock updates, material issue approvals, and low stock notifications. It receives data via webhooks from forms (e.g., Google Forms) for receipts and issue requests, then synchronizes stock levels across Google Sheets and Supabase for redundancy and real-time accuracy. The approval process sends email notifications via Gmail, ensuring controlled material issuance without manual intervention.

Key benefits include eliminating manual tracking errors, reducing approval delays, and preventing stockouts through automated low stock detection. Error handling ensures data validation and workflow reliability. Dual storage provides backup and easy reporting, while integrations with popular no-code tools make it accessible.

Ideal use cases: Manufacturing firms tracking raw inputs, warehouses managing supplies, or any operation needing robust inventory oversight. Setup requires n8n credentials for Google Sheets, Supabase, and Gmail APIs, plus a submission form. This saves hours weekly on admin tasks, boosting operational efficiency.