Add FAQ sections to Webflow 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"
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="Pages!A2:C").execute().get("values", [])
    ready = [(i + 2, r[1]) for i, r in enumerate(rows) if len(r) > 2 and r[2].lower() == "ready"]
    report_fetched(len(ready))
    if not ready:
        return {"done": 0}
    for row, item_id in ready:
        item = webflow("GET", f"/{item_id}")["fieldData"]
        content = re.sub("<[^>]+>", " ", item.get("post-body", ""))[:4000]
        faqs = ai.generate(f"Page: {item['name']}\n{content}\nWrite 5 FAQs answered by this content as HTML: <h3>question</h3><p>answer</p>.", max_output_tokens=800).text
        webflow("PATCH", f"/{item_id}", json={"fieldData": {"faq": faqs}})
        sheets.values().update(spreadsheetId=SHEET_ID, range=f"Pages!C{row}", valueInputOption="RAW", body={"values": [["done"]]}).execute()
    return {"done": len(ready)}