The Scenario
An international SEO manager is preparing a ranking landscape report for a client entering two new markets simultaneously — China and Russia. Eighty keywords are in column A of an Excel workbook, split between Mandarin and Russian terms. The client presentation is next Wednesday. The local search visibility baseline does not exist yet.
The bad version:
- Access Baidu (which requires a China-based IP or VPN to return accurate localized results), search keyword 1, read the top 5 organic results, translate the titles, copy them into columns B through F
- Do the same on Yandex, search keyword 1 again, find the top 3 organic results, copy titles, URLs, and snippets — which are in Cyrillic, requiring translation before the data is usable
- Get through 10 keywords across both engines before realizing the methodology is breaking down: some results are translated, some are not, the columns do not line up consistently, and the VPN is throttling the Baidu results
A ranking baseline built with an inconsistent methodology is not a baseline. It is a collection of observations with no way to compare them.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Excel workbook. It reads the keyword list in column A, calls SerpApi's Baidu endpoint for each one using localized parameters, and writes the organic results back — all 80 rows, consistently. One prompt handles Baidu; a second handles Yandex.
For each keyword in column A, search Baidu via SerpApi and put the top 5 organic result titles and URLs into columns B through K
What You Get
- Columns B, D, F, H, J receive the organic result titles for positions 1 through 5
- Columns C, E, G, I, K receive the corresponding URLs
- Keywords with fewer than 5 organic results leave the later columns blank
- Keywords that return no Baidu results get a note in column L
What If the Data Is Not Quite Ready
Keywords in column A are in English and need to be searched in the target language
For each keyword in column A, translate the term to Mandarin Chinese before searching Baidu via SerpApi, write the translated keyword in column B, and write the top 5 organic result titles and URLs into columns C through L
You want Yandex results in the same workbook for comparison
For each keyword in column A, search Yandex via SerpApi and fill in the top 3 organic result titles, URLs, and snippets into columns B through G
You want to identify which competitor domains appear most frequently across Baidu results
Search Baidu via SerpApi for each keyword in column A, write the top 5 result domains (not full URLs) into columns B through F, then count the frequency of each unique domain across all rows and write a domain frequency summary starting at row 85
Full dual-engine pull with overlap flagging in one prompt
Search Baidu via SerpApi for each keyword in column A and write the top 3 result domains into columns B through D; search Yandex via SerpApi for the same keywords and write the top 3 result domains into columns E through G; flag in column H any keyword where the same domain appears in both Baidu and Yandex top 3 results
Cross-engine overlap identification in a single pass.
Try It
Get the 7-day free trial of SheetXAI and open your international keyword tracking workbook before the client presentation, then ask SheetXAI to pull Baidu and Yandex results for every keyword. Also see the spoke on pulling Naver results for Korean market research, or the hub overview of all SerpApi workflows.