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

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)