The Scenario
You're a technical SEO consultant and you inherited a client's pre-migration checklist last week. Column A has 150 page URLs. The client's dev team says they've updated every page's canonical tags, meta descriptions, and H1s — and they need documented confirmation before the migration window opens Thursday morning.
The obvious approach, before you think better of it:
- Open each URL in a browser, right-click and view source, use Command+F to search for "canonical," then "meta name=description," then the first H1 — copy the TRUE/FALSE manually for each field into three separate columns in your sheet
- Try a Chrome extension that parses on-page elements — it audits one tab at a time, doesn't integrate with your spreadsheet, and requires you to click through 150 browser tabs
- Write a Python script to fetch and parse each URL — except the client's staging environment requires JavaScript rendering, which means the standard requests library returns empty bodies on half the URLs
It's Wednesday. The migration window is at 6 AM Thursday. One hundred fifty URLs, three fields each, and your afternoon is already double-booked with client calls.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent built into your Google Sheet. It reads your sheet data and uses Agenty — which supports JavaScript rendering and proxy-backed fetching — to pull rendered HTML for each URL and check whatever elements you specify. Results land back in your sheet.
Fetch the full rendered HTML of each URL in column A and check for the presence of a canonical tag, meta description, and H1 — write TRUE or FALSE into columns B, C, and D for each
What You Get
- Column B: TRUE if a canonical tag is present, FALSE if not
- Column C: TRUE if a meta description is present, FALSE if not
- Column D: TRUE if at least one H1 is present, FALSE if not
- Any URL that returns a non-200 HTTP status gets flagged in column E so you know which pages didn't respond before you sign off the audit
What If the Data Is Not Quite Ready
You need the actual tag content, not just a presence check
For each URL in column A, fetch the rendered HTML using Agenty and extract the canonical href, meta description content text, and first H1 text — write them into columns B, C, and D respectively
Some URLs are JavaScript-heavy and the standard fetch misses elements
For all URLs in column A, use Agenty with JavaScript execution enabled to fetch the fully rendered DOM — then check for canonical, meta description, and H1 and write TRUE/FALSE into B, C, D
You want a priority sort for the most critical failures
Check all URLs in column A for canonical tag, meta description, and H1 — write TRUE/FALSE into B, C, D — then sort the sheet so all rows with any FALSE value appear at the top, sorted by URL
Run the full pre-migration audit in one shot
For each URL in column A, use Agenty to fetch the rendered page, check canonical tag, meta description, H1, and page title — write results into B, C, D, E — flag rows missing two or more fields as "HIGH RISK" in column F and generate a pass/fail summary in cell G1
One prompt covers the fetch, the checks, the risk ranking, and the summary your client will paste into their sign-off email.
Try It
Get the 7-day free trial of SheetXAI and open any Google Sheet with URLs you need to audit — then ask SheetXAI to check each page's on-page elements using Agenty. See also how to trace redirect chains or review the full Agenty integration overview.