Googlesheets Workflow

# Raw Materials Inventory Management with Google Sheets and Supabase using n8n Webhooks ## Introduction This n8n automation streamlines raw materials inventory management by automating the receipt of materials, issuing materials upon approval, updating stock levels, and sending low stock alerts. It integrates webhooks, Google Sheets, Supabase, and Gmail to ensure efficient inventory tracking and communication. ## Problem Statement Manual inventory management is time-consuming and error-prone, often leading to stock discrepancies, delayed approvals for material issuance, and missed low stock alerts. This automation addresses these issues by providing a seamless workflow for receiving raw materials, processing issue requests, and monitoring stock levels in real time. ## Target Audience This template is designed for: - Small to medium-sized businesses managing raw materials inventory. - Inventory managers seeking to automate stock updates and approvals. - n8n users familiar with Google Sheets, Supabase, and Gmail integrations. ## Description ### Flow 1: Raw Materials Receiving and Stock Update Purpose: Automates the receipt of raw materials, calculates costs, updates stock, and sends low stock alerts. - Receive Raw Materials Webhook - Purpose: Receives raw material data via HTTP POST at a webhook URL from a form submission. - Input: JSON with fields like product_id, quantity_received, unit_price, submitted via a form (e.g., Google Form or custom form). - Output: Raw webhook data. - Notes: Expects Content-Type: application/json. - Standardize Raw Material Data - Purpose: Maps webhook data into a consistent format. - Input: Webhook JSON from form submission. - Output: JSON with fields like Timestamp, Product ID, Quantity Received. - Notes: Aligns field names for downstream nodes. - Calculate Total Price - Purpose: Computes total cost and validates numeric inputs. - Input: Standardized JSON. - Output: JSON with Total Price (Quantity Received * Unit Price). - Notes: Uses a custom function to handle invalid numbers. - Append Raw Materials - Purpose: Records the receipt in Google Sheets. - Input: Calculated JSON. - Output: Updated "Raw Materials" sheet with new record. - Notes: Requires Google Sheets credentials (to be configured by the user). - Check Quantity Received Validity - Purpose: Ensures Quantity Received is a positive nu