Automate meeting transcription & minutes distribution with OpenAI and Google Drive
Automated Meeting Recording Transcription & Minutes Distribution Workflow
Managing meeting recordings manually—downloading audio, transcribing it, summarizing key points, saving documents, and notifying the team—quickly becomes repetitive and inefficient. This workflow eliminates all of those manual steps by automatically detecting new audio files uploaded to a designated Google Drive folder, converting them into high-quality transcripts using OpenAI, summarizing them into structured meeting minutes, transforming the content into a text file, uploading it back to Google Drive, and finally notifying a Chatwork room with the completed summary. What used to take hours can now be completed automatically within minutes, ensuring consistency, accuracy, and faster information sharing.
Who’s it for
This workflow is ideal for:
- Teams that need high-quality, client-ready meeting minutes generated automatically
- Project managers who require accurate summaries, decision tracking, and action items without manual effort
- Cross-functional teams handling multiple meetings and requiring structured, searchable documentation
- Organizations using Google Meet, Zoom, or Teams where recordings must be turned into polished minutes
- Anyone who wants a consistent, AI-assisted system that analyzes discussions, extracts insights, and formats them professionally
By leveraging an advanced Meeting Minutes Generation System—capable of key-point extraction, noise reduction, speaker/topic organization, and review support—this workflow ensures that every meeting is transformed into a clean, structured, and highly usable document.
How it works
1. Audio file upload triggers the workflow
When a new recording is uploaded to the designated Google Drive folder, the Google Drive Trigger immediately activates and begins processing.
2. The audio file is downloaded
The file is retrieved from Google Drive and prepared in binary format for accurate transcription.
3. AI-powered transcription
The audio is sent to OpenAI’s transcription engine, producing a complete and highly accurate transcript of the meeting.
4. Generate structured, client-ready meeting minutes
The transcript is processed by a specialized Meeting Minutes Generation System powered by a multi-step prompt.
Instead of using a fixed template, the system intelligently analyzes the transcription and automatically generates a professionally structured document using the following capabilities:
- Extraction of key points while removing irrelevant conversation
- Organization of content by speaker, topic, and logical flow
- Automatic construction of headings and document structure
- Draft generation based on client-facing writing standards
- Review-support logic that allows refinement and improved readability
- Task-based orchestration (ingestion → key-point extraction → draft generation → review → final approval)
Because the system dynamically determines the optimal structure, the resulting minutes adapt to the content of each meeting rather than following a rigid set of categories.
If certain information cannot be derived from the transcript, the system will appropriately leave it out rather than forcing placeholder sections.
5. Convert the minutes into a file
The structured minutes are converted into a .txt or .docx document, ready for submission or archival.
6. Upload the finalized document
The completed meeting minutes are uploaded to a specific Google Drive folder and saved using a timestamped filename.
7. Notify Chatwork
A formatted notification—including the summarized content—is automatically posted to a Chatwork room, ensuring immediate team visibility.
How to set up
- Import the workflow into your n8n environment.
- Authenticate Google Drive and select the folder to monitor for new recordings.
- Connect your OpenAI API keys for both transcription and structured minutes generation.
- Specify the Google Drive folder where the finished documents should be stored.
- Add your Chatwork API token and room ID for automated notifications.
- Upload a sample audio file to confirm the full end-to-end pipeline works correctly.
Requirements
- n8n instance (cloud or self-hosted)
- Google Drive account with appropriate folder permissions
- OpenAI API credentials
- Chatwork API token
- Supported audio formats like mp3, wav, m4a, etc.
How to customize the workflow
- Modify the minutes-generation prompt to reflect your organization’s preferred format
- Add Slack, Teams, or Discord notifications in addition to Chatwork
- Route different types of meetings to different folders or templates
- Save transcript and structured minutes separately for compliance or analysis
- Log metadata or decisions into Google Sheets or project management tools
- Store minutes in a vector database to enable semantic search across past meetings
- Attach the final document directly as a file in Chatwork
- Extend the system to support revision cycles, reviewer comments, or approval workflows
Automate Meeting Transcription and Minutes Distribution with OpenAI and Google Drive
This n8n workflow automates the process of transcribing audio files from Google Drive using OpenAI's Whisper model and distributing the transcribed text. It acts as a powerful tool for streamlining meeting minutes, lecture notes, or any audio content conversion.
What it does
This workflow simplifies the process of converting audio recordings into text by:
- Triggering on New Audio Files: It listens for new audio files uploaded to a specified folder in Google Drive.
- Downloading the Audio File: Once a new audio file is detected, it downloads the file from Google Drive.
- Converting to File (Optional/Placeholder): The workflow includes a "Convert to File" node, which can be used for various file transformations, though its specific configuration isn't detailed in the provided JSON. It might be used for format conversion if needed before sending to OpenAI.
- Transcribing with OpenAI: It sends the audio file to OpenAI's API (likely using the Whisper model) for transcription.
- Handling Transcription Output: The transcribed text is then available for further processing.
- Uploading Transcription to Google Drive: The transcribed text is uploaded back to Google Drive as a new file.
Prerequisites/Requirements
To use this workflow, you will need:
- n8n Instance: A running instance of n8n.
- Google Drive Account: Configured with n8n credentials to allow access to your Google Drive.
- OpenAI API Key: An OpenAI API key with access to the Whisper transcription model.
- Google Drive Folder: A designated Google Drive folder where audio files will be uploaded to trigger the workflow, and where the transcribed text will be saved.
Setup/Usage
- Import the Workflow: Import the provided JSON into your n8n instance.
- Configure Google Drive Trigger:
- Set up your Google Drive credentials.
- Specify the "Watch Folder ID" in the "Google Drive Trigger" node to monitor for new audio file uploads.
- Configure Google Drive Node (Download):
- Ensure your Google Drive credentials are set up.
- The node is configured to download the file that triggered the workflow.
- Configure OpenAI Node:
- Set up your OpenAI API Key credential.
- Ensure the node is configured to use the audio file from the previous step as input for transcription.
- Configure Google Drive Node (Upload):
- Ensure your Google Drive credentials are set up.
- Configure this node to upload the transcribed text (output from the OpenAI node) to a specified folder in Google Drive. You might want to define a naming convention for the output files.
- Activate the Workflow: Once all credentials and configurations are set, activate the workflow.
Now, any audio file uploaded to your designated Google Drive folder will be automatically transcribed by OpenAI and the text file will be saved back into Google Drive.
Related Templates
AI-powered code review with linting, red-marked corrections in Google Sheets & Slack
Advanced Code Review Automation (AI + Lint + Slack) Who’s it for For software engineers, QA teams, and tech leads who want to automate intelligent code reviews with both AI-driven suggestions and rule-based linting — all managed in Google Sheets with instant Slack summaries. How it works This workflow performs a two-layer review system: Lint Check: Runs a lightweight static analysis to find common issues (e.g., use of var, console.log, unbalanced braces). AI Review: Sends valid code to Gemini AI, which provides human-like review feedback with severity classification (Critical, Major, Minor) and visual highlights (red/orange tags). Formatter: Combines lint and AI results, calculating an overall score (0–10). Aggregator: Summarizes results for quick comparison. Google Sheets Writer: Appends results to your review log. Slack Notification: Posts a concise summary (e.g., number of issues and average score) to your team’s channel. How to set up Connect Google Sheets and Slack credentials in n8n. Replace placeholders (<YOURSPREADSHEETID>, <YOURSHEETGIDORNAME>, <YOURSLACKCHANNEL_ID>). Adjust the AI review prompt or lint rules as needed. Activate the workflow — reviews will start automatically whenever new code is added to the sheet. Requirements Google Sheets and Slack integrations enabled A configured AI node (Gemini, OpenAI, or compatible) Proper permissions to write to your target Google Sheet How to customize Add more linting rules (naming conventions, spacing, forbidden APIs) Extend the AI prompt for project-specific guidelines Customize the Slack message formatting Export analytics to a dashboard (e.g., Notion or Data Studio) Why it’s valuable This workflow brings realistic, team-oriented AI-assisted code review to n8n — combining the speed of automated linting with the nuance of human-style feedback. It saves time, improves code quality, and keeps your team’s review history transparent and centralized.
Daily cash flow reports with Google Sheets, Slack & Email for finance teams
Simplify financial oversight with this automated n8n workflow. Triggered daily, it fetches cash flow and expense data from a Google Sheet, analyzes inflows and outflows, validates records, and generates a comprehensive daily report. The workflow sends multi-channel notifications via email and Slack, ensuring finance professionals stay updated with real-time financial insights. 💸📧 Key Features Daily automation keeps cash flow tracking current. Analyzes inflows and outflows for actionable insights. Multi-channel alerts enhance team visibility. Logs maintain a detailed record in Google Sheets. Workflow Process The Every Day node triggers a daily check at a set time. Get Cash Flow Data retrieves financial data from a Google Sheet. Analyze Inflows & Outflows processes the data to identify trends and totals. Validate Records ensures all entries are complete and accurate. If records are valid, it branches to: Sends Email Daily Report to finance team members. Send Slack Alert to notify the team instantly. Logs to Sheet appends the summary data to a Google Sheet for tracking. Setup Instructions Import the workflow into n8n and configure Google Sheets OAuth2 for data access. Set the daily trigger time (e.g., 9:00 AM IST) in the "Every Day" node. Test the workflow by adding sample cash flow data and verifying reports. Adjust analysis parameters as needed for specific financial metrics. Prerequisites Google Sheets OAuth2 credentials Gmail API Key for email reports Slack Bot Token (with chat:write permissions) Structured financial data in a Google Sheet Google Sheet Structure: Create a sheet with columns: Date Cash Inflow Cash Outflow Category Notes Updated At Modification Options Customize the "Analyze Inflows & Outflows" node to include custom financial ratios. Adjust the "Validate Records" filter to flag anomalies or missing data. Modify email and Slack templates with branded formatting. Integrate with accounting tools (e.g., Xero) for live data feeds. Set different trigger times to align with your financial review schedule. Discover more workflows – Get in touch with us
Track daily moods with AI analysis & reports using GPT-4o, Data Tables & Gmail
Track your daily mood in one tap and receive automated AI summaries of your emotional trends every week and month. Perfect for self-reflection, wellness tracking, or personal analytics. This workflow logs moods sent through a webhook (/mood) into Data Tables, analyzes them weekly and monthly with OpenAI (GPT-4o), and emails you clear summaries and actionable recommendations via Gmail. ⚙️ How It Works Webhook – Mood → Collects new entries (🙂, 😐, or 😩) plus an optional note. Set Mood Data → Adds date, hour, and note fields automatically. Insert Mood Row → Stores each record in a Data Table. Weekly Schedule (Sunday 20:00) → Aggregates the last 7 days and sends a summarized report. Monthly Schedule (Day 1 at 08:00) → Aggregates the last 30 days for a deeper AI analysis. OpenAI Analysis → Generates insights, patterns, and 3 actionable recommendations. Gmail → Sends the full report (chart + AI text) to your inbox. 📊 Example Auto-Email Weekly Mood Summary (last 7 days) 🙂 5 ██████████ 😐 2 ████ 😩 0 Average: 1.7 (Positive 🙂) AI Insights: You’re trending upward this week — notes show that exercise days improved mood. Try keeping short walks mid-week to stabilize energy. 🧩 Requirements n8n Data Tables enabled OpenAI credential (GPT-4o or GPT-4 Turbo) Gmail OAuth2 credential to send summaries 🔧 Setup Instructions Connect your credentials: Add your own OpenAI and Gmail OAuth2 credentials. Set your Data Table ID: Open the Insert Mood Row node and enter your own Data Table ID. Without this, new moods won’t be stored. Replace the email placeholder: In the Gmail nodes, replace your.email@example.com with your actual address. Deploy and run: Send a test POST request to /mood (e.g. { "mood": "🙂", "note": "productive day" }) to log your first entry. ⚠️ Before activating the workflow, ensure you have configured the Data Table ID in the “Insert Mood Row” node. 🧠 AI Analysis Interprets mood patterns using GPT-4o. Highlights trends, potential triggers, and suggests 3 specific actions. Runs automatically every week and month. 🔒 Security No personal data is exposed outside your n8n instance. Always remove or anonymize credential references before sharing publicly. 💡 Ideal For Personal mood journaling and AI feedback Therapists tracking client progress Productivity or self-quantification projects 🗒️ Sticky Notes Guide 🟡 Mood Logging Webhook POST /mood receives mood + optional note. ⚠️ Configure your own Data Table ID in the “Insert Mood Row” node before running. 🟢 Weekly Summary Runs every Sunday 20:00 → aggregates last 7 days → generates AI insights + emails report. 🔵 Monthly Summary Runs on Day 1 at 08:00 → aggregates last 30 days → creates monthly reflection. 🟣 AI Analysis Uses OpenAI GPT-4o to interpret trends and recommend actions. 🟠 Email Delivery Sends formatted summaries to your inbox automatically.