The Scenario
The digital PR manager inherited the press outreach list from someone who left three months ago. The list has 340 entries, no DA scores, and a creation date of 2023. The new campaign targets top-tier placements only. Rather than auditing a stale list, the manager wants to start fresh: pull the globally highest-authority domains from Moz and use that as the foundation for the new target set.
The bad version:
- Try to find a global top domains export in Moz. Realize it is buried under several navigation layers and requires a specific plan tier to access.
- Export a CSV. Open it. The file has more columns than you wanted and the formatting does not match the intake template the VP of communications uses.
- Spend forty minutes trimming columns, renaming headers, and adding the Spam Score column separately — because the global top domains export did not include it and you need to cross-reference with a second Moz pull.
An afternoon of merge operations later, you have a list that still needs manual filtering before it is usable.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Google Sheet. It queries Moz for the global top domains, pulls the metrics you specify, and writes them directly into your sheet — in the column order you want.
Fetch the top 200 global root domains from Moz ranked by Domain Authority and write each domain name, DA score, and Spam Score to this sheet.
What You Get
- Column A fills with the top 200 root domains from Moz's global index, ranked by Domain Authority high to low.
- Column B fills with the Domain Authority score for each domain.
- Column C fills with the Spam Score for each domain.
- The list reflects the current Moz index — not a cached export from a previous date.
What If the Data Is Not Quite Ready
You want the list sorted by DA and already filtered by Spam Score threshold
The campaign policy is to exclude any domain with a Spam Score above 10.
Fetch the top 200 global root domains from Moz ranked by Domain Authority, write domain, DA, and Spam Score to columns A, B, and C, then remove any row where the Spam Score in column C is above 10.
You need linking domain count alongside DA
The outreach brief requires a third column — linking domains — to assess editorial reach.
Pull the global top domains list from Moz and write domain, Domain Authority, Spam Score, and linking domain count to columns A through D, sorted by DA descending.
You want to cross-reference against a publisher blocklist
The agency has a list of domains to avoid regardless of their DA. It is in the Exclusions tab, column A.
Fetch the top 300 global root domains from Moz and write domain, DA, and Spam Score to columns A, B, and C. Then check each domain in column A against the Exclusions tab column A and mark column D with "Blocked" for any match.
Full prospect list build in one prompt
You want a press-ready target list: top 200 domains, filtered for Spam Score, checked against the blocklist, and flagged with a tier (Tier 1: DA 70+, Tier 2: DA 50–69).
Fetch the top 200 global root domains from Moz with domain, DA, and Spam Score in columns A, B, C. Remove rows with Spam Score above 10. Check column A against the Exclusions tab column A and remove any matches. Then add a "Tier" label in column D: "Tier 1" for DA 70 and above, "Tier 2" for DA 50 to 69, and "Tier 3" for anything below.
Building the entire prospect list — filter, dedup, tier — in a single operation means you send the brief with a finished artifact, not a work-in-progress CSV.
Try It
Get the 7-day free trial of SheetXAI and open a blank Google Sheet, then ask it to pull the Moz global top domains directly into the sheet. The Moz integration is included in every SheetXAI plan. Also useful: bulk DA and Spam Score lookup for your own list and the full Moz integration overview.