This n8n workflow streamlines the process of analyzing UX interview recordings by automating transcription, summarization, and data organization into Google Sheets. Starting with a manual trigger, it searches Google Drive for MP3 interview files, filters for audio files, and downloads them. The workflow then transcribes the audio using OpenAI’s transcription capabilities, and an AI agent processes the transcript to generate structured summaries highlighting personas, user needs, pain points, and feature requests. To conclude, the summarized insights are automatically appended to a specified Google Sheet, facilitating efficient analysis and documentation of user feedback. This workflow is ideal for UX researchers and product teams aiming to quickly derive actionable insights from user interviews stored in cloud storage, without manual transcription or note-taking.

Node Count	11 – 20 Nodes
Nodes Used	@n8n/n8n-nodes-langchain.agent, @n8n/n8n-nodes-langchain.lmChatOpenAi, @n8n/n8n-nodes-langchain.openAi, @n8n/n8n-nodes-langchain.outputParserStructured, filter, googleDrive, googleSheets, manualTrigger, splitOut, stickyNote