Translate Google Drive videos to Japanese subtitles with AssemblyAI, Gemini and Creatomate
Ready for 3.0What this workflow does
This AI workflow has 16 nodes and runs on Google Sheets events (row added). Along the way it connects Google Sheets, Google Gemini Chat Model and Slack. It also calls api.assemblyai.com and api.creatomate.com over HTTP.
How it runs
Trigger: On Google Sheets events (row added).
- Extract: Parse Latest Video URL (Code): runs custom JavaScript code
- Prepare: Convert Drive Share URL to Download URL (Edit Fields (Set)): sets 1 field: download_url
- Fetch: Video Metadata (HTTP Request): calls an HTTP API
- Transcribe: Submit to AssemblyAI (HTTP Request): calls api.assemblyai.com (POST)
- Wait: waits 300 seconds
- Check: AssemblyAI Transcript Status (HTTP Request): calls an HTTP API
- Check: Transcription Completed? (If): checks a condition and branches into true / false
- AI: Add Natural Punctuation for Subtitle Generation (Basic LLM Chain): sends a prompt to an LLM, with model: Model: Gemini Translation
- Generate: Natural Subtitle Timeline and Creatomate Render Script (Code): runs custom JavaScript code
- Render: Combine Video and Subtitle Timeline (HTTP Request): calls api.creatomate.com (POST)
…plus 4 more steps. See the full node list below.
Services it uses
HTTP calls to: api.assemblyai.com, api.creatomate.com
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 (9)
- HTTP Request
n8n-nodes-base.httpRequest - Wait
n8n-nodes-base.wait - If
n8n-nodes-base.if - Code
n8n-nodes-base.code - Google Sheets Trigger
n8n-nodes-base.googleSheetsTrigger - Google Gemini Chat Model
@n8n/n8n-nodes-langchain.lmChatGoogleGemini - Edit Fields (Set)
n8n-nodes-base.set - Basic LLM Chain
@n8n/n8n-nodes-langchain.chainLlm - Slack
n8n-nodes-base.slack
From the author
Quick Overview This workflow watches a Google Sheets spreadsheet for new Google Drive video links, sends the video to AssemblyAI for English transcription with Japanese translation, refines the Japanese text with Google Gemini, renders burned-in subtitles via…