Work through a content queue in Sheets and post results to Discord

from google.oauth2.credentials import Credentials
from googleapiclient.discovery import build
from clickruntime import on_trigger, credentials, http, ai

SHEET_ID = "your-spreadsheet-id"
CHANNEL_ID = "your-discord-channel-id"

@on_trigger
def run(event):
    sheets = build("sheets", "v4", credentials=Credentials(credentials.connection("google", "work")), cache_discovery=False)
    rows = sheets.spreadsheets().values().get(spreadsheetId=SHEET_ID, range="Content!A2:E").execute().get("values", [])
    for i, row in enumerate(rows, start=2):
        row = (row + [""] * 5)[:5]
        topic, platform, notes, status = row[0], row[1], row[2], row[3]
        if status.strip().lower() != "ready":
            continue
        draft = ai.generate(f"Write a {platform} script or caption.\nTopic: {topic}\nNotes: {notes[:1500]}",
                            system="Friendly, direct, no hashtags unless asked.", max_output_tokens=600).text.strip()
        sheets.spreadsheets().values().update(spreadsheetId=SHEET_ID, range=f"Content!D{i}:E{i}", valueInputOption="RAW",
                                              body={"values": [["done", draft]]}).execute()
        http.post(f"https://discord.com/api/v10/channels/{CHANNEL_ID}/messages",
                  headers={"Authorization": f"Bot {credentials.secret('DISCORD_BOT_TOKEN')}"},
                  json={"content": f"**{topic}** ({platform})\n{draft}"[:2000]})
        return {"drafted": topic}
    return {"drafted": None}