Turn this week's saved links into a newsletter draft in Notion

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

SHEET_ID, NOTION_DB = "your-spreadsheet-id", "your-database-id"

@on_trigger
def run(event):
    sheet = build("sheets", "v4", credentials=Credentials(credentials.connection("google", "work")), cache_discovery=False).spreadsheets().values()
    rows = sheet.get(spreadsheetId=SHEET_ID, range="Links!A2:D").execute().get("values", [])
    fresh = [(i + 2, r) for i, r in enumerate(rows) if len(r) >= 2 and (len(r) < 4 or r[3] != "used")]
    if not fresh:
        return {"items": 0}
    items = "\n".join(f"- {r[1]} ({r[0]}): {r[2] if len(r) > 2 else ''}" for _, r in fresh)
    draft = ai.generate(f"Write a weekly newsletter draft with an intro and short sections from these links and notes:\n{items}", max_output_tokens=1800).text
    http.post("https://api.notion.com/v1/pages", headers={"Authorization": f"Bearer {credentials.connection('notion', 'work')}", "Notion-Version": "2022-06-28"},
              json={"parent": {"database_id": NOTION_DB}, "properties": {"Name": {"title": [{"text": {"content": f"Newsletter {date.today()}"}}]}},
                    "children": [{"paragraph": {"rich_text": [{"text": {"content": p[:1900]}}]}} for p in draft.split("\n\n") if p.strip()]})
    sheet.batchUpdate(spreadsheetId=SHEET_ID, body={"valueInputOption": "RAW",
                      "data": [{"range": f"Links!D{n}", "values": [["used"]]} for n, _ in fresh]}).execute()
    return {"items": len(fresh)}