Summarize Drive Meeting Recordings with Whisper and GPT

### 🎤 Meeting Audio to Summary in Google Sheets Automatically transcribe a meeting audio file, generate a concise summary using AI, and log it in Google Sheets. Perfect for: ✅ Team syncs — stay aligned without rewatching recordings ✅ Client calls — quick insight into discussions ✅ Knowledge management — searchable summaries --- ### ⚙️ What's Used n8n Nodes: Drive Upload → Download File → Transcribe Recording → Create Summary → Get Date → Format Date → Append to Google Sheets External Tools: * Google Drive – Upload and host meeting recordings * OpenAI / Whisper – Audio transcription * ChatGPT – Summary generation * Google Sheets – Final summary storage --- ### 🔑 Setup – Credentials Needed * Google Drive OAuth2 → To access and download files * OpenAI API Key → For transcription & summary * Google Sheets OAuth2 → To append rows to the sheet --- ### 📝 Upload Flow Trigger: Upload audio file to a designated Google Drive folder Input Format: * Audio Type: MP3 / WAV / M4A * File Size: Recommended < 100MB * Language: English (default; can customize for others) --- ### 🚀 Workflow Steps 1. Detect File Upload: Monitor a specific Google Drive folder for new audio files 2. Download File: Fetch the uploaded audio file 3. Transcribe Audio: Use Whisper (OpenAI) to convert speech to text 4. Generate Summary: Pass transcript to GPT to summarize key points 5. Get & Format Date: Add timestamp to summary 6. Save Summary: Append date + summary into a Google Sheet Sheet Example Columns: Date, Meeting Summary --- ### 🧠 Use Cases * Project Managers → Share concise updates with stakeholders * Sales Teams → Summarize discovery or demo calls * Consultants → Keep track of discussions for reporting --- ### 💡 Pro Tips * Add speaker labels to transcript if using enhanced audio models * Customize the prompt to tailor summaries for specific departments (e.g., sales, product) * Schedule the workflow to run daily/weekly with new uploads --- ### 🛠️ Customize It * Use a form trigger if you want users to submit metadata with uploads * Add Slack integration to share summaries with the team * Store full transcripts alongside summaries for deeper context --- This setup gives your team an always-on assistant for meetings — listen once, never retype. Upload audio, get insight, move forward.