📊 UX interview analysis with OpenAI: transcribe and export to Google Sheets
⚡ 761 views · 📊 Market Research & Insights
Description
UX Interview Analysis with OpenAI: Transcipt, Summarize, and Export to Google Sheets!
About
Easily analyze and summarize UX interviews. Just upload your files to Google Drive and get the insights directly in Google Sheets.
How It Works
- The workflow is triggered manually
- Upload the interview recordings in MP3 format to Google Drive (or modify the node “Filter by MP3” to support other formats)
- OpenAI transcribes the audio
- An AI agent generates a summary
- Store the results in Google Sheets
How To Use
- Import the package into your n8n interface
- Set up credentials for each node to access the required tools
- Upload your interview files to Google Drive
- Create a Google Sheet with the following columns: • Persona • User Needs • Pain Points • New Feature Requests
- Connect the Google Sheets node titled “Insert results to Google Sheets” to your created document
- Start the workflow
Requirements
- OpenAI for transcription and summarization (you can replace it with Gemini if preferred)
🔗 Nodes Used
Google Sheets, Google Drive, Filter, AI Agent, OpenAI Chat Model, Structured Output Parser
📥 Import
Download workflow.json and import into n8n:
Workflow menu → Import from File