The Scenario
You're a UX researcher at a digital agency. You've spent the last two weeks building a competitive analysis deck — 120 competitor product pages collected in column A of a Google Sheet, one URL per row. The deck goes to the client on Friday. The creative director asked for thumbnails of every page so the visual audit section isn't just a table of links.
It's Wednesday afternoon.
The bad version:
- Open each URL in a browser, wait for it to load, take a screenshot or use ScreenshotOne's dashboard manually for each one, download or copy the image URL, paste it into column B — for all 120 rows.
- Realize around row 40 that some URLs redirect and the screenshot captured the redirect destination, not the original page, so you need to go back through those rows.
- Spend Thursday morning on screenshot logistics instead of the actual analysis writeup that's due at noon.
You're being paid to analyze, not to operate a screenshot queue. Spending Thursday as a human API wrapper for a task a machine should handle in four minutes is not a good use of a Wednesday afternoon discovery.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Google Sheet. It reads the sheet, understands what you're looking at, and through its built-in ScreenshotOne integration it can fire screenshot requests for all 120 URLs and write the image CDN URLs back to column B — without you touching the API or leaving the sheet.
Take a screenshot of every URL in column A and put the resulting image URL in column B — use a 1440x900 viewport and return PNG format.
SheetXAI reads column A row by row, calls ScreenshotOne with the specified viewport, and writes each returned image URL into the corresponding cell in column B.
What You Get
- Column B fills with ScreenshotOne CDN URLs, one per row, aligned with their source URL in column A.
- Each URL is a direct link to the rendered PNG at 1440x900 — ready to embed in a deck or share with the creative team.
- Rows where the URL was unreachable or returned an error get a note instead of a URL so you know which pages need a manual check.
- The sheet stays in its original order — no re-sorting required.
What If the Data Is Not Quite Ready
Some URLs have trailing parameters that break the render
Some competitor URLs in column A include UTM parameters or session tokens that cause ScreenshotOne to render an error page instead of the product page.
For every URL in column A, strip any query string starting with "?" before passing it to ScreenshotOne, take the screenshot, and write the image URL into column B.
The viewport is wrong for mobile-first sites
Several of the competitor product pages are designed for mobile and look broken at 1440px.
Screenshot every URL in column A — use a 375x812 viewport for any URL that contains "m." or "mobile" in the domain, and 1440x900 for all others. Write the image URL into column B.
The URL list spans two tabs and needs to be consolidated
The competitor URLs are split across a 'Tier 1' sheet and a 'Tier 2' sheet, and the client wants all thumbnails in a single 'All Competitors' sheet.
Combine all URLs from the 'Tier 1' and 'Tier 2' sheets into a new sheet called 'All Competitors', then screenshot each URL using ScreenshotOne at 1440x900 and write the image URL into column B.
Full kill chain: clean, screenshot, and flag stale captures in one shot
Some URLs in column A are duplicates, some are blank, and the client also wants a "Captured At" timestamp in column C so they can tell which screenshots are from today.
Remove any duplicate or blank URLs from column A, screenshot each remaining URL via ScreenshotOne at 1440x900 PNG, write the image URL into column B, and write today's date into column C — all in one pass.
One prompt to clean the list, capture the screenshots, and stamp the output. The work happens in the right order without a second round of manual cleanup.
Try It
Get the 7-day free trial of SheetXAI and open your competitor audit sheet — paste your URL list into column A and ask SheetXAI to screenshot them all and write the image URLs into column B. Then check out how to batch screenshot landing pages or explore the full ScreenshotOne + Google Sheets overview.