The Scenario
You're a content curator at a media company. Your editor dropped 200 article URLs into a Google Sheet two days ago and asked for a content aggregation feed ready by end of week. The sheet has a URL in column A and four empty columns next to it labeled "Title," "Description," "Image URL," and "Status."
The bad version:
- Open each URL in a browser, inspect the OG tags in DevTools or via the OpenGraph.io scraper UI, copy the og:title, and paste it into column B.
- Repeat for og:description and og:image, switching tabs between the scraper and the sheet on every row.
- After twenty rows, lose your place, re-check which row you were on, and realize three of the image URLs you pasted are actually og:url values because the fields looked similar.
Two hundred rows of that is a week of work, not an afternoon. You're supposed to be curating content, not operating a glorified clipboard.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your Google Sheet. It reads the URL list in your sheet, connects to OpenGraph.io, and writes the returned metadata back into the right columns — all from a single prompt you type into the sidebar.
For each URL in column A, use OpenGraph.io to fetch the page title, OG description, and OG image URL and put them in columns B, C, and D — mark any failed URLs in column E
What You Get
- Column B fills with the og:title value for each URL (or the
<title>tag if no OG title is set). - Column C fills with the og:description.
- Column D fills with the og:image URL, ready to reference in your aggregation tool.
- Column E shows "ERROR" for any URL that returned a failed fetch or empty response so you know exactly which rows to re-check.
What If the Data Is Not Quite Ready
The URLs in column A include some with trailing spaces or malformed paths
For each URL in column A, trim any trailing whitespace and fix obvious protocol errors (e.g. "htp://" → "https://"), then use OpenGraph.io to fetch og:title, og:description, and og:image and write them into columns B, C, and D
Some rows are missing a URL entirely and I don't want blank rows to error out
Skip any row in column A that is empty, then use OpenGraph.io to fetch og:title, og:description, and og:image for the rest — write results into columns B, C, and D and leave blank rows blank
The sheet has multiple tabs and I need to pull metadata for URLs across the "Tech" and "Finance" tabs
For each URL in column A of the "Tech" tab and column A of the "Finance" tab, use OpenGraph.io to fetch og:title and og:description — write the results back into columns B and C of each respective tab
Clean up inconsistent URL formats, fetch the metadata, and flag any image URLs that are relative paths rather than absolute
For each URL in column A, normalize to https:// if missing a protocol, then use OpenGraph.io to fetch og:title, og:description, and og:image — write results into columns B, C, and D; in column E, flag any og:image value that does not start with "http" as "RELATIVE PATH"
The general move: ask for the data cleanup and the metadata fetch in one prompt rather than two passes.
Try It
Get the 7-day free trial of SheetXAI and open any Google Sheet with a column of article or page URLs — then ask it to populate the OG metadata for every row in one shot. You can also explore auditing URLs for missing OG tags or capturing screenshots for a URL list to see what else the integration covers.