Automate Raw Materials Inventory with n8n + Supabase + Sheets
Track raw material receipts, issue approvals, and stock updates using Google Sheets, Supabase, and n8n webhooks.
Key Features
Everything you need to run a professional HVAC service business online
Automated Stock Updates
Real-time stock tracking through webhook-triggered updates to Google Sheets and Supabase.
Error-Free Material Receipt
Validates quantities, calculates total cost, and avoids duplicates across stock records.
Material Issue Workflow
Approval system for issuing materials ensures the right checks and balances with stock deductions.
Low Stock Email Alerts
Notifies inventory manager instantly when stock drops below set thresholds.
Dual Database Sync
Ensures both Google Sheets and Supabase reflect the same updated stock information.
Branch Logic for Stock Conditions
Handles both new and existing materials with clean conditional flow.
How It Works
Two connected workflows streamline raw material intake and material issuance with live updates.
Receiving Materials
Webhook-based flow captures form submissions, calculates costs, updates stock, and alerts on low inventory.
Material Issue + Approval
Another flow validates issue requests, sends for approval, and deducts stock upon approval.
Sheets + Supabase Integration
Ensures real-time updates and redundancy by syncing data between Sheets and Supabase.
Connect Google Sheets + Supabase
Add credentials for both Google Sheets and Supabase via n8n credential manager.
Setup Receiving Webhook
Trigger the flow via webhook on form submission (e.g., Google Forms, custom UI).
Validate & Record Receipt
Ensure inputs are clean, calculate cost, and update Sheets + Supabase tables.
Configure Approval Workflow
When issuing materials, send email with Approve/Reject buttons that trigger n8n.
Deduct & Sync Stock
Only after approval, deduct stock and update both backends in real time.
Set Low Stock Alert Thresholds
Customize minimum stock levels and email addresses to receive alerts.
Choose Your Workflow Package
Standard – Inventory Automation Flow
Full raw material inventory automation including dual integration and approval system.
- .json workflow file
- Dual flow: Receive + Issue
- Google Sheets + Supabase sync
- Approval email logic
- Error checks + alerts
- Setup documentation
Premium – With Visual Guide
Includes full flow with visual diagrams, screenshots, and low stock alert tutorial.
- Everything in Standard
- 1-hour Zoom walkthrough
- Visual flowcharts
- Slack/Telegram alert add-ons
- Support email access
- Editable prompt templates
Custom
Includes workflow + setup + deployment to your cloud or client infra.
- Premium features
- 1-on-1 guided setup call
- Custom fields or thresholds
- Multiple product templates
- Kubernetes deployment guide
- Follow-up support access
What Our Customers Say
Real experiences from professionals using our platform
"Best inventory workflow I’ve used. Saved me hours every week!"
Karthik S.
Factory Supervisor
"Our stock records are now always in sync across Supabase and Sheets."
Nirali P.
Inventory Analyst
"The approval workflow with email links was game-changing for our issue process."
Bharat M.
Operations Head
Frequently Asked Questions
Find answers to common questions about the Complete HVAC Booking Website