The Scenario
You're a technical SEO consultant. A client just launched 150 new product pages last Tuesday — migrated from a legacy CMS, rewritten URLs, submitted via a new sitemap. It's now Friday. Your weekly check-in call is Monday morning, and the client's first question will be: "Are our new pages indexed?"
You could check them one by one in Search Console's URL Inspection tool. That's 150 clicks, 150 page loads, 150 manual reads.
The bad version:
- Open URL Inspection in Search Console, paste URL 1, wait for the result, write the status into a spreadsheet by hand, move to URL 2.
- Realize after 20 URLs that you're also supposed to be capturing the last-crawl date and any coverage errors — go back to the first 20 and re-inspect them.
- Two hours later you're at URL 73 and your browser has timed out twice.
This is not what the client is paying your hourly rate for.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Google Sheet. It reads the URL list in your sheet, calls the Google Search Console URL Inspection API for each one through its built-in integration, and writes the results back — all at once.
Your 150 URLs are already in column A of your sheet. Paste this:
For each URL in column A of my Google Sheet, run a Google Search Console URL inspection and write back the indexing status, last crawl date, and any coverage issues into columns B, C, and D respectively
What You Get
- Column B: Indexing status — "URL is on Google" or the specific coverage issue type (e.g., "Crawled - currently not indexed," "Submitted and indexed").
- Column C: Last crawl date in ISO format (YYYY-MM-DD), or blank if never crawled.
- Column D: Coverage issue description if one exists, blank if clean.
- All 150 rows populated. No page-by-page clicking.
- If a URL redirects, the inspection result reflects the canonical destination.
What If the Data Is Not Quite Ready
Some URLs in your list have inconsistent formatting (http vs https, trailing slashes)
For each URL in column A, normalize to https and strip trailing slashes, then run a Search Console URL inspection for each and write indexing status, last crawl date, and coverage issue into columns B, C, and D — write the normalized URL into column E so I can see what was actually inspected
You want to filter results immediately to only the problem URLs
Inspect all URLs in column A using Google Search Console, write the full results into columns B through D, then in column E write "Action Needed" for any URL that is not indexed or has a coverage error, and move all "Action Needed" rows to a separate tab called "Issues"
You need to add mobile usability status alongside indexing status
For each URL in column A, run Search Console URL inspection and write into column B the indexing status, column C the last crawl date, column D any coverage issue, and column E any mobile usability issue — flag rows where both a coverage issue and a mobile issue exist as "Dual Issue" in column F
The full audit in one prompt — normalize, inspect, categorize, and summarize
Take each URL in column A, strip trailing slashes and enforce https, run Search Console URL inspection, write status, crawl date, and issues into columns B–D, categorize each row as "Indexed," "Crawl Error," "Not Submitted," or "Redirect" in column E, and write a summary count of each category at the bottom of the tab
One prompt handles the normalization, the inspection loop, the categorization, and the summary row.
Try It
Get the 7-day free trial of SheetXAI and paste your list of URLs into column A of any Google Sheet. Ask it to run Search Console inspections on all of them and write back the indexing results so you have a client-ready audit before Monday's call. See also page-level performance for clicks and impressions by URL, or the hub overview for the full list of Search Console workflows.