⚡ Day 5: The AI-Managed Test Plan

Goal: Generate a comprehensive E2E test suite and use AI within Google Sheets to automatically enrich and manage the test plan.

You'll create a complete test plan in two parts: first generating E2E test cases, then enriching them with AI-powered analysis in Google Sheets.

Part 1: Generate the Core Test Suite

Let's create a comprehensive set of E2E test cases based on your feature requirements:

🧪 Generate Test Suite in Gemini

Part 2: Build the Intelligent Test Plan

Now, let's enrich your test plan with AI-powered analysis in Google Sheets:

  1. Create a new Google Sheet
  2. Paste your Gemini-generated markdown table into cell A1
  3. Add these AI-powered columns to automatically analyse your tests:
Priority Analysis (Column E)
=GEMINI("Rate the priority of this test case (Critical, High, Medium, or Low) based on its title and expected result: " & B2 & " " & D2)
Automation Assessment (Column F)
=GEMINI("Assess the automation feasibility of this test case as either 'Easy', 'Medium', or 'Hard', and provide a 1-sentence reason. Base the assessment on the complexity of the user steps: " & C2)

💡 Pro Tips

  • After pasting each formula, drag the blue square in the bottom-right corner to apply it to all test cases
  • Give the Gemini function a moment to analyse each cell - it might take a few seconds per row
  • You can modify the formula text to get different kinds of analysis (e.g., risk assessment, test environment needs)

📝 Knowledge Check

In Part 2 of the exercise, what was the primary role of the =GEMINI() function?