What You Will Learn
You will learn how to use Gemini to turn risks, gaps, blockers, and open questions into a structured issue log with priority, owner, recommended action, due date, and resolution criteria.
Required Dataset
Use any workbook with findings, actions, risks, or open questions.
Recommended tabs:
Findings_Log
Project_Workplan
Workplan_Check
Create three new tabs:
Raw_Issue_Capture
Client_Ready_Issue_Log
Issue_Log_Check
Before You Start
An issue log is not just a list of problems. It should help management understand what needs attention, why it matters, who owns it, and what happens next.
Use issue types such as:
Risk
Gap
Blocker
Open Question
Decision Needed
Data Quality
Dependency
Use status values such as:
Open
In Progress
Blocked
Escalated
Resolved
Deferred
Step-by-Step Instructions
Step 1. Capture raw issues
In Raw_Issue_Capture, collect issues from findings, workplans, QA checks, stakeholder comments, or analysis gaps.
Use fields such as:
Raw Issue ID
Source Area
Raw Issue Text
Evidence
Initial Concern
Captured By
Capture Date
Needs Cleanup
Step 2. Ask Gemini to clean and structure issues
Use this prompt:
Act as a consulting project manager.
Convert the raw issues in Raw_Issue_Capture into a client-ready issue log.
For each issue, return:
Issue ID, Issue Type, Issue Description, Source Area, Evidence, Impact, Urgency, Priority, Owner Role, Recommended Action, Due Date, Status, Escalation Needed, Decision Needed, Resolution Criteria, and Notes.
Rules:
– Keep issue wording neutral and specific.
– Do not invent evidence.
– Recommended actions must start with an action verb.
– Resolution criteria must define what “done” means.
Paste the output into Client_Ready_Issue_Log.
Step 3. Add priority and escalation logic
Use priority values:
P1
P2
P3
Monitor
A simple priority rule is:
=IFS(AND(Impact=”High”,Urgency=”High”),”P1″,OR(Impact=”High”,Urgency=”High”),”P2″,OR(Impact=”Medium”,Urgency=”Medium”),”P3″,TRUE,”Monitor”)
Add an overdue flag if the due date is past and status is not resolved.
Expected Result
You should have a client-ready issue log with clear issue descriptions, evidence, priority, owner, recommended action, due date, escalation status, and resolution criteria.
Check Your Work
Confirm that every issue is specific, evidence-backed, neutral in tone, assigned to an owner role, and linked to a practical next step. P1 and blocked issues should be easy to identify.
Optional Extension
Ask Gemini:
Create a steering committee issue view from Client_Ready_Issue_Log. Include only P1, blocked, escalated, overdue, or decision-needed issues. Keep the output concise and decision-oriented.
