Job description
How should the script work?
1. run in Google Apps Script
2. choose what we want to do:
(a) download a list of videos from the youtube channel (there must be an option to indicate a specific youtube video and/or the date of publication of the video in the form of a range, for example, 01.06 to 30.06.2024)
b) another function checks if the video has any translations other than Polish, if there are any it saves the value, additionally saves the original title and description to 2 separate columns in the Google Sheets file), in addition, for languages where there are no translations it adds a column with an empty value according to the scheme: language_title, language_description e.g. EN_title, EN_description
(c) another function translates the title and description of the video from Polish to all available on youtube and at the same time supported by the Google Translation API, the results of the translations are saved to a file to the appropriate column
(d) the ability to update videos for translated titles and descriptions, similar to point C.