How We Saved a Client Rs 2.5 Lakh Per Year with AI Automation [Case Study]

Executive Summary

A Kolkata-based e-commerce brand selling home decor products was drowning in manual operations. Their 5-person team spent 15 hours every week on repetitive data entry — exporting orders, updating spreadsheets, generating invoices, and syncing inventory across channels.

We built a workflow automation system using n8n that reduced those 15 hours to 45 minutes of weekly monitoring. The result: Rs 2.5 lakh in annual savings, 99.8% accuracy improvement, and a payback period of just 3 months.

This is the full story — the problem, our approach, the technical solution, and the measurable results.

---

Client Background

• Industry: E-commerce (home decor and lifestyle products)
• Annual revenue: Approximately Rs 2 crore
• Team size: 5 people
• Sales channels: Shopify store, Amazon India, and a standalone website
• Existing tech stack: Shopify, Google Sheets for inventory, Tally for accounting, Gmail for customer communication
• Core challenge: Scaling order volume without hiring additional staff

The business was growing, but their operations were not keeping up. Every new order meant more manual work, and the team was spending more time on data entry than on actually growing the business.

---

The Problem in Detail

Here is what their daily manual workflow looked like:

The Business Impact Was Real

• Delayed shipments: Orders were shipped 1–2 days late because processing was manual and sequential.
• Inventory discrepancies: Selling on multiple channels with manual inventory sync led to overselling and stockouts at least twice a month.
• Accounting errors: Manual data entry into Tally caused reconciliation issues that took hours to resolve every month.
• Employee burnout: The operations manager was spending 80% of their time on repetitive data entry instead of strategic work.
• Growth ceiling: The team physically could not process more than 40–50 orders per day without errors creeping in.

---

Why They Had Not Automated Earlier

When we first spoke with the founder, they had common misconceptions:

• "Automation is expensive" — They assumed it would cost Rs 10–15 lakhs, like enterprise ERP systems.
• "We are too small for automation" — They thought automation was only for large companies.
• "It will be too complex to maintain" — Worried they would need a full-time developer to keep it running.
• "What if it breaks?" — Feared that automated systems would make critical errors without human oversight.

All of these are valid concerns — and all of them turned out to be wrong for their use case.

---

Our Approach

Step 1: Workflow Audit (Week 1)

We started by documenting every manual process:

• Shadowed the operations manager for 2 full days
• Mapped every data touchpoint (where data is entered, copied, or transformed)
• Identified the highest-impact automation candidates based on time spent and error frequency
• Calculated potential ROI for each workflow

Step 2: Solution Design (Week 2)

We chose n8n as the automation engine for several reasons:

• Self-hosted: No per-execution pricing. Fixed infrastructure cost regardless of volume.
• Visual workflow builder: Non-technical team members can understand and monitor workflows.
• Extensive integrations: Native connectors for Shopify, Google Sheets, Gmail, and REST APIs for everything else.
• Cost-effective: Hosting on a Rs 500/month DigitalOcean droplet handles their entire automation stack.

We designed three core workflows covering the entire order-to-accounting pipeline.

Step 3: Implementation (Weeks 3–5)

Built, tested, and deployed all three workflows. Each workflow was tested with 100+ real orders before going live. We built comprehensive error handling — if any step fails, the team gets an immediate Slack notification with details.

Step 4: Training and Handoff (Week 6)

Trained the operations manager on:

• Monitoring the n8n dashboard
• Understanding error notifications
• Manually triggering workflows for edge cases
• Basic troubleshooting (restarting failed workflows)

---

The Solution: Three Automated Workflows

Workflow 1: Order Processing Pipeline

Trigger: New order placed on Shopify or Amazon

Automated steps:

1. Fetch order details from Shopify/Amazon API
2. Validate order data (check for missing fields, duplicate orders)
3. Update Google Sheets inventory tracker
4. Generate PDF invoice with correct GST calculations
5. Push invoice data to Tally via API
6. Send order confirmation email to customer
7. Create shipment label request

Before: 2.5 hours/day of manual work across multiple systems. After: Fully automatic. Takes 3–5 seconds per order.

Workflow 2: Multi-Channel Inventory Sync

Trigger: Runs every 30 minutes (scheduled)

Automated steps:

1. Pull current inventory from Shopify
2. Pull current inventory from Amazon Seller Central
3. Reconcile quantities across channels
4. Update all channels with correct stock levels
5. Alert on low stock (below threshold)
6. Generate daily inventory report

Before: 60 minutes/day of manual cross-referencing and updating. After: Runs automatically 48 times per day with zero human intervention.

Workflow 3: Customer Communication Sequence

Trigger: Order status changes

Automated steps:

1. Order confirmed → Send confirmation email with estimated delivery
2. Shipped → Send tracking number and courier link
3. Delivered → Send delivery confirmation
4. Day 7 post-delivery → Send feedback/review request

Before: 30 minutes/day of manual email sending. After: Fully automatic. Customers get real-time updates.

---

Results and ROI

Time Savings

Cost Savings (Annual)

Investment

ROI Summary

• Payback period: 3 months
• First-year ROI: 325%
• Ongoing annual savings: Rs 3.6 lakhs (with only Rs 11,000/year in costs)

Additional Benefits Beyond the Numbers

• Same-day shipments (previously 1–2 day delay)
• Zero inventory discrepancies (previously 2–3 stockouts per month)
• Accounting accuracy improved to 99.8% (previously hours of monthly reconciliation)
• Employee satisfaction improved (operations manager now focuses on vendor relationships and growth strategy)
• Capacity to scale to 3x current order volume without adding headcount

---

Lessons Learned

1. Start with the most time-consuming process. The order processing pipeline saved the most hours, so we built it first. Quick wins build confidence.
2. Error handling is not optional. Automations will encounter unexpected data. Build alerts and fallbacks from day one.
3. Test with real data. We ran every workflow against 100+ real orders before going live. Synthetic test data misses edge cases.
4. Train the team on monitoring, not just usage. The operations manager needed to understand what the dashboard was showing, not just how to click buttons.
5. ROI comes quickly for repetitive tasks. If a task is done more than 3 times per week and follows a predictable pattern, it is almost certainly worth automating.

---

Could This Work for Your Business?

Good Candidates for Automation

• Any task performed more than 3 times per week
• Tasks that follow if-this-then-that logic
• Data entry and data movement between systems
• Report generation from multiple data sources
• Customer communication sequences
• Inventory management across channels
• Invoice generation and accounting data entry

Not Good Candidates

• Tasks requiring subjective human judgment (e.g., product photography, creative copywriting)
• Highly variable processes with no predictable pattern
• One-off projects that will not recur

---

How to Get Started

1. Audit your workflows. Track how your team spends time for one week. Identify repetitive, rule-based tasks.
2. Calculate potential ROI. Multiply hours saved by hourly cost. Compare against automation investment.
3. Start with one process. Do not try to automate everything at once. Pick the highest-impact workflow.
4. Measure results. Track time saved, errors reduced, and capacity gained. Use data to justify expanding automation.

---