Quick Overview
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 Creatomate, and posts the final video URL to Slack. How it works Triggers when a new row is added to a specified Google Sheets worksheet. Extracts the latest Google Drive sharing link from the sheet and converts it into a direct download URL. Fetches the video’s metadata from Google Drive to inform subtitle layout decisions. Submits the video URL to AssemblyAI for transcription and Japanese translation, then waits and polls until the transcript status is completed. Sends the Japanese translation to Google Gemini to add natural punctuation and improve subtitle readability without changing meaning. Builds a subtitle timeline and a Creatomate render payload from the polished Japanese text and AssemblyAI word timings, then starts a Creatomate render. Waits and polls Creatomate until rendering succeeds, then posts the rendered video link to a Slack channel. Setup Connect credentials for Google Sheets, Google Drive, AssemblyAI (HTTP Header Auth), Google Gemini (PaLM/Gemini API), Creatomate (HTTP Header Auth), and Slack (OAuth2). Update the Google Sheets document and sheet selection to the spreadsheet that receives new Google Drive video URLs. Ensure the Google Drive videos are shared with “Anyone with the link” so AssemblyAI and Creatomate can access the download URL. Adjust the AssemblyAI source language (language_code) and target translation languages (target_languages) in the transcript request if you need languages other than English → Japanese. Set the destination Slack channel in the Slack message step to receive the final rendered video URL. An n8n automation workflow template by Koyanagi Naoyuki.
Koyanagi Naoyuki
web
free
Others in the same category, ranked by how often they are opened.
