UX Interview Analysis with OpenAI: Transcribe and Export to Google Sheets

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)