Turn a keyword sheet into Webflow blog 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"
COLLECTION_ID = "your-collection-id"

def webflow(method, path, **kw):
    r = http.request(method, f"https://api.webflow.com/v2/collections/{COLLECTION_ID}/items{path}",
                     headers={"Authorization": f"Bearer {credentials.secret('WEBFLOW_API_TOKEN')}"}, **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="SEO!A2:C").execute().get("values", [])
    nxt = next(((i + 2, r[0]) for i, r in enumerate(rows) if len(r) > 1 and r[1] == "pending"), None)
    if not nxt:
        return {"drafted": False}
    row, keyword = nxt
    schema = {"type": "object", "properties": {k: {"type": "string"} for k in ["title", "slug", "summary", "body_html"]}, "required": ["title", "slug", "summary", "body_html"]}
    post = ai.generate(f"Write an SEO blog post targeting '{keyword}', 900-1200 words, H2 headings, HTML body.", json_schema=schema, max_output_tokens=2048).json
    item = webflow("POST", "", json={"isDraft": True, "fieldData": {"name": post["title"], "slug": post["slug"], "post-summary": post["summary"], "post-body": post["body_html"]}})
    link = f"https://webflow.com/dashboard/sites/your-site/cms/{COLLECTION_ID}/{item['id']}"
    sheets.values().update(spreadsheetId=SHEET_ID, range=f"SEO!B{row}:C{row}", valueInputOption="RAW", body={"values": [["drafted", link]]}).execute()
    notify.slack(f"📝 New Webflow draft: {post['title']} ({keyword})\n{link}", channel="#marketing")
    return {"drafted": keyword}