Projects using Google Sheets in BengaluruProjects using Google Sheets in BengaluruE-Commerce Auto-Fulfilment System — From Order to Label Without Touching a Spreadsheet
Built a fully automated order-to-fulfillment pipeline for a D2C brand selling across Shopify, Amazon, and their own store.
THE PROBLEM:
The operations team manually copied orders into spreadsheets, checked inventory against 3 separate sources, created shipping labels one by one, and updated tracking numbers by hand. 3 hours of daily grunt work. 8% error rate. Delayed shipments. Angry customers asking "where is my order?"
THE SYSTEM I BUILT:
→ CAPTURE: Shopify order webhook fires instantly on every purchase. Amazon SP-API pulls orders every 15 minutes into the same pipeline.
→ VALIDATE: Auto-check inventory in Google Sheets. Flag low-stock SKUs for reorder. Route expedited orders to priority queue.
→ PROCESS: Generate shipping label PDF automatically via Shiprocket API. Create invoice in Zoho Books. Update inventory count across all channels in real-time.
→ SYNC: Push order status, tracking number, revenue data, and shipping cost to master Google Sheets dashboard for ops visibility.
→ NOTIFY: Customer receives automated email/SMS with tracking link within 5 minutes of order confirmation.
→ ALERT: Operations manager gets daily summary + instant alert on failed orders with retry logic and error context.
THE RESULTS:
• Manual processing time: 3 hours/day → fully autonomous
• Order processing errors: 8% → 0.2%
• "Where is my order?" support tickets: -60%
• Scales to 10,000+ orders/month without adding staff
TECH STACK:
Make.com (http://Make.com) | Shopify | Amazon SP-API | Google Sheets | Shiprocket | Zoho Books | Twilio | PDF Generator
WHY THIS WORKS:
E-commerce margins are thin. Every minute of manual processing and every fulfillment error eats profit. This system runs 24/7 without breaks, mistakes, or overtime pay. 
