The Scenario
The content roadmap meeting is Thursday. The content strategist needs a concrete list of what topics a competitor is winning on before the team debates what to build next. Someone pulled the competitor's sitemap two weeks ago and it has 4,000 URLs — none of which are sorted by any signal that matters. What you actually want is the competitor's top 50 pages by Page Authority, so you can see where they have earned real editorial weight.
The bad version:
- Log into Moz Link Explorer and run a top-pages search for the competitor domain. You get a table in the UI.
- Export to CSV. Open in Sheets. Realize the export has 12 columns you do not need and the PA column is fourth from the right. Trim, reformat.
- Now match this against your existing content calendar to identify gaps. That requires a VLOOKUP across two different files where the URL format conventions do not quite match.
By Thursday you have a spreadsheet that mostly works, you have explained it twice to colleagues who do not understand why the rows are sorted the way they are, and the original insight you were chasing has gotten buried under process.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Google Sheet. It connects to Moz, pulls the top pages for any domain, and writes the results directly into your sheet — with whatever column layout you specify.
Get the top 50 pages from competitor.com using Moz and list each page URL and its Page Authority in this sheet starting at row 2, sorted by Page Authority descending.
What You Get
- Column A fills with the top 50 page URLs from the competitor domain, sorted by Page Authority high to low.
- Column B fills with the Page Authority score for each URL.
- Rows start at row 2, leaving row 1 available for headers.
- URLs that rank but have no indexable Page Authority data are noted clearly rather than silently excluded.
What If the Data Is Not Quite Ready
You need top pages for multiple competitors, not just one
The roadmap meeting covers four competitor domains. You want one tab per domain.
For each domain in column A of the Competitors tab, fetch the top 20 pages from Moz and write each page URL and Page Authority into a separate tab named after the domain.
You want to cross-reference against your existing content URLs
Your editorial tracker is in the Content Calendar tab, with URLs in column B. You want to flag which competitor top pages you already cover.
Pull the top 50 pages from competitor.com using Moz and write each URL and Page Authority into columns A and B of this sheet, then check each URL in column A against column B of the Content Calendar tab and mark column C with "Covered" or "Gap" for each.
The URLs need cleaning before the comparison works
Trailing slashes, mixed HTTP and HTTPS, and parameter strings are making the matching inconsistent.
Pull the top 50 pages from competitor.com using Moz, normalize each URL to HTTPS with no trailing slash and no query parameters, write them to column A with Page Authority in column B, then match against normalized URLs in the Content Calendar tab column B and mark column C with "Covered" or "Gap."
Full competitive content audit in a single prompt
You need the top 30 pages for three competitors, their PA scores, and a column flagging which ones target keywords already in your tracker.
For each domain in the list competitor1.com, competitor2.com, competitor3.com — pull the top 30 pages from Moz, write domain name to column A, page URL to column B, Page Authority to column C, then check each URL against the Keywords tab column D and mark column D with "In scope" or "Not targeted."
Running the research and the gap analysis as one operation means you arrive at Thursday's meeting with a finished artifact rather than a half-merged CSV.
Try It
Get the 7-day free trial of SheetXAI and open your competitive research sheet, then ask it to pull the Moz top pages for whatever domain you are analyzing. The Moz integration is included in every SheetXAI plan. Also useful: bulk DA and Spam Score lookup and the full Moz integration overview.