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 Google Sheet. It reads the data in your sheet, 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 sheet.
For each keyword in column A (100 rows), run a Piloterr Google search and write the top organic result URL into column B and the page title into column C
What You Get
- Column B fills with the top organic result URL for each keyword — not the paid ad, the first organic hit
- Column C fills with the corresponding page title exactly as Google returns it
- Rows where Piloterr returns no organic results (heavily featured-snippet keywords, for example) get a note in column D so you know the gap exists
- The sheet 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 column A (100 rows), run a Piloterr Google search and write the top organic URL into column B and the page title 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 column A (120 rows of keywords, 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 title 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 column A, 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 column A (120 rows), strip any trailing whitespace, mark rows where the keyword contains 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 title into column C
The pattern with Piloterr keyword work: 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 Google Sheet 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 how SheetXAI handles the multi-country version of this workflow if your SEO scope spans multiple markets, or the full Piloterr integration overview to see what else you can pull.