The Daily Nightmare: The Missing Tracking Number Check
Our team running a B2B business spent every morning manually reviewing orders in Google Sheets. "Does this order have a tracking number?" This simple but repetitive question consumed over 30 minutes each week, and sometimes we still missed entries.
Particularly on Friday afternoons, when a buyer's email arrived asking "Why is there still no tracking information?", we'd scramble to confirm "Oh, we didn't record this one."
Before: The Limits of Manual Work
• **Time to review 1,500 orders**: approximately 3 days (sporadic)
• **Missing entry detection rate**: 70~80% (varies with fatigue)
• **Buyer complaints**: 2~3 per month (due to delayed tracking info)
• **Process**: Sheet filtering > Manual scanning > Notepad organization > Email dispatch
The Solution: Claude Code Automation Bot
On a Windows device, I opened Claude Code and gave simple instructions.
Automatically check the Google Sheet for:
1. Locate rows with "Order ID" field
2. Find empty cells in "Tracking Number" column
3. Organize empty rows into a separate list
4. Export as CSV
After: The Power of Automation
• **Time to review 1,500 orders**: approximately 5 minutes (automatic)
• **Missing entry detection rate**: 99.8% (human fatigue eliminated)
• **Buyer complaints**: Nearly zero (proactive prevention)
• **Process**: Bot execution (automatic) > CSV download > Notify team member
The Unexpected Discovery
The bot didn't just find empty cells. We discovered something we'd been missing.
"Wait, there's a tracking number filled with '0000'?"
Some rows had placeholder values or typos in the tracking field. When checking manually, we'd think "Well, there's something there" and move on. The bot added format validation, using regex to filter only "valid tracking formats."
Team's Reaction
Initially there was skepticism: "Can this really work automatically?" and "What if something gets missed?" But after one week of validation, the bot's accuracy actually exceeded manual checking.
Now, every Monday morning the bot runs and produces a list of missing entries. The team member only needs to review that list.
Lessons Learned
1. **Smaller repetitive tasks have bigger impact**: 5 minutes daily becomes 2 hours saved monthly.
2. **Bots discover what humans miss**: Format validation uncovered unexpected errors.
3. **Build trust first, then expand**: Spending the first week validating results built confidence to scale automation rules.
---
Today, instead of dealing with buyer frustration over missing tracking information, we redirect that time toward improving customer relationships.