Summarize meeting transcripts with Google Drive, OpenAI, Gmail, and Sheets
Ready for 3.0What this workflow does
This AI workflow has 14 nodes and runs on Google Drive events (file created). Along the way it connects Google Drive, OpenAI Chat Model, Gmail and Telegram and 1 more.
How it runs
Trigger: On Google Drive events (file created).
- Download Transcript from Drive (Google Drive): download
- Extract Text from Transcript (Extract from File): extracts data from a file (text)
- Sanitize Transcript Text (Code): runs custom JavaScript code
- Validate Transcript Content (If): checks a condition and branches into true / false
- AI Extract Decisions & Actions (Basic LLM Chain): sends a prompt to an LLM, with model: Use OpenAI GPT-4 Model
- Confirm AI Extraction Validity (Code): runs custom JavaScript code
- Compile Minutes and Drafts (Code): runs custom JavaScript code
- Draft Follow-Up Email (Gmail): work with draft
- Post Action List to Telegram (Telegram): uses Telegram
- Divide Actions for Tracker (Code): runs custom JavaScript code
…plus 1 more step. See the full node list below.
Services it uses
Before you upgrade to n8n 3.0
Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.
Nodes used (11)
- Google Drive Trigger
n8n-nodes-base.googleDriveTrigger - Google Drive
n8n-nodes-base.googleDrive - Extract from File
n8n-nodes-base.extractFromFile - Code
n8n-nodes-base.code - If
n8n-nodes-base.if - No Operation, do nothing
n8n-nodes-base.noOp - Basic LLM Chain
@n8n/n8n-nodes-langchain.chainLlm - OpenAI Chat Model
@n8n/n8n-nodes-langchain.lmChatOpenAi - Gmail
n8n-nodes-base.gmail - Telegram
n8n-nodes-base.telegram - Google Sheets
n8n-nodes-base.googleSheets
From the author
Quick overview Drop a meeting transcript in a Drive folder (Meet doc, .txt, .vtt/.srt) and get structured minutes, decisions, and action items with owners, due dates and priorities — as a Gmail draft you review before sending, a Telegram ping, and a running…