← Article List
Nest Article · Case

Google Form Auto-Detects Buyer Language, Switches Reply Templates Instantly

SiriSiri·2026-09-17
Nest Article #338

Google Form Auto-Detects Buyer Language, Switches Reply Templates Instantly

A non-developer built language detection into Google Forms using Claude Code. Korean, English, and Chinese inquiries now instantly trigger matching reply templates, cutting response time by 60%.

Siri

Siri

Siri

🪺 Bella's Nest Article

Before: Manually Reading Language, Searching for Templates One by One

Every morning, the team opened Google Forms to check buyer inquiries.

「English, need to find the English template」
「Chinese. Where's the Chinese version again?」
「Korean. Simple request, but takes time」

Copy-pasting three language templates for each inquiry averaged 3 minutes per message. Twenty daily inquiries meant 1 hour gone.

After: The Moment a Form Response Arrives, Language is Set

Built a script with Claude Code connected to Google Sheets. When a form response lands:

1. Analyze inquiry text → Auto-detect language (Korean/English/Chinese)

2. Assign matching template row based on language

3. Notify team's Slack: 「English, use template row 3」

4. Reply draft ready to send

The same task now takes 30 seconds.

Unexpected Discovery: Chinese Detection Was Most Accurate

Early tests revealed a surprise.

Korean detection: 90% accuracy (occasional misreads on mixed text)

English detection: 88% accuracy (abbreviations, product names)

Chinese detection: 98% accuracy (character structure advantage)

The team laughed and said: 「AI reads Chinese characters best」

Team Impact: Rote Tasks Disappeared

Response time wasn't the only thing that improved.

Before: Find template, paste, check typos → Send reply (repeat)

After: Review draft, add one personalized line → Send reply

Same person, same job, better quality. They now spend template time writing buyer-specific messages instead.

Why This Works: Claude Code's Context Understanding

Telling AI to 「distinguish languages」 gives 50% success. Claude is different.

"Specifications" appears in product inquiry → English

「库存」appears → Chinese

「納期」or 「サンプル」appears → Korean

It reads not just words but business terminology, honorifics, and sentence structure. That's why accuracy is high.

Next Goal: Auto-Add Language-Specific Stock Info

The team is currently testing:

When a buyer asks in English, automatically append: 「Available quantity in stock: [number]」.

For Chinese, add: 「现货库存: [数量]」.

Once complete, buyers see all information just by reading the message.