π 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