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

⚡ 5,369 views · 🔬 Document Extraction & Analysis

💡 Pro Tip — YouTube’s API quotas can be a bottleneck when you’re pulling data at scale. ScraperNode is a community node with dedicated scrapers for channels, videos, and comments — no quota limits, just structured data.

View All Scrapers

Description

🎤 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:

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:

Configuration Steps

1. Credential Setup

2. Google Drive Configuration

3. Google Sheets Preparation

4. Audio Requirements

5. Workflow Activation

🚀 Use Cases

Project Management

Sales & Customer Success

Consulting & Professional Services

HR & Training

Research & Development

💡 Advanced Customization Options

Enhanced Summarization Modify the ChatGPT prompt to focus on specific elements:

- Add speaker identification for multi-person meetings
- Include sentiment analysis for customer calls
- Generate department-specific summaries (technical, sales, legal)
- Extract financial figures and metrics automatically

Integration Expansions

Quality Improvements

🛠️ Troubleshooting & Best Practices

Common Issues

Optimization Tips

📊 Expected Outputs

Sample Summary Format:

**Meeting Summary - March 15, 2024**

**Key Discussion Points:**
- Q1 budget review and allocation decisions
- New product launch timeline and milestones
- Team restructuring and role assignments

**Action Items:**
- John: Finalize budget proposal by March 20th (High Priority)
- Sarah: Schedule product demo sessions for March 25th
- Team: Submit org chart feedback by March 18th

**Decisions Made:**
- Approved additional marketing budget of $50K
- Delayed product launch to April 15th for quality assurance
- Promoted Lisa to Senior Developer role

📞 Questions & Support

For any questions, customizations, or technical support regarding this workflow:

📧 Email Support

🎥 Learning Resources

🔗 Professional Network

💡 What to Include in Your Support Request

Ready to transform your meeting chaos into organized insights? Download the workflow and start automating your meeting summaries today!

🔗 Nodes Used

Google Sheets, Google Drive, Google Drive Trigger, OpenAI

📥 Import

Download workflow.json and import into n8n: Workflow menu → Import from File

📖 Importing guide · 🔑 Credential setup