Agent skill

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.

View SKILL.md on GitHub Repository
Stars 4
Forks 0

Install this agent skill to your Project

npx add-skill https://github.com/arlenagreer/claude_configuration_docs/tree/main/skills/uat-reporter

SKILL.md

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:

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

Or via stdin:

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

report-single

Write one test result:

bash
~/.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:

bash
~/.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:

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

Preview what would be written:

bash
~/.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

Recommended Agent Skills

Expand your agent's capabilities with these related and highly-rated skills.

arlenagreer/claude_configuration_docs

email

Send and draft professional emails with seasonal HTML formatting, authentic writing style, contact lookup via Google Contacts, security-first approach, and Google Gmail API via Ruby CLI. This skill should be used for ALL email operations (mandatory per RULES.md).

4 0
Explore
arlenagreer/claude_configuration_docs

commit

Create detailed Git commits and push to GitHub. Use when the user wants to commit changes, save work to Git, or push updates to the repository. Trigger words include "commit", "save changes", "push to git", "update repository". (project, gitignored)

4 0
Explore
arlenagreer/claude_configuration_docs

worklog

Track billable hours for clients. This skill should be used when the user requests to log work hours, record time spent on client projects, view worklog entries, calculate total billable hours, or summarize recent work. Automatically prompts for missing information (client, hours, description) and validates client names against the invoice skill's client database.

4 0
Explore
arlenagreer/claude_configuration_docs

calendar

Manage Google Calendar with full event operations including viewing schedule, creating/editing/deleting events, finding free time, managing attendees via Google Contacts, adding Google Meet links, and timezone handling. This skill should be used for ALL calendar-related requests.

4 0
Explore
arlenagreer/claude_configuration_docs

google-sheets

Manage Google Sheets with comprehensive spreadsheet operations including reading/writing cell values, formulas, formatting, sheet management, and batch operations. Use for spreadsheet data operations, cell ranges, formulas, formatting, batch updates, and data analysis workflows. Shares OAuth token with email, calendar, contacts, drive, and docs skills.

4 0
Explore
arlenagreer/claude_configuration_docs

google-drive

Manage Google Drive files and folders with full CRUD operations via Ruby scripts. Use for file storage operations, folder organization, sharing permissions, searching across Drive, and uploading/downloading files of any type. Works seamlessly with google-sheets and google-docs skills for complete Google Workspace integration.

4 0
Explore

Didn't find tool you were looking for?

Be as detailed as possible for better results