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 is clear: find the keywords where all three of your main competitors rank, but your brand does not. That is the priority opportunity list for next year's content investment.
You have your domain and three competitor domains in a Google Sheet.
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 is not structured the way your sheet expects
- You filter to keywords where your domain is absent, get 3,200 results
- You try to further filter to keywords where competitors rank top 10, but the filter combinations in the Semrush UI are not what you need
- You export again, reformat the CSV in a staging sheet, VLOOKUP to add 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 sheet.
Open the SheetXAI sidebar and type:
Compare the domain in cell A1 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 sheet 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 ranking positions per keyword.
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 domain, showing their ranking position (blank if not ranking)
Sort by SearchVolume descending. The highest-volume keywords where multiple competitors rank and you are absent are your Year 1 priority list. One keyword where all three competitors rank in the top 10 is more actionable than ten keywords where only one competitor has a marginal position.
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. You want keywords where multiple competitors are entrenched.
Run the Semrush domain vs. domain comparison for A1 versus B1, C1, and D1. Only include keywords in the GapOpportunities sheet where at least two competitor domains rank in positions 1–10 and our domain (A1) is absent or ranks below 20.
When you want to filter out very high difficulty keywords
Not all gap opportunities are worth pursuing. Keywords with difficulty above 75 are out of reach for most content investments.
After building the GapOpportunities sheet, 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, so the most accessible high-volume gaps appear first.
When you want to group gaps by topic cluster for the content team
The content team plans by topic cluster, not individual keyword. They need the opportunity list organized by theme.
After building the GapOpportunities sheet, group the keywords by topic: scan the keyword text and assign each to one of these clusters: "Product Pages," "Category Content," "How-To Guides," "Comparison Content," or "Other." Write the cluster in a Cluster column. Sort by Cluster then by 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, not raw data.
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 search 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. The content roadmap is ready to review.
Try It
Get the 7-day free trial of SheetXAI and put your domain in A1 and competitor domains in B1, C1, D1, 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 or the Semrush in Google Sheets overview.