The Scenario
Your link-building campaign brief landed in your inbox Monday morning. 150 outreach targets in column A of the sheet — domains pulled from a prospecting tool, a manual research session, and a list a freelancer sent over last week. Before you can prioritize outreach, you need Domain Authority and Spam Score for each one so you can filter out the low-DA noise and flag anything with a Spam Score above 30.
The bad version:
- Open Moz Link Explorer, paste the first domain, write down the DA and Spam Score, switch back to the sheet.
- Repeat for domain two. Then three. After the first twenty, you start abbreviating your tabs. After forty, you have a typo in the domain column that shifts every metric you have recorded since row 28 down by one.
- By domain sixty, you are no longer certain which browser tab has the last Moz search in it.
This is not analysis. This is transcription labor. And this campaign brief is supposed to be done before Wednesday's strategy call.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Google Sheet. It reads the domain list, talks to Moz, and writes the metrics back to the sheet — all from a single prompt in the sidebar.
For each domain in column A, fetch the Moz Domain Authority and Spam Score and write them to columns B and C.
What You Get
- Column B fills with the Moz Domain Authority score (0–100) for each domain in column A.
- Column C fills with the Moz Spam Score (0–100) for each domain.
- Domains with no Moz data receive a clear note in the corresponding cell rather than a blank — so you know the lookup ran and just found nothing.
- The original domain values in column A are unchanged.
What If the Data Is Not Quite Ready
The domain list has inconsistent formatting
Some rows have "https://" prepended, some have "www.", some are bare root domains. Moz is picky about input format.
Normalize every value in column A to a bare root domain (no protocol, no trailing slash, no www), then fetch Moz Domain Authority and Spam Score for each and write results to columns B and C.
You also need linking domain counts
The brief asked for linking domains as a third data point, and you forgot to include it the first time.
For each domain in column A, look up Moz metrics and add Domain Authority to column B, Spam Score to column C, and linking domain count to column D.
Some rows are already filled and should not be overwritten
You ran a partial batch two days ago. Rows 2 through 47 already have values. You only want to fill the blanks.
For each domain in column A where column B is empty, fetch the Moz Domain Authority and Spam Score and write them to columns B and C — skip any rows that already have a value in column B.
Deduplicate, clean, enrich, and flag in one pass
The raw prospecting list has duplicates, some domains have trailing spaces, and anything with a Spam Score above 30 should be flagged in column D.
Remove duplicate domains in column A, trim any whitespace from each value, fetch Moz Domain Authority and Spam Score for each unique domain and write them to columns B and C, then mark column D with "Flag" for any row where the Spam Score in column C is above 30.
The logic: clean the data and apply the business rule in the same prompt, rather than running cleanup first and enrichment second.
Try It
Get the 7-day free trial of SheetXAI and open the Google Sheet with your outreach domain list, then ask it to pull DA and Spam Score for the full column. The Moz integration is included in every SheetXAI plan. Also useful: bulk verification of backlinks and the full Moz integration overview.