Google Drive Automate

Google Drive Automate streamlines visual regression testing by automatically capturing and comparing webpage screenshots. It generates base images, runs scheduled tests, and reports any changes detected, ensuring website integrity over time. This workflow efficiently integrates with Google Sheets for tracking, uses Apify for screenshot generation, and leverages AI for analysis, saving time and reducing manual effort.

7/8/2025
34 nodes
Complex
schedulecomplexgoogle drivelangchainsticky notesplitinbatcheswaitgooglesheetsschedule triggerfilteraggregatelinearautomationadvancedapiintegrationcron
Categories:
Communication & MessagingSchedule TriggeredComplex WorkflowData Processing & Analysis
Integrations:
Google DriveLangChainSticky NoteSplitInBatchesWaitGoogleSheetsSchedule TriggerFilterAggregateLinear

Target Audience

Web Developers: Those looking to ensure the integrity of their websites by detecting visual changes.
QA Engineers: Professionals responsible for maintaining quality standards in web applications.
Product Managers: Individuals who oversee website content and layout, ensuring that all changes align with business goals.
Marketing Teams: Teams that need to track changes in promotional content on landing pages.
Agile Teams: Teams that require quick feedback loops on visual changes during development cycles.

Problem Solved

This workflow automates Visual Regression Testing, allowing users to quickly identify unexpected changes in webpage designs. By comparing base images with newly generated screenshots, it helps maintain the consistency and quality of web applications, preventing potential issues before they affect users.

Workflow Steps

  • Schedule Trigger: The workflow is triggered on a weekly basis at 6 AM to check for updated webpages.
    2. Get Webpages List: It retrieves a list of webpages from Google Sheets.
    3. For Each Webpage: The workflow loops through each webpage to execute the following steps:
    - Run Webpage Screenshot: Generates a new screenshot using Apify.
    - Download Screenshot: Downloads the generated screenshot.
    - Upload to Drive: Uploads the screenshot to Google Drive for storage.
    - Base Image: Downloads the base image for comparison.
    4. Combine Screenshots: Merges the new screenshot and the base image.
    5. Visual Regression Agent: Uses an AI model to identify changes between the two images.
    6. Has Changes: Checks if there are any detected changes.
    7. Create Report: If changes are found, a report is generated and sent to Linear for tracking.

    • Customization Guide

  • Modify Schedule: Adjust the schedule trigger parameters to change the frequency of tests (e.g., daily, bi-weekly).
    2. Update Google Sheets: Change the Google Sheets document ID and sheet name to link to your specific list of webpages.
    3. Customize Screenshot Options: Modify the parameters used in the Apify API request to adjust screenshot settings (e.g., viewport size, format).
    4. Change Reporting Tool: If you prefer a different project management tool, replace the Linear integration with your desired platform (e.g., JIRA or Slack).
    5. Add Additional Nodes: Feel free to integrate more nodes to expand functionality, such as adding notifications or logging.

    • Google Drive Automate - N8N Workflow Directory