E-Commerce Automation | Order & Inventory Management
E-Commerce Order & Inventory Management System
An automated system that records online customer orders in Google Sheets, delivers instant branded email confirmation receipts, and continuously monitors stock levels with real-time Telegram restock alerts.
01 · Overview
System Overview
Running an online storefront without automated operations leads to delayed order fulfillment, manual spreadsheet entry errors, and lost sales due to sudden stockouts. This system automates the complete operational lifecycle for an e-commerce brand: incoming orders trigger instant structured database entries in Google Sheets and beautiful branded HTML customer receipts via Gmail, while an autonomous background scheduler scans product inventory daily to alert operations via Telegram when stock dips below critical thresholds.
Tools Used
- n8n
- Google Sheets
- Gmail
- Telegram
- JavaScript
- Webhooks
02 · Problem
Why the manual process broke down
Managing e-commerce orders and warehouse stock by hand creates friction, fulfillment bottlenecks, and lost revenue:
- Manual Order Entry: Copying customer details, order numbers, and purchased items by hand into tracking spreadsheets consumes hours and introduces fulfillment errors.
- Delayed Customer Confirmations: Without instant email automation, buyers are left waiting for order confirmation, leading to customer anxiety and support inquiries.
- Untracked Stockouts: When product stock depletes without warning, high-demand items sell out before restock orders can be placed with suppliers.
- Disorganized Line Items: Multi-item orders stored as messy raw text make picking, packing, and sales auditing difficult to scale.
03 · Solution
How the system works
Storefront Webhook + n8n + Google Sheets (Orders & Items) + Gmail
Processes inbound customer purchases in real time upon successful checkout:
- 1Order Webhook Catch: An n8n webhook intercepts the live checkout event from the storefront containing customer details, shipping address, and line items.
- 2Data Normalization: Formats the raw payload, structures timestamps, and validates billing and delivery addresses.
- 3Orders Ledger Logging: Appends the primary order record into the central Orders sheet in Google Sheets.
- 4Line Item Decomposition: Splits multi-item carts into individual product rows in the Order Items sheet for streamlined fulfillment and warehouse picking.
- 5Branded Receipt Delivery: Compiles customer shipping details, items, prices, and tracking links into a responsive branded HTML email and delivers it immediately via Gmail.
Daily Cron Trigger + Google Sheets Inventory + JavaScript Threshold Logic + Telegram Bot
Monitors warehouse stock daily to alert the operations team before popular items run out:
- 1Scheduled Stock Audit: Runs a daily cron trigger that queries the live Inventory database in Google Sheets.
- 2Critical Threshold Filtering: Evaluates quantity-on-hand across all SKU records and filters out formulations with 3 or fewer units remaining.
- 3Low-Stock Condition Check: Determines whether any SKUs breached minimum thresholds.
- 4Telegram Restock Notification: Automatically formats an urgent Telegram alert listing SKU names, remaining quantities, and direct links to the Google Sheets inventory for immediate supplier reordering.
System Design & Operational Advantages
- Dual-Sheet Architecture: Separates high-level customer orders from individual purchased line items, enabling clean inventory deduction and accurate accounting.
- Proactive Restock Shield: Automated daily threshold audits prevent stockouts on best-selling SKUs by providing operations teams with lead time to reorder.
- Instant Branded Touchpoints: Delivers immediate confirmation receipts directly to the buyer's inbox, enhancing brand trust and reducing support queries.
04 · Workflow Architecture
Workflow Images
Click any workflow image to inspect individual nodes, branches, and connections at full size.
05 · Connected Interfaces & Outputs
Other Project Images
Supporting database records, team notifications, and client-facing outputs connected to the workflow.
07 · Outcome
What the system delivers
- Less Manual Work: Orders and itemized purchases are automatically recorded in Google Sheets without manual data entry.
- Faster Customer Communication: Buyers receive personalized, branded HTML order confirmations instantly upon placing an order.
- Better Order Organization: Customer order summaries and individual purchased items are stored in separate sheets for clear fulfillment tracking.
- Improved Inventory Visibility: Low-stock products are automatically identified on a daily schedule.
- Timely Restock Alerts: The operations team receives instant Telegram notifications before products run out, preventing stockouts.
Build Something Similar
Want this level of automation in your workflow?
Book a free 30-minute discovery call and we'll map out what can be automated in your stack.