🚧 A quarry business was processing 200+ weight slips every day across multiple sites.
The entire operation depended on handwritten slips, spreadsheets, and manual calculations.
This created several challenges:
• Contractor payment disputes
• Manual data entry errors
• No real-time production visibility
• Difficult credit tracking
• Time-consuming month-end reconciliation
To solve this, I built a custom ERP system that digitized the complete workflow.
Key capabilities included:
✅ Mobile weight slip capture
✅ OCR-based data extraction
✅ Automated contractor billing
✅ Machinery cost tracking
✅ Credit & ledger management
✅ Multi-site production reporting
✅ Role-based access control
✅ Real-time business dashboards
One of the most interesting challenges was building an OCR workflow that could extract data from photographed weight slips captured directly from mobile devices in field conditions.
The result was a centralized system that replaced multiple manual processes with a single source of truth for operations, accounting, and reporting.
Tech Stack:
Laravel • Filament • MySQL • Google Cloud Vision • PWA
I enjoy building software for industries that still rely heavily on spreadsheets and manual processes. Often, the biggest impact comes from solving operational problems rather than adding more features.
🚀 Turning Manual E-commerce Order Processing into an Automated Workflow with n8n
Manual order management may seem simple, but copying customer details, checking information, preventing duplicate orders, and sending confirmation emails can quickly become repetitive and error-prone.
I recently built an end-to-end order processing automation using n8n to solve these challenges for a handmade products store.
Here's what I implemented:
🔹 Automated Order Capture: Receive new orders through a webhook.
🔹 Data Validation & Cleaning: Validate required fields, email formats, quantities, and prices before processing.
🔹 Duplicate Prevention: Detect existing Order IDs to prevent duplicate records.
🔹 Google Sheets Integration: Automatically store valid orders and calculate order totals.
🔹 Email Notifications: Send order updates to the store owner and confirmation emails to customers.
🔹 Error Monitoring: Capture failed executions, log error details in a dedicated Google Sheets tab, and send email alerts.
The goal was simple: reduce repetitive administrative work, improve data accuracy, and make order operations more reliable.
This is what I enjoy about building with n8n — turning complex, repetitive business processes into practical automation systems.
Have a repetitive workflow in your business that could be automated? Let's connect!
This video demonstrates an interactive inventory analytics application designed to help operations teams monitor stock availability, identify supply shortages, and make informed replenishment decisions.
Using 16 populated synthetic inventory records, the walkthrough demonstrates how changes in stock quantities and supplier lead times automatically update inventory risk calculations.
What the Video Demonstrates
Inventory Dashboard: Displays stock availability, six stockout-risk items, and seven replenishment candidates.
Stockout Risk Detection: Identifies products that may run out before replacement inventory arrives.
Supplier Delay Simulation: Demonstrates how changing lead times affects replenishment calculations and risk exposure.
Replenishment Analytics: Calculates reorder points using demand, lead time, and safety stock.
Reporting: Provides calculated inventory results and export capabilities.
Technical Implementation
Developed the interactive dashboard, inventory calculation logic, scenario controls, risk filtering, and data import/export functionality using JavaScript, HTML5, and CSS3.
The demonstration showcases a functional inventory management analytics application with reproducible calculations and clearly identified synthetic data.
E-commerce Order Management Automation | n8n + Google Sheets
Project Overview
I developed an automated E-commerce Order Management System using n8n and Google Sheets to simplify order processing, inventory management, and customer notifications.
The goal was to reduce repetitive manual tasks, minimize order processing errors, and create a more organized workflow for e-commerce businesses.
Key Features
Automated Order Collection: Captures customer orders through an online form.
Inventory Verification: Checks product availability using Google Sheets.
Stock Validation: Uses conditional logic (IF Node) to determine whether an order can be fulfilled.
Automatic Price Calculation: Calculates the total order amount.
Order Management: Stores confirmed orders in Google Sheets.
Inventory Updates: Automatically adjusts stock quantities after successful orders.
Customer Notifications: Sends order confirmations or insufficient-stock messages.
Tools & Technologies
n8n | Google Sheets | IF Node | Workflow Automation | Data Processing
Business Benefits
Reduces manual order processing.
Improves inventory accuracy.
Helps prevent orders for unavailable products.
Streamlines communication with customers.
Keeps order and inventory records organized.
Project Objective
Build a practical automation solution that helps e-commerce businesses manage orders and inventory more efficiently.
Interested in automating your e-commerce operations? Let's connect.