Back to Projects
Automated Testing for Clean Water Monitoring
Automation Tester
Comprehensive automated testing suite for the Clean Water Monitoring project. Covers API testing (6 modules), Admin UI testing, and E2E flows using Playwright. Includes custom scripts for test pipeline, result export, and Google Sheets integration.
Key Features
- 01API Testing - 6 modules: Auth, Devices, Issues, Locations, Logs, Users
- 02Admin UI Testing - Dashboard, Locations, Issues, User Management
- 03E2E Testing - Full user flows with Page Object Model
- 04Multi-environment support (dev, staging, production)
- 05Custom pipeline script with health check before tests
- 06Auto export results to CSV and JSON formats
- 07Google Sheets integration for test result reporting
- 08GitHub Actions CI/CD workflow
Highlights
- 6 API test suites + Admin UI + E2E tests
- Custom Node.js pipeline & export scripts
- Multi-environment configs (.env.production, .env.staging)
- Google Sheets auto-upload for test results
Technologies
PlaywrightTypeScriptNode.jsGitHub ActionsGoogle Sheets APIdotenv
Responsibilities
- •Design test architecture with Page Object Model pattern
- •Implement API tests for all 6 backend route modules
- •Create Admin UI test suites (Dashboard, Locations, Issues, Users)
- •Build custom pipeline.js for orchestrating test execution
- •Develop export-results.js for CSV/JSON report generation
- •Integrate Google Sheets API with upload-to-sheets.js
- •Configure Playwright for multi-browser & multi-environment
- •Setup GitHub Actions CI/CD workflow with secrets management


