Problem: The 30-Minute Classification Nightmare Every Morning
When running a small B2B team, dozens of buyer inquiries arrive daily. Reading each message, judging which region it came from, which product category they're interested in, and estimating order volume (then manually sorting it all) consumed 30+ minutes every single day.
「The process was too repetitive, and it was hard to apply judgment standards consistently. On tired days, I'd categorize the same buyer differently.」
Solution: Google Forms + Claude Code Alliance
Before: Manual Classification
• Open inbox every morning
• Read each inquiry one by one, type into Google Sheet manually
• Eye-judge region, industry category, budget stage, add manually
• Sometimes accidentally enter the same buyer twice
• Total time: ~30 to 40 minutes
After: Automatic Classification
• Buyer submits basic info via Google Form (company name, region, product interest, expected order volume)
• Claude Code automatically reads response data in background
• Auto-tags based on predefined rules (region group, industry, order volume tier)
• Google Sheet's conditional formatting kicks in, auto-colors each buyer row by category
• High-priority buyers (bulk order potential) highlighted orange; new market regions marked blue
• Duplicate inquiry from same company? Auto-flagged as「existing buyer」
• Total time: ~3 seconds (fully automated)
Detailed Build Process
Step 1: Google Form Design (2 hours)
We kept required fields simple:
• Company name
• Country/region (dropdown: Southeast Asia, Middle East, Europe, North America, etc.)
• Product category of interest (multiple choice)
• Expected monthly order volume (tiered options)
• Additional notes (open text)
Step 2: Claude Code Automation Logic (approximately 4 hours)
Python script executed on Windows device:
Read Google Form response data
↓
Auto-tag by region info 「region group」
↓
Calculate 「priority」score from order volume
↓
Search company name for duplicates (dedup)
↓
Auto-insert all info to specified Google Sheet row
↓
Auto-execute conditional formatting rule (coloring)
Step 3: Conditional Formatting (1 hour)
Rules defined in Google Sheet:
• 「Order volume: 10,000+」 → Orange (VIP buyer)
• 「Region: No existing trade」 → Blue (new market opportunity)
• 「Duplicate inquiry flag: ON」 → Gray (already contacted)
• 「Special requests: Urgent」 → Red (immediate response needed)
Unexpected Benefits Discovered
1. Errors Nearly Vanished
Classification mistakes practically disappeared. System applies consistent criteria every time.
2. Response Speed Skyrocketed
Now we spot VIP buyers (orange) at a glance and prioritize their emails. Average response time dropped from 8 hours to 2 hours.
3. Data-Driven Insights
Weekly sheet dashboard reveals patterns like 「this week's new buyers are concentrated in Southeast Asia」in seconds.
4. Team Scaling Ready
Without this automation, hiring new team members would require training on classification standards and validation. Now anyone opening the sheet sees pre-sorted data.
Lessons Learned
What Worked Well
• With「clear criteria」defined, automation becomes much easier. (Vague standards? AI can't judge.)
• Google Forms + Google Sheets combo naturally connects input to processing.
• Visual feedback like color-coding boosts team satisfaction and engagement.
Challenges Encountered
• Early on, buyers still preferred messaging or email over the form. (Required stronger link promotion)
• Asking too many details in「expected order volume」field made buyers uncomfortable. (Improved by switching to tiered choice)
What's Next
Claude Code is now beta-testing auto-generated reply drafts using a combo of「region-specific greetings」+ 「category-specific product recommendations」. Once that's fully working, there will be another story to tell.