The Scenario
You are a global PPC manager at an international B2B software company. You are building a location targeting matrix for next quarter's campaign. The campaign will run Google Search ads across 30 countries with different language targets.
Your media planner needs a reference sheet: every country Zenserp supports, with its country code and available language options, so the team can pick the right targeting parameters without guessing or digging through API documentation.
That reference sheet does not exist yet. You volunteered to build it.
The bad version:
- Open the Zenserp API documentation.
- Find the section listing supported countries.
- Manually copy each country name and code into the sheet.
- Find the language list, do the same.
- Realize the documentation format doesn't make it obvious which languages apply to which countries.
- Spend 45 minutes reading docs that were designed for developers, not media planners.
The media planner needs the reference by tomorrow morning. You have other campaigns to manage.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your Google Sheet. It connects to Zenserp, fetches the complete list of supported search locations, and writes the reference table directly into your sheet.
Fetch the full list of supported Google search countries from Zenserp and write each country name and country code into this sheet in columns A and B
What You Get
- Column A: country name (e.g., United States, Germany, Brazil)
- Column B: country code (e.g., us, de, br)
- One row per country, sorted alphabetically by country name
- The sheet becomes a static reference the team can filter and use as a dropdown source
What If the Data Is Not Quite Ready
You need language options alongside country codes
The campaign also targets language specifically, not just country, and you need the full language list per country.
Fetch the complete list of supported search locations from Zenserp and write country name in column A, country code in column B, and available language codes in column C. If multiple languages are available per country, list them as a comma-separated value in column C.
The reference needs to include location codes for city-level targeting
Some campaigns target cities rather than countries. You need Zenserp's supported city-level location codes as a second tab.
Fetch the Zenserp supported countries list and write it to the Countries tab with name in column A and code in column B. Then fetch the city-level location list and write it to the Cities tab with city name in column A, country in column B, and location code in column C.
You want to cross-reference against your active campaign markets
Your campaign runs in 12 specific countries. Column A of the "Active Markets" tab has those country names. You want to confirm that all 12 are in Zenserp's supported list and note any that are not.
Fetch the complete list of Zenserp supported countries with country name and country code. For each country in column A of the Active Markets tab, check whether it appears in the Zenserp list. If it does, write the matching country code into column B of the Active Markets tab. If it does not appear, write "not supported" in column B.
Full pipeline: fetch locations, join against campaign targets, flag gaps, build a reference tab
Fetch the full list of Zenserp supported countries and write them into a tab called "Zenserp Reference" with country name in column A and country code in column B. Then compare the country names against column A of the Active Markets tab. For each active market that matches, write the Zenserp country code into column C of the Active Markets tab. For each active market with no match, write "check targeting" in column C. After the join, sort the Active Markets tab by column C so unmatched rows appear at the top.
Fetch the data, join it, flag the gaps, and sort the output in one instruction.
Try It
Get the 7-day free trial of SheetXAI and open a blank sheet for your campaign location reference, then ask it to pull the full Zenserp supported location list and format it as a lookup table. Once you have the reference built, the geo-targeted rank tracking spoke shows how to put those location codes to work.