The Scenario
You are a content marketing manager at an e-commerce brand. Annual content strategy planning is in three weeks. The brief from your CMO: find the keywords where all three main competitors rank but your brand does not. That is the opportunity list for next year's content investment.
You have your domain and three competitor domains in an Excel workbook.
The bad version of this project:
- You open Semrush's Keyword Gap tool and enter the four domains
- You run the comparison and get 8,000 results
- You try to export but the CSV structure does not match your workbook
- You filter to keywords where your domain is absent, get 3,200 results
- You try to filter further to keywords where competitors rank top 10, but the filter combinations in the UI are not what you need
- You export again, paste into a staging tab, reformat, VLOOKUP search volumes
- You deliver an opportunity list that took four days to build and still has formatting problems.
The fast version is one prompt.
The Easy Way: One Prompt in SheetXAI
SheetXAI uses Semrush's domain vs. domain comparison endpoint to find keyword gaps across your competitor set and writes the results directly into a clean opportunity tab.
Open the SheetXAI sidebar and type:
Compare the domain in cell A1 of the Domains tab against the competitors in cells B1, C1, and D1 using Semrush domain vs. domain and write all keywords where competitors rank but A1 does not into a tab called GapOpportunities with search volume and competitor positions for each competing domain.
SheetXAI runs the comparison, filters to true gaps where your domain is absent, and writes the GapOpportunities tab with search volumes and competitor positions.
What You Get
A GapOpportunities tab with:
- Column A — Keyword — the gap keyword
- Column B — SearchVolume — monthly US search volume
- Columns C, D, E — CompetitorPosition — one column per competitor, showing their ranking position
Sort by SearchVolume descending. The highest-volume keywords where multiple competitors rank and you are absent are your Year 1 priority list.
What If the Data Is Not Quite Ready
Keyword gap analyses need refinement before they are actionable.
When you only want gaps where at least two competitors rank top 10
A gap keyword where only one competitor ranks at position 18 is not a strong signal.
Run the Semrush domain vs. domain comparison for A1 versus B1, C1, and D1. Only include keywords in GapOpportunities where at least two competitor domains rank in positions 1–10 and our domain is absent or ranks below 20.
When you want to filter out very high difficulty keywords
Keywords with difficulty above 75 are out of reach for most content investments.
After building the GapOpportunities tab, for each gap keyword fetch the Semrush keyword difficulty score. Filter out any keyword with difficulty above 75. Add a Difficulty column. Sort by search volume descending, then difficulty ascending.
When you want to group gaps by topic cluster
The content team plans by topic cluster, not individual keyword.
After building GapOpportunities, group keywords by topic: scan the keyword text and assign each to "Product Pages," "Category Content," "How-To Guides," "Comparison Content," or "Other." Write the cluster in a Cluster column. Sort by Cluster then SearchVolume descending.
When the full opportunity brief needs gap data, difficulty scores, clustering, and a priority ranking in one operation
The CMO wants a ready-to-approve content roadmap.
Compare domain A1 against B1, C1, and D1 using Semrush domain vs. domain. Write gap keywords with search volume and competitor positions into GapOpportunities. For each gap keyword, fetch keyword difficulty. Filter out any with difficulty above 75. Group by topic cluster. Add a Priority column: "H1 Target" for volume above 2,000 and difficulty below 55, "H2 Target" for volume 500–2,000 or difficulty 55–70, "Backlog" for everything else. Sort by Priority then SearchVolume descending.
The pattern: the comparison, the enrichment, the clustering, and the prioritization all come from one prompt.
Try It
Get the 7-day free trial of SheetXAI and put your domain in A1 and competitor domains in B1, C1, D1 of any Excel workbook, then ask it to run the keyword gap analysis. The Semrush integration is included in every SheetXAI plan. For a related workflow, see how to pull the organic pages report from Semrush in Excel or the Semrush in Excel overview.