Skip to content
FlowHubFluxonLab
C
Gmailfree

Raw Materials Inventory Management with Google Sheets, Supabase and Approvals

by Immanueladapted from n8n official workflow galleryUpdated Aug 2026
RequiresCCodeGmailGmailGoogle SheetsGoogle SheetsSupabaseSupabase
Share Post Share
Append Material RequestAppend Material…WeGet ApprovalsSeStandardize DataCoUpdate StockWeReceive Issue RequestReceive Issue R…Send Approval RequestSend Approval R…CoPrepare ApprovalCreate Record IssueCreate Record I…Search Product IDSearch Product …Searck IssuesUpdate Current StckUpdate Current …MeMerge LookupsUpdate Current Stock1Update Current …LookUp Current stock1LookUp Current …CoLow stock Detection1Low stock Detec…MeMerge1Append Raw MaterialsAppend Raw Mate…CoCalculate Total PriceCalculate Total…CoCalculate Updated Current StockCalculate Updat…CoValidate Quantity ReceivedValidate Quanti…Initialize New Product stockInitialize New …Update Current StockUpdate Current …LookUp Current stockLookUp Current …New Row Current StockNew Row Current…Current Stock UpdateCurrent Stock U…Search Current StockSearch Current …ILFormat responseMeMergeCoLow stock Detection2Low stock Detec…WeReceive Raw Materials WebhookReceive Raw Mat…SeStandardize Raw Material DataStandardize Raw…Lookup Existing StockLookup Existing…IfCheck If Product ID ExistsCheck If Produc…New Record RowIfTrigger Low Stock AlertTrigger Low Sto…Send Low Stock Email AlertSend Low Stock …Low Stock Email AlertLow Stock Email…CoValidate Issue Request DataValidate Issue …CoVerify Requested QuantityVerify Requeste…Check Available Stock for IssueCheck Available…SeFormat Approval ResponseFormat Approval…CoVerify Approval DataVerify Approval…Retrieve Issue Request DetailsRetrieve Issue …IfProcess Approval DecisionProcess Approva…Get Stock for Issue Update from CurrentGet Stock for I…Update Stock After IssueUpdate Stock Af…Materials Issue Table UpdateMaterials Issue…IfIs Stock is Low1234567891011
1/5
FLOWS
STEPS · 11
Starts on an incoming request

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, delayed material issue approvals, and missed low stock alerts. It ensures real-time stock tracking, streamlined approvals, and timely notifications. Target audience: Small to medium-sized businesses, inventory managers, and n8n users familiar with Google Sheets, Supabase, and Gmail integrations. What Does It Do? 🌟 Receives raw material data and issue requests via form submissions. Updates stock levels in Google Sheets and Supabase. Manages approvals for material issue requests with email notifications. Detects low stock levels and sends alerts via Gmail. Maintains data consistency across Google Sheets and Supabase. Key Features Real-time stock updates from form submissions. Automated approval process for material issuance. Low stock detection with Gmail notifications. Dual storage in Google Sheets and Supabase for redundancy. Error handling for robust data validation.

Tags

n8nreference-onlygmailgoogle-sheetssupabase
Connects
CCodegmailGmailsheetsGoogle SheetssupabaseSupabase
CategoryGmail
Triggermanual
Complexityadvanced
Nodes48
AddedMay 11, 2025

Related workflows

See all Gmail
CgmailsheetsW
free

Sync HubSpot Contacts with LinkedIn URLs, Detect Changes & Send Gmail Alerts

Automate CSV imports into HubSpot without the mess. Powered by n8n. Supercharged by Pollup AI. Who’s this for? This workflow is perfect for Ops-minded folks in Customer Success, Marketing, and Sales – especially if you’re juggling CSV lists, CRM updates, and team-wide reporting. Whether you're a CS ops lead syncing product usage, or a RevOps manager updating contact records, this will save you hours. 🧠 Why it matters Manually importing CSVs into HubSpot is a headache: ❌ Copy-paste errors ❌ Mismatched fields ❌ Wasted time formatting every upload This workflow does the heavy lifting for you: ✅ Pulls fields dynamically from your HubSpot instance ✅ Preps and maps CSV data in minutes ✅ Syncs with Google Sheets to keep your source of truth aligned 🔄 What the workflow actually does Pulls live field names from HubSpot’s API (no guesswork) Indexes and organizes your CSV for import Processes & transforms raw data (optional filters, cleanup, etc.) Dynamically maps CSV fields to HubSpot fields Executes the upload and logs results ⚙️ How to get started Prerequisites: HubSpot private app token Google Sheets API credentials Access to an n8n instance (cloud or self-hosted) Setup in 3 steps: Impo

by PollupAI
gmailgooglecalendarsheetsmattermost
free

Manage attendee registrations and send emails

n8nConf Companion workflow for blog post

by amudhan
gmailsheetsW
free

Move data between JSON and spreadsheets

This workflow illustrates how to convert data from JSON to binary format and import JSON data or files into Google Sheets or local spreadsheets.

by Lorena