n8n

How to Automate Google Sheets Visual QA Reports?

Detect visual changes on your website and log findings automatically. Teams use a shared Google Sheet to list pages, keep base screenshots in Google Drive, and get a clear change summary created in Linear. It suits product, QA, and marketing teams that need steady checks without manual work.

A schedule pulls URLs from Google Sheets. For each page, the workflow downloads the base image from Google Drive, generates a fresh screenshot with Apify, and compares both images using a Google Gemini vision model with a structured JSON result. Results are merged back with the row, non changes are filtered out, and all detected changes are aggregated into one report. The Linear node creates a new issue with a readable summary. Manual mode helps build or refresh base images by finding rows with missing files, capturing screenshots, uploading to Drive, and writing the Drive file ID back to the sheet. Wait nodes handle the screenshot job timing.

Plan for Google Sheets, Google Drive, Apify, Google Gemini, and Linear accounts. Expect big time savings by replacing daily manual checks with a scheduled run. Common uses include landing page monitoring, pricing page checks, campaign audits, and regulated content scans. Follow the steps below to connect accounts, map fields, set your Drive folder, and test both parts before turning on the schedule.

What are the key features?

  • Scheduled runs pull the latest URL list from Google Sheets
  • Manual trigger builds or refreshes base screenshots on demand
  • Apify screenshot jobs run via HTTP with wait steps to handle processing time
  • Google Drive stores base images and new captures with clean file naming
  • Google Gemini vision compares two images and returns structured JSON
  • Merge, filter, and aggregate nodes compile only the pages with changes
  • Linear issue creation posts a markdown summary for the team
  • Loop and batch controls handle large lists without timeouts

What are the benefits?

  • Reduce manual review from hours to minutes per run
  • Automate over 90 percent of visual checks across many pages
  • Catch subtle UI changes with AI vision for higher accuracy
  • Connect Google Sheets, Google Drive, Apify, Google Gemini and Linear in one flow
  • Scale to hundreds of pages with batching and scheduled runs
  • Create one clear Linear issue that summarizes all detected changes

How do you set it up?

  1. Import the template into n8n: Create a new workflow in n8n > Click the three dots menu > Select 'Import from File' > Choose the downloaded JSON file.
  2. You'll need accounts with Google Sheets, Google Drive, Linear, Google Gemini and Apify. See the Tools Required section above for links to create accounts with these services.
  3. In the n8n credentials manager, double click the Google Sheets nodes and choose Create new credential. Use the Google Sheets OAuth2 option and follow the on screen steps. Name it clearly, for example Sheets Visual QA.
  4. Open the Google Drive nodes and create a new Google Drive OAuth2 credential. Grant access to the Drive that will store screenshots. Note the folder ID you plan to use.
  5. For Apify, open an Apify tab, create an API token in your account settings, then in the HTTP Request nodes create a new credential using the API key. Paste the token and save.
  6. For Google Gemini, create an API key in Google AI Studio. In the Google Gemini Chat Model node, create a new credential and paste the key. Select the model listed in the node settings.
  7. For Linear, create a personal API key with read and write access to issues. In the Linear node, create a new credential, paste the key, and test the connection.
  8. In the Upload to Drive node, set the target folder ID to your screenshots folder. Keep simplify output on so the file ID can be written back to the sheet.
  9. In the Google Sheets update node, map url to the page URL column and base to the Google Drive file ID column. Confirm the sheet has these columns and correct headers.
  10. Set the Schedule Trigger to your desired time window. Start daily at a quiet hour so screenshots complete without rate limits.
  11. Validation part A: Run the manual trigger to generate base images for rows missing a base. Confirm images appear in Drive and that the sheet shows the file IDs.
  12. Validation part B: Test the scheduled path by clicking Execute Workflow. Confirm the Apify job completes, a Linear issue is created, and only changed pages appear in the summary.
  13. Troubleshooting: If screenshots are missing, check the Drive folder ID and Apify API token. If comparisons fail, verify the Gemini key and model. If no issue appears in Linear, confirm the token scopes and project mapping.

Tools Required

$24 / mo or $20 / mo billed annually to use n8n in the cloud. However, the local or self-hosted n8n Community Edition is free.

Apify

Sign up

Free plan: $0 / mo with $5 monthly platform credits; API access via token

Google Drive

Sign up

Drive API: $0 (no additional cost; quota-limited)

Google Gemini

Sign up

Free tier: $0 via Gemini API; e.g., Gemini 2.5 Flash-Lite free limits 1,000 requests/day (15 RPM, 250k TPM). Paid from $0.10/1M input tokens and $0.40/1M output tokens.

Google Sheets

Sign up

Free: $0 (Google Sheets API usage has no additional cost; quota limits apply)

Linear

Sign up

Free: $0 / mo, includes API access (2 teams, 250 issues)

Similar Templates

Join Futurise to access 1,200+ automation templates

Get instant access to ready-made automation workflows for n8n, Make.com, AI agents, and more. Download, customise, and deploy in minutes.