The Problem Begins
Every morning, opening the Windows desktop email inbox reveals 10 to 15 shipping notifications. Each message mixes courier names, tracking codes, and delivery statuses without clear structure.
The team member's daily routine:
1. Open emails one by one
2. Manually hunt for tracking numbers in the text (not highlighted)
3. Copy and paste into Google Sheets
4. Manually enter courier names
This process consumed 30 minutes daily. 2.5 lost hours per week.
The Turning Point
Someone muttered, "There's probably a pattern here, right?"
There was.
Tracking code formats from each courier were nearly identical.
• Courier A: 12 digits at the start
• Courier B: Two letters + 10 digits
• Courier C: 10 digits + 1 check character
We fed these patterns into a regex script and let Claude Code auto-scan email bodies.
Before / After
Before (Manual Processing)
• Time: 30 minutes daily
• Accuracy: 90-92% (fatigue-driven errors)
• Volume: 12 items per day (speed-limited)
After (Claude Code + Google Sheets)
• Time: 2 minutes (validation-only after automation)
• Accuracy: 99.7% (near-zero pattern errors)
• Volume: 60 items per day (5x improvement)
Unexpected Rewards
Once tracking codes auto-collected, something new emerged.
The team could now automatically benchmark courier speeds. Who was fastest? Which carrier delayed most? Instantly visible.
Adding simple filters and pivot tables to the Sheets, monthly shipping reports began auto-generating.
Thirty minutes of automation ultimately yielded weekly 2-hour savings, plus one new business insight.
The Lesson
「Automation doesn't need to be grand」
Three to four lines of regex, Claude Code's simple scan logic, Google Sheets' IMPORTRANGE function. That's all.
When repetition surfaces, hunt for rules first. Then hand it off to the tool. This became our non-technical team's automation rhythm.
The next target is already chosen: real-time order quantity sync to inventory sheets.