The Scenario
You are an SEO lead. Your manager just asked for a new report: which competitor domains get cited most in AI search responses for your target keywords.
You have 20 competitor domains and 15 target keywords in a Google Sheet. The AI-SEO report is due Friday afternoon and it is Wednesday morning.
Nobody on the team has run this report before. The DataForSEO LLM mentions endpoint exists. You are the one who has to figure out how to pull it.
The bad version:
- You read the DataForSEO LLM mentions API documentation for an hour
- You write a script to loop through 15 keywords, call the endpoint, and parse the top domains
- The response structure is different from what the docs showed and your parser breaks
- You fix the parser, run it again, and realize the rate limit paused your batch halfway through
- You resume, combine the output, and paste it into the sheet manually, misaligning two keyword rows
- You deliver a report on Friday that your manager cannot verify and you cannot easily rerun.
The fast version is one prompt.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your spreadsheet that reads your keyword list, calls DataForSEO's LLM mentions endpoint for each keyword, and writes the top-cited domains and mention counts directly into the sheet.
Open the SheetXAI sidebar and type:
For each keyword in column A of my AIKeywords sheet, fetch DataForSEO LLM mentions top domains and write the top-5 cited domains with their mention counts into columns B through K.
SheetXAI calls the LLM mentions endpoint for each keyword, extracts the top 5 domains and their mention counts, and writes them into the sheet in a consistent structure. Column B is the top domain, column C is its mention count, column D is the second domain, and so on.
What You Get
An AIKeywords sheet with 10 new columns per keyword:
- Column B — top cited domain for that keyword
- Column C — that domain's mention count
- Columns D-K — domains 2 through 5 and their mention counts
All 15 keywords, top 5 domains each, fully populated. Count appearances across rows to identify which competitor dominates AI search results overall. Pivot by domain to see which keywords each competitor "owns" in AI responses.
What If the Data Is Not Quite Ready
AI visibility research is new territory and the data requests evolve quickly. SheetXAI handles the variations in one prompt.
When you want a summary format instead of a column-per-domain layout
Your manager wants to read the top domains per keyword in one cell, not across 10 columns.
For each keyword in column A of my AIKeywords sheet, fetch DataForSEO LLM mentions top domains. Write a summary into column B for each keyword in the format: "1. domain.com (12 mentions), 2. domain2.com (8 mentions), 3. domain3.com (5 mentions)."
When you want to check specific competitor domains instead of top-5 overall
You only care whether your 20 tracked competitor domains appear, not the full top-5 leaderboard.
For each keyword in column A of my AIKeywords sheet, fetch DataForSEO LLM mentions data. For each keyword, check whether any of the domains listed in my CompetitorDomains tab appear in the LLM citations. Write the citation count for each competitor into the matching cell at the intersection of the keyword row and competitor column.
When you want to track this report weekly
The first run is done. Now you want to set up a recurring pull so you can see how AI visibility changes over time.
Run the same DataForSEO LLM mentions pull as last week: for each keyword in column A of my AIKeywords sheet, fetch top-5 cited domains and mention counts. Write results into a new tab called
LLM_$(today's date)so each week's data is preserved separately.
When you need the full data pull plus a written competitive summary in one shot
Your manager wants the numbers and a one-paragraph explanation of what they mean.
For each keyword in column A of my AIKeywords sheet, fetch DataForSEO LLM mentions top domains and write the top-5 cited domains with mention counts into columns B through K. Then create a Summary sheet and write a short paragraph identifying which competitor domain appears most across all 15 keywords in AI responses, and which of our target keywords give that competitor the strongest AI visibility advantage.
The pattern: the data pull and the written analysis happen in one prompt — the report is ready for Friday without a second pass.
Try It
Get the 7-day free trial of SheetXAI and open any sheet with a keyword list, then ask it to pull DataForSEO LLM mentions data. The DataForSEO integration is included in every SheetXAI plan. For related workflows, see how to pull SERP rankings in bulk or the DataForSEO in Google Sheets overview.