Multilingual YouTube metadata translator with Gemini AI and Google Sheets

Translating your YouTube video titles and descriptions into multiple languages is one of the simplest ways to expand your channel's global reach. But doing it manually is super tedious and time-consuming. This n8n workflow automates the entire process: from detecting your latest video, translating its metadata into multiple languages using AI, to publishing the translated versions directly to YouTube - all managed and tracked through a connected Google Sheet only.

What Problem Is This Workflow Solving? Manually translating YouTube metadata—titles, descriptions, and tags—is both time-consuming and costly, especially as your video library grows. For example, let's say you want to translate the metadata of 50 videos into 5 languages, and if you spend 10 minutes on each video, it could take over 40 hours of manual work.

This workflow automates the localization of your YouTube metadata, making it fast and efficient to translate large volumes of content. Instead of spending days on translations, you can handle bulk updates in minutes: - Save Time and Resources: Instantly translate metadata for dozens or hundreds of videos, freeing you from repetitive, manual tasks. - Expand Your Global Reach: Enable your videos to appear in search results across multiple languages, reaching new audiences worldwide. - Boost Engagement and SEO: Localized metadata helps your videos get discovered and increases viewer engagement, leading to higher watch times and better performance. - Make Content More Accessible: Welcome viewers from different linguistic backgrounds, making your channel inclusive and inviting.

Who Is This For? Use cases are many: This workflow is perfect for YouTubers who want to automate multilingual metadata updates and eliminate repetitive manual tasks. It’s especially useful for creators whose content is visually driven and easy to follow, such as: - DIY and How-to Channels - Travel and Nature Channels - Fitness and Workout Channels - Cooking Channels - Art and Craft Channels

How It Works Phase 1: Prepare Values & Auto Crawl Mode - Set up a Schedule Trigger: In the Schedule Trigger node in n8n, define your preferred interval to automatically run the workflow on a recurring schedule; no manual execution needed. - Set Required Parameters: In the Prepare Values node in n8n, you must enter the following: - spreadsheetid: to link the workflow to your connected Google Sheet - channelname: to specify which tab of the Google Sheet contains the video URLs to process - channelid: to define the YouTube channel the workflow will act upon - Set Target Languages: In the Languages tab of your connected Google Sheet, list all languages you'd like to generate translated titles and descriptions for. These will be used later during the translation phase. - Choose Crawling Mode: In the Auto tab of your Google Sheet, configure the Auto Crawl setting in Column B based on your preferred method: - Select No (Turn off Auto Crawl): You must manually input the video URL(s) in the channelname tab and set the status to Ready for 1 video only. - Select Yes (Turn on Auto Crawl): The workflow will automatically fetch one of the latest videos from your connected YouTube channel (based on channelid) into the channelname tab in your Google Sheet.

Phase 2: Trigger The Process - Once everything is properly set up, the workflow in n8n can be activated - either manually or automatically via the Schedule Trigger, which runs based on the interval you’ve configured earlier. - The tool then checks the Auto Crawl status in Column B in the Auto tab of your connected Google Sheet to determine the route: - If Auto Crawl = No: The workflow skips auto-fetching and proceeds directly to the next phase, expecting that the video URL is already entered manually and marked as Ready in its status. - If Auto Crawl = Yes: The tool connects to your YouTube channel using the predefined channelid. It fetches one of the latest videos and checks whether that video’s ID already exists in the list of processed videos. - If the video has not been processed yet, its URL will be inserted into the channelname tab, and its status in Column A will automatically be set to Ready, ensuring it proceeds to the next step. - If it already exists, the video is skipped to avoid reprocessing.

⚠️ Important: When Auto Crawl = Yes, do not manually add another URL and set its status to Ready in the channelname tab in the Google Sheet. Doing so may trigger the same video twice, causing data conflicts and redundant processing.

Phase 3: Collect Video Information - Once a new video URL appears in your connected Google Sheet and its status is set Ready in Column A (under the specified channelname tab), the workflow picks it up automatically. - Then, it extracts the Video ID from the URL and sends a GET request to the YouTube API to retrieve that video’s title and description in your channel’s default language for the next steps.