The Scenario
You're three weeks into tracking organic rankings for a set of 100 target keywords. The brief was simple: build a baseline, then check it every Monday to see what moved. The first week you ran it manually — opened Piloterr's playground, searched each keyword, copied the top URL and page title, pasted them into columns B and C. It took two hours. Last Monday you did it again. This Monday it's 8 AM and the keyword list has grown to 120 rows because the content team added a new cluster.
The bad version:
- Open Piloterr's search endpoint docs, run the query for keyword 1, copy the organic result URL and title from the JSON response
- Paste into row 1 columns B and C, advance to row 2, repeat — making sure you don't accidentally skip a row when the JSON structure varies for a featured snippet result
- Reach row 60 and realize the page title for row 43 landed in the URL column because you were going too fast; go back and fix that block manually
This is the kind of task that gets handed off to a junior analyst not because it requires judgment but because it requires endurance. And your junior analyst is already working on three other things.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Excel workbook. It reads the data in your worksheet, understands what you're looking at, and through its built-in Piloterr integration it can run searches and write results back — row by row, across the full column — without you leaving the workbook.
Read 80 keywords from the Excel column 'Keywords', search Google via Piloterr for each, and write the top result URL and snippet into columns B and C — flag any row where our domain appears in column D
What You Get
- Column B fills with the top organic result URL for each keyword
- Column C fills with the corresponding page snippet or title as Google returns it
- Rows where your domain appears in the top 10 results get the position noted in column D
- The worksheet is ready to compare against last week's version the moment the run finishes
What If the Data Is Not Quite Ready
Your domain shows up in the results and you need it flagged separately
For each keyword in the 'Keywords' column, run a Piloterr Google search and write the top organic URL into column B and the snippet into column C — if sheetxai.com appears anywhere in the top 10 results, write its position into column D, otherwise leave D blank
Some keywords are phrases and some are single words — the results look inconsistent
Read the 'Keywords' worksheet column (120 rows, mix of single words and multi-word phrases), run a Piloterr Google search for each exactly as written, write the top organic URL into column B and snippet into column C — do not modify or clean the keyword before searching
You want the top 3 results, not just the first
For each keyword in the 'Keywords' column, run a Piloterr Google search and write the top 3 organic result URLs into columns B, C, and D — if fewer than 3 organic results exist, leave the remaining columns blank for that row
You need to clean the keyword list, flag brand terms, and run the search in one pass
Read the 'Keywords' column (120 rows), strip trailing whitespace, mark rows containing our brand name "SheetXAI" with "brand" in column E, then run a Piloterr Google search for the remaining rows and write the top organic URL into column B and snippet into column C
The cleanup and the search happen in the same instruction, so you're not running two passes and comparing them.
Try It
Get the 7-day free trial of SheetXAI and open the Excel workbook where your keyword list lives — then ask SheetXAI to run the Piloterr search for each row and write the results back. Also worth looking at the multi-country version of this workflow or the full Piloterr integration overview.