The Scenario
You're the international SEO strategist, and the project starts Monday: 18 markets, multilingual keyword research, a content matrix that needs to account for every locale combination. You need a reference sheet with all Google-supported language codes and their names — the kind of thing you'd use as a VLOOKUP source for the rest of the project.
The last time a project needed this, whoever set it up pulled the language codes from a blog post that turned out to be two years old. Three codes were wrong. Nobody caught it until a client pointed out that the "Portuguese (Brazil)" targeting was misconfigured.
The bad version:
- Find the current Autom API docs for the languages endpoint, make sure it's the right one (not the deprecated version), call it, parse the JSON response manually
- Copy each language code and name into the sheet one at a time — 50+ entries
- Realize the API response has language codes in a nested object, not a flat array, and restructuring it into two clean columns takes another 20 minutes
This is supposed to be the setup work that takes fifteen minutes before the actual research starts. It keeps taking an hour.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Google Sheet. It calls Autom's languages endpoint, pulls the complete list, and writes every language code and name into the sheet in one operation. You tell it where you want the data; it handles the rest.
Fetch all Google-supported languages from Autom and write the language code into column A and the language name into column B of this sheet, one language per row. Start at row 2 — row 1 has headers.
What You Get
- Column A populated with the Google language code for every language Autom returns (e.g., "en," "pt-BR," "zh-CN")
- Column B populated with the corresponding full language name (e.g., "English," "Portuguese (Brazil)," "Chinese (Simplified)")
- One row per language, starting at row 2
- The list is complete — drawn directly from Autom's endpoint, not a cached or partial list
What If the Data Is Not Quite Ready
The sheet already has some language codes from a previous project and needs to be deduplicated
Fetch all Google-supported languages from Autom. Compare the language codes to the values already in column A of this sheet. Write only codes that don't already exist in column A into new rows at the bottom, with the corresponding name in column B.
The project needs languages sorted alphabetically by name, not by code
Fetch all Google-supported languages from Autom. Write the language code into column A and the language name into column B, starting at row 2. Sort the rows alphabetically by column B (language name) after writing.
The locale matrix needs a third column with the BCP 47 tag derived from the language code
Fetch all Google-supported languages from Autom. Write the language code into column A, the language name into column B, and a best-guess BCP 47 locale tag into column C (e.g., "en" → "en-US," "pt-BR" → "pt-BR"). Start at row 2.
Full locale matrix build in one shot
Fetch all Google-supported languages from Autom. Write the language code into column A, the language name into column B. Add a column C header "Region Scope" — for language codes that include a region tag (like "pt-BR" or "zh-CN"), write "Regional" in column C; for plain language codes (like "en" or "fr"), write "Global." Sort the completed rows alphabetically by column B. Start data at row 2; row 1 already has headers: LanguageCode, LanguageName, RegionScope.
One prompt builds the full matrix, annotates it, and sorts it — no intermediate steps.
Try It
Open a blank or template sheet for your international SEO project and get the 7-day free trial of SheetXAI — then ask it to pull the complete Google language code list from Autom in one shot. Also see: resolving city and region names to location codes and the Autom hub overview.