This n8n workflow automates the process of updating YouTube video metadata with localized content based on language data stored in Google Sheets. It regularly checks for new videos, fetches their details, generates localized descriptions using AI, and updates metadata accordingly.
The workflow begins with a Schedule Trigger that initiates the process at predefined intervals. It retrieves a list of languages from a Google Sheet and processes each language sequentially, extracting relevant video information and video URLs. For each video, it fetches the latest video data from YouTube and compares the current video ID with the latest recorded one to identify new videos.
If a new video is found, the workflow inserts its info into Google Sheets. It then employs an AI language model (Google Gemini’s Chat Model) to generate localized descriptions or content in different languages. These localized descriptions are then used to update the video’s metadata via HTTP requests. Throughout the process, status updates are written back to Google Sheets to track success or failure, and sticky notes are used for internal notes or debugging.
This workflow is highly useful for content creators or managers who need to regularly update video metadata for multiple languages, ensuring videos are accessible and properly localized without manual effort. It automates repetitive tasks, improves localization workflow efficiency, and maintains accurate video records.
Reviews
There are no reviews yet.