Clone

💰 Business Value

Vollautomatisierter YouTube-Bot: Lädt Videos herunter, personalisiert Metadaten per MySQL, ersetzt Namen und lädt mit Thumbnail über die Google YouTube Data API v3 wieder hoch.

💻 Code-Einblicke

Ein Blick unter die Haube des YouTube-Reupload-Bots:

📥 Video-Download & MySQL-Queue

import pymysql
from pytube import YouTube

def routine():
    conn = pymysql.connect(user=config.user, password=config.password,
                           host=config.host, database=config.database)
    cursor = conn.cursor()

    cursor.execute("SELECT ID, VidID, Name FROM videos WHERE reup=0 AND vidok=1")
    rows = cursor.fetchall()
    row = random.choice(rows)
    IDReup, video_id, name = row[0], row[1], row[2]

    cursor.execute(f"UPDATE videos SET reup=true WHERE ID={IDReup}")
    conn.commit()

    url = f"https://www.youtube.com/watch?v={video_id}"
    yt = YouTube(url)
    video = yt.streams.filter(file_extension='mp4', progressive=True)
    video.get_highest_resolution().download(filename=config.base_dir+"video.mp4")

🔐 Google OAuth & YouTube API Upload

from googleapiclient.discovery import build
from google_auth_oauthlib.flow import InstalledAppFlow
from google.oauth2.credentials import Credentials

SCOPES = ["https://www.googleapis.com/auth/youtube.upload"]

creds = None
if os.path.exists(TOKEN_NAME):
    creds = Credentials.from_authorized_user_file(TOKEN_NAME, SCOPES)
if not creds or not creds.valid:
    if creds and creds.expired and creds.refresh_token:
        creds.refresh(Request())
    else:
        flow = InstalledAppFlow.from_client_secrets_file(client_secrets_file, SCOPES)
        creds = flow.run_console()

googleAPI = build('youtube', 'v3', credentials=creds)

📤 Upload mit Thumbnail-Set

from googleapiclient.http import MediaFileUpload

def uploadYtvid(VIDEO_FILE_NAME='', title='', description='', tags=[], googleAPI=None):
    request_body = {
        'snippet': {
            'categoryId': 10, 'title': title,
            'description': description, 'tags': tags
        },
        'status': {'privacyStatus': 'public', 'selfDeclaredMadeForKids': False},
        'notifySubscribers': False
    }

    mediaFile = MediaFileUpload(VIDEO_FILE_NAME, chunksize=-1, resumable=True)
    response_upload = googleAPI.videos().insert(
        part='snippet,status', body=request_body, media_body=mediaFile
    ).execute()

    googleAPI.thumbnails().set(
        videoId=response_upload.get('id'),
        media_body=MediaFileUpload(base_dir+'thumbnail.jpg')
    ).execute()

⚙️ Funktionsweise

Der automatisierte Reupload-Prozess Schritt für Schritt.

🚀 Gebaut mit Vibecoding

🎯 Strategische Erkenntnisse

Jedes Projekt liefert wertvolle Einsichten — technisch wie strategisch. Diese Learnings fließen direkt in Folgeprojekte ein.