1. Automated Scanning:
- The workflow should automatically scan the root folder in Google Drive (Account B) every hour.
- It should detect newly created subfolders within the root folder. Each new subfolder represents a new video to be uploaded to YouTube.
2. Extract Video and Information:
- For each new subfolder detected, the workflow should:
- Extract the video file (in .mp4 format).
- Extract the thumbnail image (in image file format, typically
.jpg
or.png
). - Extract metadata from a Google Sheet that contains:
- Title of the video.
- Description of the video.
- Thumbnail link (URL or file path).
3. Scheduled Uploads:
- The workflow should upload the extracted video to YouTube (Account C) and schedule it for release at five fixed times during the day:
- 08:00 AM
- 12:00 PM
- 08:00 PM
- 09:15 PM
- 10:00 PM
- If there are more than four videos detected in a single day:
- The excess videos should be rescheduled to the next available time slot on the following day.