The Problem Was Simple
Yesterday morning, the Google Sheets on my main Windows device had accumulated 50 rows. All were orders from different buyers, each with a different delivery deadline.
What I had to do every morning:
1. Open the sheet
2. Manually scan for orders with approaching deadlines
3. Transfer them to Excel
4. Post updates in the team chat
"Couldn't we automate this?"
The first member of our AI dream team, the Hamsters, suggested this. As a non-developer, I opened Claude Code and threw out my question.
"Can you compare the dates in column A of Google Sheets with today's date, filter only orders arriving within 7 days, and put them in a separate tab?"
An Unexpected Mistake
Three hours after Claude generated the code, the first automation result appeared on my Windows device.
But something was wrong.
Orders with delivery dates that "had already passed" weren't being filtered out. I still had to find them manually.
The reason was simple. Claude's code was designed to track only "future dates," so already-started deadlines were being excluded.
"I thought I'd never catch this as a non-developer, but thank goodness I did."
I asked Claude again.
"Can you expand the range from yesterday to 7 days ahead? And can you mark urgent orders in red?"
Completed in 8 Hours
After the second execution, Google Sheets finally did its job.
• Orders that started yesterday (red)
• Orders within 3 days from today (orange)
• Orders 4-7 days away (yellow)
Each category automatically got its own color. Without lifting a finger.
What's even more amazing is that every morning at 7 AM, the Google Apps Script on my Windows device automatically repeats this filtering. Weekends included.
"So now I just look at the color codes?"
The Puppies from our AI dream team laughed.
"For a non-developer, this is honestly incredible. If we could just solve the time zone issue, it'd be perfect..."
An Unexpected Bonus
Four days later, another change happened.
Google Sheets started automatically updating shipping status. When a buyer's email subject contained "Shipped," the corresponding row in the sheet turned gray.
I didn't give that command. The dream team had secretly added that feature.
"Wait, what are we doing now?"
"Resting. The bots are working all night."
The Hamsters' answer was precise.
Results
Before
• 30 minutes every morning spent (sorting sheets + posting updates)
• 2-3 missed deadlines per month
• Manual team member reviews required
After
• 2 minutes in the morning (just checking the color codes)
• Zero missed deadlines (automatic alerts)
• Windows device manages everything alone
Once again, we proved that non-developers can hand off their daily tasks to machines, all they need is Claude Code.
Today, Google Sheets is quietly working on its own.