The Scenario
Your content ops team published 60 articles over the last two months. The SEO lead has been asking for a full archive — rendered HTML and a screenshot of each page, frozen at publication state — for an ongoing content audit project. The URLs are already in column A of an Excel workbook called "Published Articles."
This one landed in your queue because you're the most technical person on the team. You're not a developer. You know how to use Excel. You do not know how to write an API wrapper.
The bad version:
- Pull up the Cloudflare Browser Rendering docs, find the "snapshot" endpoint that returns both HTML and screenshot, test it with one URL in Postman
- Figure out that the response comes back as a JSON object with two separate fields — write a quick script, realize you don't know where to run it
- Ask the backend engineer for help, wait two days, get a script that works for three URLs and then throws an error on URL four because of a character encoding issue in one article's title
Sixty URLs. Two data points per URL. A script that's already broken once. The SEO lead is asking for a status update every other day.
You're the one holding this because there's no one else, and that's a perfectly reasonable way to end up here.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Excel workbook. It reads the data in your worksheets and talks to Cloudflare Browser Rendering directly — calling the webpage snapshot tool for each URL, pulling both the rendered HTML and the screenshot, and writing the results back to the workbook in the columns you specify.
Here is the prompt you'd use:
For every URL in column A of the "Published Articles" worksheet, use Cloudflare Browser Rendering's webpage snapshot tool to fetch both the rendered HTML and a screenshot, and write the HTML into column B and the image data or image URL into column C.
What You Get
- Column B with the full rendered HTML body for each article — exactly what a browser sees after JavaScript executes
- Column C with the screenshot image URL (or base64 data, depending on the endpoint response format) for each page
- Any URL that fails to snapshot gets an error note in column B so you can spot gaps without scanning 60 rows manually
- The entire archive captured in one operation, not sixty separate API calls you had to run by hand
What If the Data Is Not Quite Ready
Several URLs in column A have been redirected since publication and need to follow the final destination
For each URL in column A of "Published Articles", follow any redirects before calling Cloudflare Browser Rendering's snapshot tool, then write the resolved URL to column D, the rendered HTML to column B, and the image URL to column C.
The workbook has articles in three language worksheets — "EN", "FR", "DE" — and all need archiving
For each worksheet ("EN", "FR", "DE"), process every URL in column A using Cloudflare Browser Rendering's snapshot tool. Write the rendered HTML to column B and the screenshot image URL to column C on the same row and worksheet where the URL lives.
Some articles were unpublished — you want to flag those instead of archiving a 404 page
For each URL in column A of "Published Articles", call Cloudflare Browser Rendering's snapshot tool. If the response indicates a 404 or the rendered HTML contains the text "Page not found", write "UNPUBLISHED" in column B. Otherwise write the rendered HTML to column B and the image URL to column C.
The archive project requires both the snapshot and the page's HTTP response code and load time logged together
For every URL in column A of "Published Articles", use Cloudflare Browser Rendering to capture both the rendered HTML and a screenshot. Also log the HTTP status code in column D and the page load time in column E. Write the HTML to column B and the image URL to column C.
The point: one prompt covers the capture, the cleanup, and the conditional routing — you don't have to pre-filter the workbook before running it.
Try It
Get the 7-day free trial of SheetXAI and open any Excel workbook where you're tracking published URLs that need a frozen HTML and screenshot record, then ask it to run a bulk snapshot using Cloudflare Browser Rendering. For competitive research scraping, see Bulk Scrape Competitor Landing Pages Into an Excel workbook, or return to the Cloudflare Browser Rendering overview.