LLM QualAnalyzer
MaxLvhao
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)
