Easily Update YouTube Titles and Descriptions in Multiple Languages: GAS101
Introduction
If you're looking for a free and efficient way to modify the titles and descriptions of your YouTube videos in multiple languages, you've come to the right place. I've created a Google Sheets project that can help you streamline the process of updating or uploading titles and descriptions. This project utilizes the power of Google Apps Script and the YouTube API to make the experience as seamless and efficient as possible.
YouTube
If you're a visual learner and prefer watching video instructions, I highly recommend checking out these videos.
Instructions (4 Steps)
To establish your own project, adhere to the following steps:
Step 1
Utilizing the provided link, you can create a duplicate of my project on your Google Drive.
Step 2
To fulfill the authorization requirement, navigate to the copied Google Sheets document and select any button located within the tab “YouTube”.
* Check the authorization guide if unfamiliar with the process.
A Complete Guide to Authorize GAS Project
Step 3
In the "Settings" tab, modify the languages for your videos. Separate them with commas. You can find the language names in the "Languages" tab.
Step 4
Within the "YouTube" tab, you have the ability to input a video ID or URL from your YouTube channel into cell C4. By clicking the "Fetch Subtitles" button, you will retrieve the current titles and descriptions for the video in the languages specified in the "Settings" tab.
You can modify the titles and descriptions for each language by clicking the "Update Subtitles" button. This allows you to upload the updated titles and descriptions to the video. Additionally, you have the option to update or set the primary language of the video in cell C6.
Typically, I start by creating the title and description in the primary language. Then, I use the "Google Translate" button to generate Google Translate formulas for the titles and descriptions in other languages.
Other Features
- Fetch languages - In the "Languages" tab, ensure that the list of languages is current and up-to-date.
GoogleAppsScript Playlist (Subscribe for New Projects)
Links
Hire me on Upwork Donate (PayPal) YouTube Github Twitter / X Instagram
Comments
Post a Comment