Google Drive Automate

Google Drive Automate streamlines visual regression testing by automatically generating base screenshots and comparing them against updated webpage images. This workflow integrates with Google Sheets to manage webpage lists, utilizes Apify for screenshot generation, and employs AI vision models to detect changes. Scheduled runs ensure regular updates, while reports are generated in Linear for easy tracking of detected changes, enhancing website quality assurance and reducing manual oversight.

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

Target Audience

Target Audience


- Web Developers: Those who maintain websites and need to ensure visual consistency over time.
- Quality Assurance Teams: Professionals responsible for testing and validating web applications.
- Product Managers: Individuals who oversee product releases and require visual validation of changes.
- Marketing Teams: Teams that need to ensure brand consistency across web pages.
- Freelancers & Agencies: Service providers who offer website maintenance and testing services.

Problem Solved

Problem Solved


This workflow addresses the challenge of visual regression testing, which is crucial for detecting unintended changes in the appearance of web pages. By automating the process of capturing screenshots and comparing them with previously stored base images, it helps identify discrepancies that could affect user experience, functionality, and brand integrity. This ensures that any visual changes are intentional and not the result of bugs or errors.

Workflow Steps

Workflow Steps


1. Schedule Trigger: The workflow is initiated on a weekly basis at 6 AM every Monday.
2. Get Webpages List: It retrieves a list of URLs from a Google Sheet that need to be tested.
3. For Each Webpage: Each URL is processed in batches:
- Run Webpage Screenshot: Captures the current screenshot of the webpage using Apify.
- Base Image: Downloads the corresponding base image from Google Drive for comparison.
4. Combine Screenshots: Merges the base and new screenshots for analysis.
5. Visual Regression Agent: Uses AI to identify changes between the two images, focusing on text, colors, images, and layout differences.
6. Has Changes: Filters results to check if any changes were detected.
7. Create Report: If changes are found, a report is generated and documented in Linear for tracking.
8. Update Base Image: If necessary, updates the base image in Google Sheets to reflect the latest version of the webpage.

Customization Guide

Customization Guide


- Adjust Schedule: Modify the schedule trigger settings to change the frequency of the workflow execution according to your needs.
- Update Google Sheets: Change the Google Sheet document and sheet name to point to your own list of webpages.
- Change Screenshot Service: If you prefer a different service for capturing screenshots, update the API calls in the Run Webpage Screenshot nodes.
- Modify Reporting: Customize the report format in the Create Report node to match your team's requirements or to integrate with other tools.
- Add More Nodes: Extend the workflow by adding additional processing steps or integrations as required for your specific use case.
Google Drive Automate - N8N Workflow Directory