The Scenario
Six weeks ago you sent outreach emails to 80 link prospects. Thirty said yes. You sent the content, they published, and you marked them done in the tracker. Now the client wants a link verification report before the monthly call Friday afternoon. Which of those 30 placements are actually live?
The bad version:
- Open the tracker. Take the first source URL from column A. Open Moz Link Explorer. Search for the link pointing from that URL to your client's domain.
- Read the result. Mark the cell. Move to the next row. Twenty minutes in, you realize you have been checking referring domains instead of specific page-level links, so the first eight entries are probably wrong.
- Go back and redo rows 2 through 9. By row 25, the Moz session has timed out and you need to log back in.
The client call is at 4 PM. It is currently 1:30 PM.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Google Sheet. It reads your source URLs, queries Moz link status for each one against a target domain, and writes the verification result back to the row — all in one pass.
For each URL in column A, use Moz to check whether it currently links to mysite.com and write TRUE or FALSE to column B.
What You Get
- Column B fills with TRUE for each source URL that Moz confirms is actively linking to the target domain.
- Column B fills with FALSE for URLs where no live link is found.
- Any URL that returns an error or an ambiguous result is noted in column B rather than silently treated as FALSE.
- Column A source URLs are unchanged.
What If the Data Is Not Quite Ready
The target domain is dynamic — it is stored in a cell, not hardcoded
Different rows might need to verify links to different target URLs, or the target lives in a cell reference.
Use Moz link status to verify if each source URL in column A links to the target URL in cell C1, and write the result to column B.
You need to distinguish between nofollow and dofollow links
The client cares about link equity. A nofollow placement counts differently than a dofollow.
For each source URL in column A, use Moz to check whether it links to mysite.com, and write to column B: "Dofollow", "Nofollow", or "No link found."
Some entries in column A are not URLs — they are domain roots
The tracker has a mix of full page URLs and bare domains. Moz checks work differently for each.
For each value in column A, if it looks like a full page URL check it directly with Moz for a link to mysite.com; if it looks like a root domain, check at the domain level. Write TRUE, FALSE, or "Domain-level match" to column B.
Full reconciliation — verify, flag broken placements, and draft a status summary
You want to send the client a clean report, not a raw spreadsheet. Verify all 30 rows, flag any FALSE results, and write a one-line summary at the top.
For each URL in column A, use Moz to verify whether it links to mysite.com and write the result to column B. Then mark column C with "Action needed" for any FALSE result in column B. Finally, write a summary line in cell E1 stating how many links verified as live out of the total checked.
The verification, the flagging, and the summary happen in one pass — you hand the finished report to the client without a second round of manual work.
Try It
Get the 7-day free trial of SheetXAI and open your outreach tracker, then ask it to verify which source URLs are actively linking to your target domain using Moz. The Moz integration is included in every SheetXAI plan. Also useful: bulk DA and Spam Score lookup and the full Moz integration overview.