QA Assistant Agent with Runner H: Validate Bug Priority from Google Sheets and Send Report via Email

This is a submission for the Runner H "AI Agent Prompting" Challenge

What I Built

I built a simple yet impactful AI QA Assistant Agent using Runner H that automatically:

• Accesses a shared Google Sheet containing bug reports
• Analyzes whether each bug description aligns with its assigned priority
• Detects any mismatch or inconsistency
• Summarizes the findings
• Sends the result directly via email to the QA team

This helps streamline manual QA validation work and promotes consistent prioritization of issues.

Demo

👉 https://www.loom.com/share/49b5aa14077e4d3da64f8ed1638fb20d?sid=76f974ce-198d-4c99-9e18-95974c75e2a1

How I Used Runner H

Here's how I set up the workflow:

1. Tools Integrated:
   • Google Sheets (read access)
   • Gmail (send report)

2. Prompt Used:
   

   Access the Google Sheet at this link: https://docs.google.com/spreadsheets/d/1astlWEzpP1FiLOqhojPuMC_Kzdto8zv7Hybr7Oa098A/edit?usp=sharing 
   Analyze each row to check if the 'Bug Description' matches the assigned 'Priority' level appropriately. 
   For any mismatch or inconsistency, list the row number, bug description, and explanation. 
   Then, email the result to [email protected] with the subject: 'Bug-Priority Validation Report'.
   

3. Logic Flow (MermaidJS):
   

   flowchart TD
       A[Access Google Sheet] --> B[For Each Row: Analyze Bug Description vs Priority]
       B --> C{Is Priority Appropriate?}
       C -- No --> D[Add to Report]
       C -- Yes --> E[Skip to Next Row]
       D --> B
       E --> B
       B -->|All Rows Processed| F[Summarize Result]
       F --> G[Send Email with Result]
   

4. Execution: Runner H parsed and ran the above logic in one smooth flow with no custom code needed.

Use Case & Impact

🎯 Use Case:

This agent is designed for QA Teams, Project Managers, or Bug Triage Committees who want to validate if developers/testers are assigning appropriate priority levels based on bug severity.

🚀 Impact:

• Saves time from manually reviewing each entry
• Ensures alignment in issue prioritization
• Prevents "low priority critical bugs" slipping through

👤 Who Benefits:

• QA Engineers
• Product Owners
• Agile teams who manage large-scale issue tracking via shared spreadsheets

Please like, comment, or share if you find this useful! ❤️

Thanks to Runner H and DEV for enabling makers to build no-code intelligent automation this easily!