Auto meeting summarizer with Google Drive, OpenAI Whisper & GPT-4 to Sheets

🎤 Audio-to-Insights: Auto Meeting Summarizer Transform your meeting recordings into actionable insights automatically. This powerful n8n workflow monitors your Google Drive for new audio files, transcribes them using OpenAI's Whisper, generates intelligent summaries with ChatGPT, and logs everything in Google Sheets - all without lifting a finger. 🔄 How It Works This workflow operates as a seamless 6-step automation pipeline: Step 1: Smart Detection The workflow continuously monitors a designated Google Drive folder (polls every minute) for newly uploaded audio files. Step 2: Secure Download When a new audio file is detected, the system automatically downloads it from Google Drive for processing. Step 3: AI Transcription OpenAI's Whisper technology converts your audio recording into accurate text transcription, supporting multiple audio formats. Step 4: Intelligent Summarization ChatGPT processes the transcript using a specialized prompt that extracts: - Key discussion points and decisions - Action items with assigned persons and deadlines - Priority levels and follow-up tasks - Clean, professional formatting Step 5: Timestamp Generation The system automatically adds the current date and formats it consistently for tracking purposes. Step 6: Automated Logging The final summary is appended to your Google Sheets document with the date, creating a searchable archive of all meeting insights. ⚙️ Setup Steps Prerequisites Before setting up the workflow, ensure you have: - Active Google Drive account - OpenAI API key with credits - Google Sheets access - n8n instance (cloud or self-hosted) Configuration Steps 1. Credential Setup - Google Drive OAuth2: Required for folder monitoring and file downloads - OpenAI API Key: Needed for both transcription (Whisper) and summarization (ChatGPT) - Google Sheets OAuth2: Essential for writing summaries to your spreadsheet 2. Google Drive Configuration - Create a dedicated folder in Google Drive for meeting recordings - Copy the folder ID from the URL (the long string after /folders/) - Update the folderToWatch parameter in the workflow 3. Google Sheets Preparation - Create a new Google Sheet or use an existing one - Ensure it has columns: Date and Meeting Summary - Copy the spreadsheet ID from the URL - Update the documentId parameter in the workflow 4. Audio Requirements - Supported Formats: MP3, WAV, M4A, MP4 - Recommended Size: Under 100MB for optimal processing - Language: Optimized for English (customizable for other languages) - Quality: Clear audio produces better transcriptions 5. Workflow Activation - Import the workflow JSON into your n8n instance - Configure all credential connections - Test with a sample audio file - Activate the workflow trigger 🚀 Use Cases Project Management - Team Standup Summaries: Convert daily standups into actionable task lists - Sprint Retrospectives: Extract improvement points and action items - Stakeholder Updates: Generate concise reports for leadership Sales & Customer Success - Discovery Call Notes: Capture prospect pain points and requirements - Demo Follow-ups: Track questions, objections, and next steps - Customer Check-ins: Monitor satisfaction and expansion opportunities Consulting & Professional Services - Client Strategy Sessions: Document recommendations and implementation plans - Requirements Gathering: Organize complex project specifications - Progress Reviews: Track deliverables and milestone achievements HR & Training - Interview Debriefs: Standardize candidate evaluation notes - Training Sessions: Create searchable knowledge bases - Performance Reviews: Document development plans and goals Research & Development - Brainstorming Sessions: Capture innovative ideas and concepts - Technical Reviews: Log decisions and architectural choices - User Research: Organize feedback and insights systematically 💡 Advanced Customization Options Enhanced Summarization Modify the ChatGPT prompt to focus on specific elements: - Add speaker identification fo