Write social captions for new WordPress posts in a sheet

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

SHEET_ID = "your-spreadsheet-id"
WP = "https://blog.example.com/wp-json/wp/v2"

def wp(method, path, **kw):
    r = http.request(method, f"{WP}/{path}", auth=(credentials.secret("WP_USER"), credentials.secret("WP_APP_PASSWORD")), **kw)
    r.raise_for_status()
    return r.json()

@on_trigger
def run(event):
    after = state.get("after") or datetime.now(timezone.utc).strftime("%Y-%m-%dT%H:%M:%S")
    posts = wp("GET", "posts", params={"after": after, "status": "publish", "orderby": "date", "order": "asc", "_fields": "date,link,title,excerpt"})
    report_fetched(len(posts))
    if not posts:
        return {"new": 0}
    schema = {"type": "object", "properties": {k: {"type": "string"} for k in ["linkedin", "x", "facebook"]}, "required": ["linkedin", "x", "facebook"]}
    rows = []
    for p in posts:
        c = ai.generate(f"Title: {p['title']['rendered']}\nExcerpt: {p['excerpt']['rendered'][:600]}\nWrite captions for LinkedIn, X (under 240 chars) and Facebook.", json_schema=schema, max_output_tokens=400).json
        rows.append([p["date"][:10], p["title"]["rendered"], p["link"], c["linkedin"], c["x"], c["facebook"]])
    sheets = build("sheets", "v4", credentials=Credentials(credentials.connection("google", "work")), cache_discovery=False).spreadsheets()
    sheets.values().append(spreadsheetId=SHEET_ID, range="Social queue!A:F", valueInputOption="RAW", body={"values": rows}).execute()
    state.set("after", posts[-1]["date"])
    return {"new": len(posts)}