Automate Japanese Subtitles for Google Drive Videos with n8n

Automate Japanese Subtitles for Google Drive Videos with n8n

Effortlessly streamline your video subtitle process with the "Automate Japanese Subtitles for Google Drive Videos with n8n" workflow. Designed for seamless integration and efficient execution, this workflow watches for new video links in Google Drive, generates English transcriptions and Japanese translations via AssemblyAI, polishes them through Google Gemini, and finalizes with burned-in subtitles using Creatomate. All this, delivered directly to your Slack channel, maximizing productivity and minimizing manual effort.

What this workflow does

• Activates upon detecting a new row entry in a specific Google Sheets document.
• Extracts the video link from Google Drive and converts it to a direct downloadable format.
• Retrieves metadata from the video to fine-tune subtitle appearance.
• Submits the video link to AssemblyAI, obtaining transcription and Japanese translation, continually checking until the transcript is finalized.
• Enhances the Japanese subtitles with Google Gemini to enhance punctuation and readability without altering the original meaning.
• Constructs a detailed subtitle timeline using the refined text and AssemblyAI timings, initiating a render in Creatomate.
• Monitors the rendering process in Creatomate, eventually posting the finalized video link on a designated Slack channel.

Use cases

• Media companies seeking to distribute Japanese subtitled versions of their content quickly.
• Educators and online course creators needing cost-effective subtitle translations for global reach.
• Businesses looking to engage with Japanese audiences without manual caption creation.

Technical details

• Integrations used: Google Sheets, Google Drive, AssemblyAI (HTTP Header Auth), Google Gemini (PaLM/Gemini API), Creatomate (HTTP Header Auth), Slack (OAuth2).
• Node modules: if, set, code, wait, slack, sticky note.