The Problem: Buyer Data Was Always Incomplete
One Friday afternoon, a small team running B2B operations faced a recurring headache. Buyers sent weekly Excel files with order lists, but key fields (SKU, quantity, shipping address) were often missing. Team members had to manually check each file, and it ate up hours every week.
「Can we automate this part?」
That question sparked a Claude Code experiment.
---
The Solution: Claude Code + Google Sheets
Step 1: Use Google Forms to Collect Buyer Files
1. Create a Google Form and add an 「Excel File Upload」 field
2. Set responses to auto-save to your Google Drive folder
3. Share the form link with buyers
Google Forms Setup Tips:
• File size limit: Under 1GB
• Required fields: filename, order contact name, company name
Step 2: Give Claude Code File Reading Permission
Create a new tab in your Google Sheet: 「File Validation Results」
// Basic structure for Claude Code
const requiredColumns = [
'SKU',
'Quantity',
'Shipping Address',
'Delivery Date'
];
function checkMissingEntries(fileData) {
let missingCount = 0;
fileData.forEach(row => {
requiredColumns.forEach(col => {
if (!row[col] || row[col].trim() === '') {
missingCount++;
}
});
});
return missingCount;
}
Step 3: Set Up Daily Automatic Validation
Use the Windows Task Scheduler to run your Claude Code script every morning at 8:00 AM:
1. Open 「Task Scheduler」
2. Click 「Create Basic Task」
3. Trigger: 「Daily at 08:00」
4. Action: 「Run Claude Code validation script」
5. Condition: Computer idle for at least 1 minute
---
The Results: One Week's Worth of Change
• **Before**: Manual file checks took 2 hours per week
• **Now**: Automatic daily validation, missing items identified in 5 minutes
• **Bonus Effect**: Team members no longer worry about what might slip through the cracks
Reading Excel files and comparing data is something Claude Code does faster and more accurately than humans. Especially since the validation runs even over weekends, Monday morning meetings already have reports waiting.
---
Pre-Start Checklist
• [ ] Windows device and Google account set up?
• [ ] Claude Code API key obtained?
• [ ] Google Sheet sharing permissions granted to Claude?
• [ ] Required validation fields clearly defined?
Pro Tip: Run your first test with a sample file, not live data. Mistakes can compound if you go straight to production.
---
What's Next
Beyond detecting missing entries, we're now building features to automatically flag 「format errors」 (like mismatched date formats). The potential of Claude Code keeps surprising us.