gemini-history-analyzer

1# Gemini History Analyzer
2 
3Extract, categorize, and analyze Google Takeout ZIP exports of Gemini Apps activity. The skill handles:
4- Extraction (with Chinese/Unicode filename support)
5- Content categorization and topic analysis
6- User profile extraction from conversation patterns
7- Domain-specific keyword search with context verification
8- PII/sensitive content detection
9- Structured report generation with optional memory file creation
10 
11## Quick Judgment: Meeting Transcripts vs Prompt-Response
12 
13Before full analysis, sample 3-5 files to determine the **conversation type**:
14 
15| Signal | Meeting Transcript | Prompt-Response |
16|--------|-------------------|-----------------|
17| Speaker labels | "张三:"、"李四:"、"Speaker 1:" | "User:"、"Assistant:"、"You:" |
18| Content pattern | Discussion flow, turn-taking, small talk | Q&A, instruction→output |
19| Length distribution | Variable, lots of short turns | Longer assistant responses |
20| File naming | Often Chinese, meeting-style titles | English, topic-based titles |
21 
22The analysis approach differs:
23- **Meeting transcripts** → topic categorization, speaker analysis, decision tracking, user profile extraction
24- **Prompt-response** → usage pattern analysis, capability assessment, interest domain mapping
25 
26## Step 1: Extract the ZIP
27 
28Google Takeout files contain Chinese/Unicode filenames. **macOS `unzip` corrupts these — always use `unar`.**
29 
30```bash
31# Install unar if missing
32brew install unar 2>/dev/null || true
33 
34# Extract to a target directory
35…