See llms.txt for all machine-readable content.

Back to Templates

Capture website screenshots from Google Sheets to Google Drive with SnapRender

Quick overview

Paste URLs into a Google Sheet and get, for each page, a full-page desktop and an iPhone screenshot from SnapRender in a dated Drive folder per client, plus a Claude verdict (OK, Needs review or Broken) with severity, reason and issues. One email lists what needs attention.

How it works

  1. New rows start a run within a minute (Google Sheets trigger), or click "Run QA now".
  2. The workflow picks new rows, rows you set to Retry, and failed rows under the attempt limit, and marks them "In progress" so overlapping runs never capture the same page twice. Bare domains like example.com get https added.
  3. For each page it finds or creates a Drive folder such as "Acme - 2026-11-13".
  4. SnapRender returns, with cookie banners and ads removed: a full-page desktop capture with lazy-loaded images, an iPhone 15 Pro capture, and the page text as markdown.
  5. Both captures go to Drive. The mobile capture can be shared by link so the sheet can show it with =IMAGE().
  6. Claude gets the top of the desktop page, the mobile screen and the page text, and answers in a fixed JSON format. It checks for error and blank pages, login, paywall or cookie walls, broken layout and horizontal overflow, overlapping elements, missing images and typos, plus your own house rules.
  7. The row gets status, severity, summary, issues, Drive links, thumbnail and time.
  8. Failed captures write SnapRender's error message to the row. Rate limits (HTTP 429) wait 60 seconds and retry up to twice, timeouts and server errors retry once, and later runs retry up to max_attempts.
  9. After the last page, Gmail sends a report with counts by status and links to every page that needs attention.

Setup

  1. Install the verified SnapRender community node (nodes panel, search "SnapRender") and add your API key. The free plan has 200 captures a month: https://app.snap-render.com/auth/signup?ref=n8n-template
  2. Create a Google Sheet with a Pages tab and these headers: client, url, notes, status, severity, ai_summary, issues, thumbnail, desktop_link, mobile_link, checked_at, attempts, error.
  3. Fill in the Settings node: sheet URL, Drive folder ID, report email, and optional house rules.
  4. Connect Google Sheets, Google Drive, Gmail and Anthropic credentials, and pick the same sheet and tab in "New row in QA sheet".
  5. Add a few URLs and click "Run QA now".

Requirements

  • SnapRender account (free plan works) and the verified SnapRender node. Each URL uses 3 captures; failed renders are not charged.
  • Google Sheets, Google Drive and Gmail
  • Anthropic API key (or OpenAI, see Customization)

Customization

  • Use OpenAI instead of Claude by swapping the "Claude model" sub-node for an OpenAI Chat Model. Reasoning models such as gpt-5 need max tokens around 8000.
  • Write your client's rules into qa_rules: brand spelling, required sections, legal lines.
  • Set public_thumbnails to false to keep every file private (the sheet then shows links only).
  • Change max_pages_per_run and max_attempts to control credit use.

Additional info

Who it's for: agencies, SEO and QA teams who check client sites after a release, a migration or a campaign launch, and want a person to look only at the pages that need it.

Video walkthrough: https://youtu.be/Bju7xRgiJDQ