Upload Drive videos to YouTube at the time in your sheet

import io
from google.oauth2.credentials import Credentials
from googleapiclient.discovery import build
from googleapiclient.http import MediaIoBaseUpload
from datetime import datetime, timezone
from clickruntime import on_trigger, credentials, notify

def api(name, version):
    return build(name, version, credentials=Credentials(credentials.connection("google", "work")), cache_discovery=False)

SHEET_ID = "your-spreadsheet-id"

@on_trigger
def run(event):
    sheet = api("sheets", "v4").spreadsheets().values()
    rows = sheet.get(spreadsheetId=SHEET_ID, range="Upload Schedule!A2:F").execute().get("values", [])
    now = datetime.now(timezone.utc).isoformat()
    done = 0
    for n, r in enumerate(rows, start=2):
        if len(r) < 4 or r[3] > now or (len(r) > 4 and r[4] == "uploaded"):
            continue
        title, description, file_id = r[0], r[1], r[2]
        data = api("drive", "v3").files().get_media(fileId=file_id).execute()
        video = api("youtube", "v3").videos().insert(part="snippet,status", body={"snippet": {"title": title, "description": description},
                "status": {"privacyStatus": "public"}}, media_body=MediaIoBaseUpload(io.BytesIO(data), mimetype="video/mp4", resumable=True)).execute()
        sheet.update(spreadsheetId=SHEET_ID, range=f"Upload Schedule!E{n}:F{n}", valueInputOption="RAW",
                     body={"values": [["uploaded", f"https://youtu.be/{video['id']}"]]}).execute()
        notify.email_me(f"Uploaded: {title}", f"https://youtu.be/{video['id']}")
        done += 1
    return {"uploaded": done}