The Scenario
The in-house SEO manager got a request from the head of growth on a Tuesday afternoon: "Can we flag the landing pages that are underperforming on authority before the site audit next week?" There are 200 landing page URLs in the sheet — organized by funnel stage, campaign, and business unit — and none of them have Page Authority or Spam Score attached. The head of growth wants a view where the SEO team can immediately see which pages need link-building attention versus which are already well-supported.
The bad version:
- Open Moz. Paste the first URL into Link Explorer. Note the Page Authority. Note the Spam Score. Switch to the sheet. Find row 2. Paste both numbers into columns B and C.
- Repeat for row 3. Then row 4. On URL 23 you accidentally paste the values into the wrong row because a Slack message came in and you clicked to dismiss it mid-paste. Now everything from row 23 onward is off by one and you have to re-verify.
- The site audit is Wednesday. It is now Tuesday at 3:45 PM and you have processed 40 of the 200 URLs.
The hours required for this do not exist. Neither does the tolerance for redoing it when a row shifts.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Google Sheet. It reads the URL list in column A, queries Moz for each URL's Page Authority and Spam Score, and writes the results to the columns you specify — no lookups by hand, no cross-tab pasting.
For each URL in column A, fetch the Moz Page Authority and Spam Score and write them to columns B and C.
What You Get
- Column B fills with the Moz Page Authority score (0–100) for each URL in column A.
- Column C fills with the Moz Spam Score (0–100) for each URL.
- URLs that Moz has not indexed receive a clear note in the cell rather than a blank — you can distinguish "not indexed" from "data not fetched."
- Column A URLs are unchanged.
What If the Data Is Not Quite Ready
You also need Domain Authority for the root domain of each URL
The audit report includes a domain-level DA column alongside the page-level PA.
For each URL in column A, fetch Moz Page Authority and Spam Score and write them to columns B and C, then also fetch the Domain Authority for the root domain of each URL and write it to column D.
Some rows are filled already — partial batch from yesterday
A junior analyst ran the first 60 rows yesterday before running out of Moz API credits. Columns B and C already have values in rows 2 through 61.
For each URL in column A where column B is empty, fetch the Moz Page Authority and Spam Score and write them to columns B and C — leave rows that already have values in column B unchanged.
You want to flag pages below a Page Authority threshold for prioritized link-building
The SEO lead wants column D to show "Priority" for anything under PA 20 and "OK" for anything at or above.
For each URL in column A, fetch Moz Page Authority and Spam Score and write them to columns B and C. Then add a label in column D: "Priority" if the Page Authority in column B is below 20, "OK" if it is 20 or above.
Full audit prep in one shot — enrich, flag by PA threshold, and sort the results
For each URL in column A, fetch Moz Page Authority and Spam Score and write them to columns B and C. Mark column D with "Priority" if PA is below 20 and "OK" if PA is 20 or above. Then sort all rows by column B ascending so the lowest Page Authority URLs are at the top.
Enriched, labeled, and sorted — the audit view is ready without a second pass.
Try It
Get the 7-day free trial of SheetXAI and open your landing page sheet, then ask it to pull Moz Page Authority and Spam Score for each URL in the list. The Moz integration is included in every SheetXAI plan. Also useful: bulk Domain Authority lookup for root domains and the full Moz integration overview.