The Scenario
It's Tuesday afternoon and your support team lead just forwarded you a spreadsheet with 5,000 incoming chat messages that need to be routed to language-specific queues before end of day. Column A has the message text. Column B should have the ISO language code. It doesn't. Someone was supposed to handle this on Friday.
The bad version:
- Run a language detection library locally, find it supports 12 languages and your inbox has at least 20, realize you need the Tisane API specifically
- Write a script that calls Tisane per row, realize the rate limit is going to make this a 40-minute job even if the script doesn't fail
- The script fails on row 1,847 because one message is a single emoji, returns an unexpected response shape, and your error handling wasn't built for that
Five thousand rows need column B filled. The routing queue is waiting. Your afternoon just disappeared.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Google Sheet. It connects to Tisane directly and writes the detection results back into your sheet — no script, no rate-limit babysitting.
Detect the language of every entry in the 'Message' column using Tisane and write the ISO language code into the 'Language' column
What You Get
- Column B ('Language') filled with ISO 639-1 codes: "en", "es", "de", "fr", "ja", and so on across all 27 supported languages
- Rows where Tisane cannot confidently identify a language (single emoji, random characters) get a blank cell rather than a wrong guess
- No partial runs — the whole column processes before results are written back
What If the Data Is Not Quite Ready
Some rows in 'Language' already have values from a previous partial run
For all rows in the sheet where the 'Language' column is empty, call Tisane language detection on the 'Message' column and fill in the result — leave existing values untouched
The text column has entries that are just numbers, links, or punctuation
Detect the language of each entry in column A using Tisane — skip any row where the text is shorter than 3 characters or contains only digits and punctuation — write results to column B
Messages are split across three tabs by support tier
Detect language using Tisane for the 'Message' column on the 'Tier 1', 'Tier 2', and 'Tier 3' tabs — write the ISO code into the 'Language' column on each respective tab
Full pipeline: detect language, then group and count by language in one shot
Detect the language for every row in column A using Tisane and write the ISO code into column B, then create a summary on a new tab called 'Language Breakdown' that counts how many messages per language code — sorted descending
One prompt handles detection and summarization together without an intermediate export step.
Try It
Get the 7-day free trial of SheetXAI and open any Google Sheet with a mixed-language text column, then ask it to detect and tag every row. To combine this with content analysis, see bulk text analysis with Tisane or abuse classification. The full Tisane integration overview is at the hub.