The Scenario
You are a growth marketing director at a company with five company domains in a Google Sheet, a mix of regional sites and product sub-brands. Quarterly landscape review is next week. You need the top 10 organic search competitors for each domain from Semrush, with common keyword count and competitor authority score, all in one flat table.
The first question at the review will be: "Who are we actually competing against, and how big are they?"
The bad version of this week:
- You open Semrush and pull the organic competitors report for Domain 1
- You export it, paste it into a tab, label it
- You repeat for four more domains
- You now have five tabs and no single view
- You manually copy rows from each tab into a summary tab
- You forget to add the Domain column when you paste from tab three
- You spend Wednesday rebuilding the summary table with correct domain labels.
The fast version is one prompt.
The Easy Way: One Prompt in SheetXAI
SheetXAI reads the domain list and pulls the organic competitor data for each domain from Semrush, assembling it all into one flat table.
Open the SheetXAI sidebar and type:
For each domain in column A, fetch its top 10 organic search competitors from Semrush and write each competitor domain, common keyword count, and authority score into new rows in a Competitors sheet. Include a Domain column so I can filter by which of my domains each competitor set belongs to.
SheetXAI iterates through all five domains, pulls competitor data for each, and builds the Competitors tab with a Domain column keeping everything attributed.
What You Get
A single Competitors tab with up to 50 rows (10 per domain):
- Column A — OurDomain — which of your five domains this row belongs to
- Column B — CompetitorDomain — the competing site
- Column C — CommonKeywords — number of keywords both domains rank for
- Column D — AuthorityScore — Semrush authority score of the competitor
Sort by OurDomain, then by CommonKeywords descending. The competitors you share the most keyword overlap with are your real search rivals, not just the ones with the biggest brand. Sometimes they are not who you expected.
What If the Data Is Not Quite Ready
Competitor lists need context to be useful.
When you want to deduplicate competitors that appear across multiple domains
The same large competitor shows up in the top 10 for four of your five domains. You want a deduplicated view showing which of your domains each competitor overlaps with.
After building the Competitors tab, create a deduplicated view in a new tab called CompetitorSummary. For each unique competitor domain, list the CompetitorDomain, AuthorityScore, and a column showing which of our domains it appears as a competitor for, as a comma-separated list.
When you want to flag competitors above a certain authority threshold
Your team only wants to track competitors with an authority score above 40. Below that, they are not worth monitoring.
Pull top 10 organic competitors per domain as above. In the Competitors tab, add a Priority column: write "Track" for competitors with authority score above 40, and "Ignore" for those below. Filter the view so "Ignore" rows move to the bottom.
When you need common keyword count and SE traffic for each competitor
Common keywords alone do not tell the full story. A competitor with 200 common keywords but huge organic traffic is a bigger threat than one with 500 common keywords and minimal traffic.
For each domain in column A, fetch its top 10 organic competitors from Semrush. For each competitor, write competitor domain, common keyword count, SE traffic estimate, and authority score into the Competitors tab with a Domain column. Sort by SE Traffic descending within each domain group.
When the full landscape review needs competitor data, a ranking by threat level, and a summary narrative in one pass
The deck needs numbers and prose.
For each domain in column A, fetch the top 10 organic competitors from Semrush. Write competitor domain, common keywords, SE traffic, and authority score into a Competitors tab with a Domain column. Then rank competitors by a composite threat score: common keywords × 0.4 + authority score × 0.6, normalized to 100. Write the threat score in a ThreatScore column. Finally, write a 2-sentence summary for each of our five domains at the top of the Competitors tab describing who the top competitor is and why they are the biggest search threat.
The pattern: the data pull, the scoring, and the narrative for the deck all come from one prompt.
Try It
Get the 7-day free trial of SheetXAI and put your domains in column A, then ask it to build the competitive landscape table. The Semrush integration is included in every SheetXAI plan. For a related workflow, see how to run a PPC competitive intelligence pull from Semrush or the Semrush in Google Sheets overview.