Add FAQ sections to WordPress pages listed in a sheet

import re
from google.oauth2.credentials import Credentials
from googleapiclient.discovery import build
from clickruntime import on_trigger, credentials, http, 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):
    sheets = build("sheets", "v4", credentials=Credentials(credentials.connection("google", "work")), cache_discovery=False).spreadsheets()
    rows = sheets.values().get(spreadsheetId=SHEET_ID, range="FAQ!A2:B").execute().get("values", [])
    todo = [(i + 2, r[0]) for i, r in enumerate(rows) if r and r[0] and len(r) < 2][:5]
    report_fetched(len(todo))
    if not todo:
        return {"done": 0}
    for row, url in todo:
        page = wp("GET", "pages", params={"slug": url.rstrip("/").split("/")[-1], "context": "edit"})[0]
        text = re.sub("<[^>]+>", " ", page["content"]["raw"])[:4000]
        faq_html = ai.generate(f"Page content:\n{text}\n\nWrite 5 FAQs answered by this content as HTML (h3 + p), then a FAQPage JSON-LD script tag.", max_output_tokens=1000).text
        wp("POST", f"pages/{page['id']}", json={"content": page["content"]["raw"] + "\n<h2>Frequently asked questions</h2>\n" + faq_html})
        sheets.values().update(spreadsheetId=SHEET_ID, range=f"FAQ!B{row}", valueInputOption="RAW", body={"values": [["done"]]}).execute()
    return {"done": len(todo)}