LLM QualAnalyzer

About

LLM QualAnalyzer brings LLM-powered qualitative coding to academic researchers directly within Google Sheets.

WHAT IT DOES
Analyze qualitative data (interviews, surveys, open-ended responses) using large language models — with the granular control and transparency that peer review demands.

KEY FEATURES
- Prompt Builder: A multi-step wizard that converts your codebook into precise, reproducible LLM prompts
- Granular Analysis: Specify exactly which columns, rows, and data to analyze — not a black-box whole-document approach
- Job Queue: Process hundreds of rows with batch processing, status monitoring, and interrupted job recovery
- Multi-Provider Support: Works with OpenAI, Anthropic, and OpenRouter — use your own API keys
- Local Model Support: Optionally use locally-running models via Ollama for complete data privacy
- Google Workspace Integration: Read from Google Docs, analyze in Google Sheets, with full read/write access
- IRR Calculator: Built-in Inter-Rater Reliability calculator for validating your LLM coding against human coders
- Dark Theme: Full dark mode UI for comfortable extended research sessions
- Side Panel UI: Works alongside your Google Sheets in Chrome's side panel — no tab switching needed

WHAT'S NEW IN v2.0.1
- OpenRouter support — access hundreds of models through a single API key
- Dark theme — complete UI overhaul with dark mode
- New icon and branding — now LLM QualAnalyzer

WHO IT'S FOR
- Qualitative researchers in social sciences, psychology, education, communication, and political science
- Measurement specialists evaluating LLM reliability for scoring constructed responses
- Any academic who needs defensible, auditable LLM-assisted methodology for peer review

PRIVACY-FIRST DESIGN
- No server-side storage — all data stays in your Google Workspace
- API keys stored locally in your browser, never transmitted to third parties
- Open source — full transparency into how the tool works
- No usage tracking — your research data is yours alone

HOW IT WORKS
1. Connect your Google account
2. Add your LLM API key (OpenAI, Anthropic, or OpenRouter) or configure a local model
3. Open a Google Sheet with your data
4. Use the Prompt Builder to create your analysis prompt
5. Run jobs — results appear directly in your sheet
6. Validate with the IRR Calculator

REQUIREMENTS
- Chrome 114 or later (uses Chrome Side Panel API)
- A Google account with access to Google Sheets
- An API key from OpenAI, Anthropic, or OpenRouter (or Ollama running locally)