Log daily YouTube channel stats to Google Sheets

from google.oauth2.credentials import Credentials
from googleapiclient.discovery import build
from datetime import date
from clickruntime import on_trigger, credentials, state

CHANNEL_IDS = ["UCxxxxxxxxxxxxxxxxxxxxxx", "UCyyyyyyyyyyyyyyyyyyyyyy", "UCzzzzzzzzzzzzzzzzzzzzzz"]
SHEET_ID = "your-spreadsheet-id"

@on_trigger
def run(event):
    creds = Credentials(credentials.connection("google", "work"))
    yt = build("youtube", "v3", credentials=creds, cache_discovery=False)
    items = yt.channels().list(part="snippet,statistics", id=",".join(CHANNEL_IDS)).execute().get("items", [])
    prev, rows, today = state.get("prev") or {}, [], date.today().isoformat()
    for c in items:
        s = c["statistics"]
        now = [int(s.get("subscriberCount", 0)), int(s.get("viewCount", 0)), int(s.get("videoCount", 0))]
        before = prev.get(c["id"], now)
        rows.append([today, c["snippet"]["title"], now[0], now[0] - before[0], now[1], now[1] - before[1], now[2], now[2] - before[2]])
        prev[c["id"]] = now
    build("sheets", "v4", credentials=creds, cache_discovery=False).spreadsheets().values().append(
        spreadsheetId=SHEET_ID, range="Channel stats!A:H", valueInputOption="RAW", body={"values": rows}).execute()
    state.set("prev", prev)
    return {"channels": len(rows)}