Turn a blog plan sheet into WordPress drafts

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

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):
    sheets = build("sheets", "v4", credentials=Credentials(credentials.connection("google", "work")), cache_discovery=False).spreadsheets()
    rows = sheets.values().get(spreadsheetId=SHEET_ID, range="Blog plan!A2:B").execute().get("values", [])
    nxt = next(((i + 2, r[0]) for i, r in enumerate(rows) if r and r[0] and len(r) < 2), None)
    if not nxt:
        return {"drafted": False}
    row, topic = nxt
    schema = {"type": "object", "properties": {k: {"type": "string"} for k in ["title", "meta_description", "body_html"]}, "required": ["title", "meta_description", "body_html"]}
    art = ai.generate(f"Write an SEO article about '{topic}', about 1000 words, H2 headings, HTML body.", json_schema=schema, max_output_tokens=2048).json
    post = wp("POST", "posts", json={"title": art["title"], "content": art["body_html"], "excerpt": art["meta_description"], "status": "draft"})
    link = f"https://blog.example.com/wp-admin/post.php?post={post['id']}&action=edit"
    sheets.values().update(spreadsheetId=SHEET_ID, range=f"Blog plan!B{row}", valueInputOption="RAW", body={"values": [[link]]}).execute()
    notify.email_me(f"Draft ready: {art['title']}", link)
    return {"drafted": topic}