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 worksheet with all Google-supported language codes and their names — the kind of thing you'd use as a XLOOKUP 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 workbook 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 Excel workbook. It calls Autom's languages endpoint, pulls the complete list, and writes every language code and name into the workbook in one operation. You tell it where you want the data; it handles the rest.
Pull the complete list of Google language codes from Autom and paste them into the Excel 'LocaleMatrix' sheet with columns: LanguageCode, LanguageName.
What You Get
- The 'LanguageCode' column populated with the Google language code for every language Autom returns (e.g., "en," "pt-BR," "zh-CN")
- The 'LanguageName' column populated with the corresponding full language name (e.g., "English," "Portuguese (Brazil)," "Chinese (Simplified)")
- One row per language
- 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 workbook 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 the 'LanguageCode' column of the 'LocaleMatrix' sheet. Write only codes that don't already exist into new rows at the bottom, with the corresponding name in the 'LanguageName' column.
The project needs languages sorted alphabetically by name, not by code
Fetch all Google-supported languages from Autom. Write the language code into the 'LanguageCode' column and the language name into the 'LanguageName' column of the 'LocaleMatrix' sheet. Sort the rows alphabetically by 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 'LanguageCode,' the language name into 'LanguageName,' and a best-guess BCP 47 locale tag into a new 'BCP47Tag' column (e.g., "en" → "en-US," "pt-BR" → "pt-BR") in the 'LocaleMatrix' sheet.
Full locale matrix build in one shot
Fetch all Google-supported languages from Autom. Write the language code into 'LanguageCode' and the language name into 'LanguageName' in the 'LocaleMatrix' worksheet. Add a 'RegionScope' column — for language codes that include a region tag (like "pt-BR" or "zh-CN"), write "Regional"; for plain language codes (like "en" or "fr"), write "Global." Sort the completed rows alphabetically by language name.
One prompt builds the full matrix, annotates it, and sorts it — no intermediate steps.
Try It
Open a blank or template workbook 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.