Create Google Tasks from Tactiq meeting transcripts using OpenAI and Telegram
Ready for 3.0What this workflow does
This AI workflow has 21 nodes and runs on Google Drive events (plus 1 other trigger). Along the way it connects Google Drive, OpenAI, Google Tasks and Telegram.
How it runs
Trigger: On Google Drive events (plus 1 other trigger).
- Set Template Variables (Edit Fields (Set)): sets 5 fields: drive_folder_id, telegram_chat_id, timezone…
- Fetch Processed Transcripts (Data table): get
- List Transcript Files in Drive (Google Drive): work with file folder
- Filter Unprocessed Files (Code): runs custom JavaScript code
- Check for Unprocessed Files (If): checks a condition and branches into true / false
- Split Transcript Files (Split Out): splits a list into separate items
- Download Transcript from Drive (Google Drive): download
- Extract Text from Transcript (Code): runs custom JavaScript code
- AI Extract Action Items (OpenAI): uses OpenAI
- Split AI JSON Response (Split Out): splits a list into separate items
…plus 9 more steps. 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 - Edit Fields (Set)
n8n-nodes-base.set - Data table
n8n-nodes-base.dataTable - Google Drive
n8n-nodes-base.googleDrive - Code
n8n-nodes-base.code - If
n8n-nodes-base.if - Split Out
n8n-nodes-base.splitOut - OpenAI
@n8n/n8n-nodes-langchain.openAi - Google Tasks
n8n-nodes-base.googleTasks - Telegram
n8n-nodes-base.telegram - Schedule Trigger
n8n-nodes-base.scheduleTrigger
From the author
Quick overview This workflow monitors a Google Drive folder for new Tactiq transcript files, uses OpenAI to extract explicit action items, creates matching Google Tasks, sends a Telegram notification, and logs each processed transcript in an n8n Data Table to…