Back to Screenshot.fyi in Google Sheets
SheetXAI logo
Screenshot.fyi logo
Screenshot.fyi · Google Sheets Guide

Capture Before-and-After Screenshots for Visual Regression Review in a Google Sheet

2026-05-14
5 min read

The Scenario

You shipped a redesign three days ago and your inbox this morning contains a message from the project lead: "Can we get a before-and-after doc together for the stakeholder review?"

You are a web developer at a media company. The sheet is already set up — column A has the page URLs (all forty of them, every major template and key editorial page), column B has the old screenshot URLs from Screenshot.fyi that you captured before the redesign went live. Column C is empty. That's where the new screenshots go.

The tedious version played out in your head before you even opened the sheet.

The bad version:

  • Open Screenshot.fyi. Paste URL from A2. Wait for the capture. Copy the new link. Switch to the sheet. Click C2. Paste. Move to A3. Repeat thirty-nine times.
  • Hit URL seventeen and realize you're not sure whether you got A17 or A18 last because you switched windows to answer a Slack message mid-task.
  • Finish the captures, then spend twenty minutes scanning column C for gaps because you can't be certain you didn't miss a row during the context-switch.

The stakeholder review is tomorrow. You have a build to ship.

The Easy Way: One Prompt in SheetXAI

SheetXAI is an AI agent that lives inside your Google Sheet. It reads all three columns, understands that column B contains historical data to preserve, and uses Screenshot.fyi to populate column C with fresh captures — one call per row, no babysitting.

Open the SheetXAI sidebar and paste this prompt:

For each URL in column A, use Screenshot.fyi to capture a new screenshot and write the image URL into column C — column B already contains the old screenshot URL for comparison

What You Get

  • Column C fills with fresh Screenshot.fyi image URLs, one per row, aligned to the matching URL in column A.
  • Column B is untouched — the old screenshots stay exactly where they were.
  • If a page returned an error or a redirect at capture time, that row's column C gets a note instead of a broken link so you know before the deck goes to stakeholders.
  • Forty rows, single prompt.

What If the Data Is Not Quite Ready

Some pages weren't in the original capture set and don't have a column B value

For each URL in column A, take a new Screenshot.fyi screenshot and write the image URL into column C — if column B is empty for that row, also write "NO PRIOR" into column B to flag it clearly

The URL list includes staging URLs that got in by mistake and should be skipped

Screenshot each URL in column A using Screenshot.fyi, but skip any row where the URL contains "staging" or "dev." — write new screenshot URLs into column C and leave those rows blank with a "SKIPPED — staging" note

Pages need to be grouped by template type before the comparison doc is assembled

Screenshot all URLs in column A using Screenshot.fyi and write each new image URL into column C — then group the rows by the template name in column D, keeping the sort order within each group intact

Full regression pipeline: normalize, capture, flag regressions, prep for review

Normalize all URLs in column A (remove trailing slashes, ensure https://) — then screenshot each using Screenshot.fyi and write the new image URL into column C — flag rows where column B is empty into column D as "MISSING BASELINE" and sort those rows to the top so reviewers see gaps first

The pattern: fold the quality checks into the same prompt so the sheet is review-ready when SheetXAI is done.

Try It

Get the 7-day free trial of SheetXAI and open the Google Sheet where you're tracking your next redesign or migration. Bring your old screenshot URLs in column B, your live page URLs in column A, and ask SheetXAI to capture the new state and write it into column C — then see the hub overview for all the ways SheetXAI connects to Screenshot.fyi.

Stop memorizing formulas.
Tell your spreadsheet what to do.

Join 4,000+ professionals saving hours every week with SheetXAI.

Learn more