The Days of Manual Logging
Three months ago, we tracked buyer email send times and response times in a notebook, then transferred them to Google Sheets. On weekends, we manually calculated elapsed time with a calculator. Every Monday morning, we'd just glance at who responded fastest and move on.
What the Bot Started Doing Automatically
I left Claude Code a simple instruction.
Compare column B (send time) and column C (response time) in the sheet. Auto-calculate elapsed time in column D. If no response time, mark as "Awaiting."
From the next week onward, the bot automatically ran every night at 11 PM:
1. Calculate average response time per buyer
2. Sort delayed responders (over 72 hours)
3. Aggregate response rates by time block (morning, afternoon, evening)
4. Compare weekday vs. weekend response speed
The Unexpected Discovery
When we first reviewed one week of data, we were amazed. The "fast responders" we thought we knew didn't match the actual numbers.
• One buyer had a 90% response rate between 2-3 PM on Tuesdays
• Emails sent Friday afternoon consistently took 72+ hours to get replies
• Different regions showed distinct time-slot preferences
Now we check the "buyer time profile" before reaching out. "Oh, this one's golden window is Wednesday morning," that kind of thing.
Before and After
Before (Manual Logging Era)
• 5+ hours per week on data entry
• Detecting delayed responses: 1 week lag
• Response pattern analysis: Nearly impossible
• Outreach timing: Vague (morning or afternoon)
After (Bot Auto-Tracking)
• Data entry time: 0 minutes (automated nightly)
• Delay detection: Real-time alerts
• Response patterns: Auto-generated weekly report
• Outreach timing: Data-driven optimization
A Small Lesson
Automation doesn't always deliver sweeping system overhauls. Instead, this tiny tracking step quantified our business instinct, and suddenly our whole team responded faster. The bot quietly shows us patterns we never noticed before, every single night.