Raw materials inventory management with Google Sheets, Supabase and approvals
Needs changesNeeds changes. This template uses 1 thing(s) that n8n 3.0 removes: Item Lists (legacy). 1 breaking item(s) found. Static check, last run 2026-10-19.
What this workflow does
This workflow has 48 nodes and runs when an HTTP POST request hits its webhook URL (plus 2 other triggers). Along the way it connects Google Sheets, Gmail and Supabase.
How it runs
Trigger: When an HTTP POST request hits its webhook URL (plus 2 other triggers).
- Standardize Raw Material Data (Edit Fields (Set)): sets 12 fields: Timestamp, Product ID, Supplier Name…
- Standardize Data (Edit Fields (Set)): sets 9 fields: Timestamp, Product ID, Quantity Requested…
- Format Approval Response (Edit Fields (Set)): sets 5 fields: Submission ID, Action, Approved Quantity…
- Calculate Total Price (Code): runs custom JavaScript code
- Validate Issue Request Data (Code): runs custom JavaScript code
- Verify Approval Data (Code): runs custom JavaScript code
- Append Raw Materials (Google Sheets): append
- New Record Row (Supabase): uses Supabase
- Verify Requested Quantity (Code): runs custom JavaScript code
- Retrieve Issue Request Details (Google Sheets): uses Google Sheets
…plus 35 more steps. See the full node list below.
Services it uses
Before you upgrade to n8n 3.0
1 thing in this workflow is removed in n8n 3.0. Fix it before you upgrade:
- Item Lists (legacy) in Format response: replace with Split Out, Aggregate, Sort, Limit, Remove Duplicates or Summarize (match the operation used).
| Removed in 3.0 | Replace with |
|---|---|
| Item Lists (legacy) Format response | Split Out, Aggregate, Sort, Limit, Remove Duplicates or Summarize (match the operation used) |
Nodes used (9)
- Google Sheets
n8n-nodes-base.googleSheets - Webhook
n8n-nodes-base.webhook - Edit Fields (Set)
n8n-nodes-base.set - Code
n8n-nodes-base.code - Gmail
n8n-nodes-base.gmail - Supabase
n8n-nodes-base.supabase - Merge
n8n-nodes-base.merge - Item Lists
n8n-nodes-base.itemLists - If
n8n-nodes-base.if
From the author
Automated Raw Materials Inventory Management with Google Sheets, Supabase, and Gmail using n8n Webhooks Description What Problem Does This Solve? 🛠️ This workflow automates raw materials inventory management for businesses, eliminating manual stock updates,…