TH
Back to projects

Automation Tester

Automated Testing for Clean Water Monitoring

API, admin UI, and end-to-end testing for Clean Water Monitoring with Playwright. A custom Node.js pipeline checks server health before tests, exports CSV and JSON results, and uploads reports to Google Sheets. Tests use Page Object Model and environment-specific configuration.

Contribution
Automation Tester
Built with
Playwright, TypeScript, Node.js, GitHub Actions, Google Sheets API
View test documents
Image 1 / 3View full size

Archived GitHub Actions workflow captured while Playwright was running; reporting steps were still pending.

Inside the project

How does a test become a reviewable record?

The Clean Water Monitoring test project connects API, admin UI, and end-to-end checks with execution scripts and report exports. Follow the path from a server check to a shared report.

Look inside this system

  1. Check readiness

    A Node.js pipeline checks server health before test execution.

  2. Exercise behavior

    Playwright checks API, admin UI, and end-to-end flows.

  3. Export results

    Scripts export execution results as CSV and JSON.

  4. Share the report

    The pipeline uploads reports to Google Sheets.

Archived Clean Water Test Results spreadsheet showing case IDs, roles, functions, test steps, and expected results.
Archived report view showing test cases, steps, and expected results.
Explore the system under test
Explore the Clean Water system under test

My contribution

  1. Design test architecture with Page Object Model pattern
  2. Implement API tests for all 6 backend route modules
  3. Create Admin UI test suites (Dashboard, Locations, Issues, Users)
  4. Build custom pipeline.js for orchestrating test execution
  5. Develop export-results.js for CSV/JSON report generation
  6. Integrate Google Sheets API with upload-to-sheets.js
  7. Configure Playwright for multi-browser & multi-environment
  8. Setup GitHub Actions CI/CD workflow with secrets management

Design & engineering decisions

  1. 6 API test suites + Admin UI + E2E tests
  2. Custom Node.js pipeline & export scripts
  3. Multi-environment configs (.env.production, .env.staging)
  4. Google Sheets auto-upload for test results

What it does

  1. API Testing - 6 modules: Auth, Devices, Issues, Locations, Logs, Users
  2. Admin UI Testing - Dashboard, Locations, Issues, User Management
  3. E2E Testing - Full user flows with Page Object Model
  4. Multi-environment support (dev, staging, production)
  5. Custom pipeline script with health check before tests
  6. Auto export results to CSV and JSON formats
  7. Google Sheets integration for test result reporting
  8. GitHub Actions CI/CD workflow

Technologies

  • Playwright
  • TypeScript
  • Node.js
  • GitHub Actions
  • Google Sheets API
  • dotenv

Available for conversations about web and testing work

Something in mind?

For web development, software testing, and opportunities to work together.

[email protected]
Contact detailsGitHub