Post to X from a spreadsheet queue

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

SHEET_ID = "your-spreadsheet-id"

@on_trigger
def run(event):
    if not 8 <= datetime.now(timezone.utc).hour < 20:
        return {"posted": False}
    sheets = build("sheets", "v4", credentials=Credentials(credentials.connection("google", "work")), cache_discovery=False).spreadsheets()
    rows = sheets.values().get(spreadsheetId=SHEET_ID, range="Queue!A2:C").execute().get("values", [])
    n = next((i for i, r in enumerate(rows) if r and r[0] and len(r) < 3), None)
    if n is None:
        return {"posted": False}
    text = rows[n][0]
    if len(rows[n]) > 1 and rows[n][1].lower() == "idea":
        text = ai.generate(f"Turn this idea into one X post under 260 characters: {text}", max_output_tokens=100).text.strip()
    resp = http.post("https://api.x.com/2/tweets", headers={"Authorization": "Bearer " + credentials.connection("x", "main")},
                     json={"text": text[:280]})
    resp.raise_for_status()
    sheets.values().update(spreadsheetId=SHEET_ID, range=f"Queue!C{n + 2}", valueInputOption="RAW",
                           body={"values": [[resp.json()["data"]["id"]]]}).execute()
    return {"posted": True}