Turn trending Reddit topics into content ideas

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

SUBS, SHEET_ID, RANGE = ["personalfinance", "financialindependence"], "your-spreadsheet-id", "Ideas!A:D"
SCHEMA = {"type": "object", "properties": {"ideas": {"type": "array", "items": {"type": "object",
          "properties": {"n": {"type": "integer"}, "idea": {"type": "string"}, "hook": {"type": "string"}}}}}}

def reddit(path, **params):
    headers = {"Authorization": "Bearer " + credentials.connection("reddit", "main"), "User-Agent": "clickruntime/1.0"}
    return [c["data"] for c in http.get(f"https://oauth.reddit.com{path}", headers=headers, params=params).json()["data"]["children"]]

def append_rows(rows):
    sheets = build("sheets", "v4", credentials=Credentials(credentials.connection("google", "work")), cache_discovery=False)
    sheets.spreadsheets().values().append(spreadsheetId=SHEET_ID, range=RANGE, valueInputOption="RAW", body={"values": rows}).execute()

@on_trigger
def run(event):
    posts = [p for s in SUBS for p in reddit(f"/r/{s}/top", t="day", limit=15)]
    listing = "\n".join(f"{i}. {p['title']} ({p['score']} upvotes, {p['num_comments']} comments)" for i, p in enumerate(posts))
    ideas = ai.generate(listing, json_schema=SCHEMA, max_output_tokens=600,
                        system="Pick 3 discussions and suggest a content idea and a one-line hook for a personal finance blog.").json["ideas"]
    rows = [[date.today().isoformat(), i["idea"], i["hook"], "https://reddit.com" + posts[i["n"]]["permalink"]]
            for i in ideas if 0 <= i["n"] < len(posts)]
    append_rows(rows)
    return {"ideas": len(rows)}