Agent-Skills.md

Agent Skills: UAT Reporter

Writes UAT test results (Pass/Fail/Blocked/Skip with color formatting) to the Google Sheet 'All Test Cases' tab. Use when: (1) Recording test results after UAT execution, (2) Writing a single test result for debugging, (3) Verifying previously written results match expected values, (4) Previewing what would be written with dry-run mode. Supports batch writes per module, single-test writes, row lookup by test ID, color-coded status cells, verification readback, and dual logging.

UncategorizedID: arlenagreer/claude_configuration_docs/uat-reporter
4

Install this agent skill to your local

pnpm dlx add-skill https://github.com/arlenagreer/claude_configuration_docs/tree/HEAD/skills/uat-reporter

Skill Files

Browse the full folder contents for uat-reporter.

Download Skill

Loading file tree…

skills/uat-reporter/SKILL.md

Skill Metadata

Name
uat-reporter
Description
"Writes UAT test results (Pass/Fail/Blocked/Skip with color formatting) to the Google Sheet 'All Test Cases' tab. Use when: (1) Recording test results after UAT execution, (2) Writing a single test result for debugging, (3) Verifying previously written results match expected values, (4) Previewing what would be written with dry-run mode. Supports batch writes per module, single-test writes, row lookup by test ID, color-coded status cells, verification readback, and dual logging."

UAT Reporter

Write UAT test results to the Google Sheet "All Test Cases" tab with color-coded status cells, row lookup by test ID, and verification readback.

Uses shared OAuth token from google-sheets skill (~/.claude/.google/token.json).

Commands

report-batch (primary)

Write all results from a module JSON file:

~/.claude/skills/uat-reporter/scripts/uat_reporter.rb report-batch --file .uat/results/dashboard.json

Or via stdin:

cat .uat/results/dashboard.json | ~/.claude/skills/uat-reporter/scripts/uat_reporter.rb report-batch

report-single

Write one test result:

~/.claude/skills/uat-reporter/scripts/uat_reporter.rb report-single \
  --test-id DASH-NAV-001 --status Pass --notes "Dashboard loads correctly"

verify

Read back written results and compare against JSON file:

~/.claude/skills/uat-reporter/scripts/uat_reporter.rb verify --file .uat/results/dashboard.json

sync-summaries

Recalculate the Summary and Module Summary tabs from All Test Cases data. Run this after any test result update to keep all tabs synchronized:

~/.claude/skills/uat-reporter/scripts/uat_reporter.rb sync-summaries

Preview what would be written:

~/.claude/skills/uat-reporter/scripts/uat_reporter.rb sync-summaries --dry-run

When to use: After report-batch, report-single, or any manual sheet edit to keep Summary and Module Summary tabs in sync with the All Test Cases source of truth.

Flags

All commands accept:

  • --dry-run — Preview without modifying the sheet
  • --spreadsheet-id <id> — Override default from .uat/config.json

Configuration

  • Default spreadsheet ID: .uat/config.json → google_sheet_id
  • OAuth token: ~/.claude/.google/token.json (shared with google-sheets skill)
  • Log file: .uat/logs/reporter.log

Exit Codes

0=success, 1=operation failed, 2=auth error, 3=API error, 4=invalid args

Bundled Resources

  • scripts/uat_reporter.rb — Main executable script
  • references/color-map.json — Status-to-RGB color mappings (Pass=green, Fail=red, Blocked=yellow, Skip=gray)
  • references/sample-results.json — Hand-crafted test results for validation