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 15 keywords in column A of an Excel workbook. The AI-SEO report is due Friday afternoon and it is Wednesday morning.
Nobody on the team has run this report before.
The bad version:
- You read the DataForSEO LLM mentions API documentation for an hour
- You write a script to loop through 15 keywords and parse the top domains
- The response structure is different from the docs and your parser breaks twice
- You get it working, combine the output CSVs, and import them into Excel
- The import adds three extra columns and the keyword rows are in a different order than your workbook
- You deliver a report on Friday that mismatches two keywords and your manager notices.
The fast version is one prompt.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your Excel workbook 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 workbook.
Open the SheetXAI sidebar and type:
For each keyword in column A of my AIVisibility tab, 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 mention counts, and writes them into the workbook in a consistent structure. Column B is the top domain, column C is its mention count, and so on.
What You Get
An AIVisibility tab with 10 new columns per keyword:
- Column B — top cited domain for that keyword in AI search responses
- 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. Build a PivotTable to count total appearances by competitor domain across all keywords, or filter 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 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 AIVisibility tab, fetch DataForSEO LLM mentions top domains. Write a summary into column B in the format: "1. domain.com (12 mentions), 2. domain2.com (8 mentions), 3. domain3.com (5 mentions)."
When you want to check only your tracked competitor domains
You care whether your 20 tracked competitors appear, not the full top-5 leaderboard.
For each keyword in column A of my AIVisibility tab, 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 run this weekly and preserve each week's data
The first run is done. Now you want a recurring pull that keeps historical snapshots.
Run the DataForSEO LLM mentions pull for each keyword in column A of my AIVisibility tab. Write the top-5 cited domains and mention counts into a new tab called
LLM_$(today's date)so each week's data is preserved separately.
When you need the full data plus a competitive summary for the report
Your manager wants the numbers and a one-paragraph explanation.
For each keyword in column A of my AIVisibility tab, 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 tab and write a short paragraph identifying which competitor domain appears most across all 15 keywords in AI responses and which keywords give that competitor the strongest AI visibility advantage.
The pattern: the data pull and the written analysis happen in one prompt — the Friday report is ready without a second pass.
Try It
Get the 7-day free trial of SheetXAI and open any Excel workbook 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 in Excel or the DataForSEO in Excel overview.