UX Interview Analysis: Transcribe, Summarize & Export to Sheets

This n8n workflow revolutionizes UX interview analysis by automating the entire pipeline from audio upload to actionable insights. Triggered manually, it fetches MP3 files from Google Drive, filters for compatible formats, transcribes them accurately using OpenAI's Whisper model, and employs an AI agent to parse transcripts into structured JSON outputs covering key categories like Persona, User Needs, Pain Points, and New Feature Requests. The results are seamlessly inserted into a predefined Google Sheets template, enabling instant data aggregation and visualization.

Key benefits include massive time savings—eliminating hours of manual transcription and note-taking—consistent, standardized outputs for reliable cross-interview comparisons, and effortless scalability for high-volume research. It integrates powerful AI capabilities with familiar tools like Google Drive and Sheets, reducing errors and enhancing collaboration without coding expertise.

Perfect for UX researchers, product managers, and design teams, use cases span customer discovery sessions, usability testing follow-ups, and longitudinal user studies. Upload recordings post-interview, run the workflow, and get a shareable Sheet ready for stakeholder reviews or dashboard integrations. Customizable for other formats or AI providers like Gemini.