If you're like me, you appreciate the insights provided by Cypress Cloud but want to avoid the cost, especially for smaller projects or teams. This post walks you through how I created a cost-effective alternative using Cypress, Google Sheets, and Looker Studio. By the end of this article, you'll know how to collect and visualize automated test data efficiently.
When running automated tests, identifying flaky tests or consistently failing tests is crucial for maintaining test suite reliability. While Cypress Cloud offers a robust solution for this, it can be expensive. I wanted a free and straightforward way to track test runs, visualize failures, and find trends over time.
My Approach
I combined Cypress hooks, Google Apps Script, and Google Looker Studio to create a functional and flexible dashboard. Here's how it works:
- Cypress collects data during test runs.
- Google Sheets API acts as a lightweight database for storing test data.
- Google Looker Studio visualizes this data for quick insights.
Step 1: Capturing Test Run Data in Cypress
I used the is using:
Conclusion
Building this dashboard was a rewarding experience, enabling me to understand test results better and save money. If you're running Cypress tests on a budget, give this setup a try! You’ll be surprised at how much insight you can gain without premium tools.
Have you built something similar, or do you have tips to improve this setup? Let me know in the comments!
SOCIAL SHARE CARD GENERATOR