Keep your YouTube titles and tags in line with a sheet

from google.oauth2.credentials import Credentials
from googleapiclient.discovery import build
from datetime import date
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, yt = api("sheets", "v4").spreadsheets().values(), api("youtube", "v3")
    rules = dict(r for r in sheet.get(spreadsheetId=SHEET_ID, range="Rules!A2:B").execute().get("values", []) if len(r) == 2)
    tags, suffix = [t.strip() for t in rules.get("required_tags", "").split(",") if t.strip()], rules.get("title_suffix", "")
    hide = {r[0] for r in sheet.get(spreadsheetId=SHEET_ID, range="Hide!A2:A").execute().get("values", []) if r}
    uploads = yt.channels().list(part="contentDetails", mine=True).execute()["items"][0]["contentDetails"]["relatedPlaylists"]["uploads"]
    ids = [i["contentDetails"]["videoId"] for i in yt.playlistItems().list(part="contentDetails", playlistId=uploads, maxResults=50).execute()["items"]]
    log = []
    for v in yt.videos().list(part="snippet,status", id=",".join(ids)).execute()["items"]:
        s, st, before = v["snippet"], v["status"], v["snippet"]["title"]
        s["tags"] = sorted(set(s.get("tags", [])) | set(tags))
        s["title"] = before if before.endswith(suffix) else f"{before}{suffix}"[:100]
        st["privacyStatus"] = "unlisted" if v["id"] in hide else st["privacyStatus"]
        if s["title"] != before or set(tags) - set(v["snippet"].get("tags", [])) or v["id"] in hide:
            yt.videos().update(part="snippet,status", body={"id": v["id"], "snippet": {k: s[k] for k in ("title", "description", "tags", "categoryId")}, "status": st}).execute()
            log.append([date.today().isoformat(), v["id"], before, s["title"], st["privacyStatus"]])
    if log:
        sheet.append(spreadsheetId=SHEET_ID, range="Log!A:E", valueInputOption="RAW", body={"values": log}).execute()
        notify.slack(f"Updated {len(log)} videos to match the Metadata sheet.", channel="#content")
    return {"updated": len(log)}