The Scenario
You're an SEO manager at a B2B SaaS company. The site audit is Thursday. Your head of marketing asked for a breakdown of which blog posts are missing og:title or og:description before the presentation — and there are 150 URLs in a file someone emailed you, already imported into an Excel workbook with a worksheet labeled "Blog URLs."
The bad version:
- Paste the first URL into the OpenGraph.io scraper interface, check the returned fields, note whether og:title is present, copy the result, switch back to Excel, find the right row, type "MISSING" or "OK" in the right cell.
- Do this 150 times, being careful not to mix up rows when you tab back to the workbook.
- Build a summary count manually — open a separate worksheet, write a COUNTIF formula across the status column, and then realize you also need to check og:image, which means a second pass.
That's four hours of work on a task that doesn't require four hours of thinking — it just requires four hours of not losing focus.
The SEO analysis was the valuable part of your job this week. The audit prep wasn't supposed to be.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your Excel workbook. It reads the URL list, calls OpenGraph.io for each one, and applies your audit logic — flagging missing fields and summarizing results — without you touching a formula.
For each URL in column A of the "Blog URLs" worksheet, extract og:title and og:description with OpenGraph.io; write the values into columns B and C, and put "MISSING" in column D if either tag is absent
What You Get
- Column B fills with the og:title value for each URL.
- Column C fills with the og:description.
- Column D shows "MISSING" for any row where either tag is absent, and "OK" otherwise.
- Every row is filled in one pass — no manual tab-switching or status tracking required.
What If the Data Is Not Quite Ready
I also need og:image checked, not just title and description
For each URL in column A, use OpenGraph.io to extract og:title, og:description, and og:image — write each into columns B, C, and D; flag "MISSING" in column E if any of the three tags is absent
I want a summary count on a separate worksheet, not just row-level flags
Scan all URLs in column A of "Blog URLs" using OpenGraph.io and produce a summary table on the "Audit Results" worksheet showing: total URLs checked, count missing og:title, count missing og:description, count missing og:image
Some URLs in the workbook are redirects — I need to follow the redirect and check the final destination's tags
For each URL in column A, follow any redirects and use OpenGraph.io to fetch og:title and og:description from the final destination URL — write results into columns B and C and put the resolved URL in column D
I want to clean up any duplicate URLs first, then run the audit in one pass
Remove any duplicate values in column A, then use OpenGraph.io to fetch og:title, og:description, and og:image for each unique URL — write results into columns B, C, and D and flag "MISSING" in column E for any absent tag
The general move: describe your data cleanup and your audit logic together, and SheetXAI handles both in one operation.
Try It
Get the 7-day free trial of SheetXAI and open any Excel workbook with a list of blog or landing page URLs — ask it to run an OG tag audit across the whole column in one prompt. You might also want to bulk-fetch OG metadata once the audit tells you what's missing, or capture screenshots to support the visual side of your site review.