Llm Qualanalyzer

LLM Qual Agent 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 and Anthropic — 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
- Side Panel UI: Works alongside your Google Sheets in Chrome's side panel — no tab switching needed

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 or Anthropic) 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 or Anthropic (or Ollama running locally)