Turn this week's trending searches into WordPress drafts

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

SHEET_ID = "your-spreadsheet-id"
NICHE = "home workout"
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):
    trends = http.get("https://serpapi.com/search", params={"engine": "google_trends", "q": NICHE, "data_type": "RELATED_QUERIES", "geo": "US",
                                                            "api_key": credentials.secret("SERPAPI_API_KEY")}).json()
    rising = [q["query"] for q in trends.get("related_queries", {}).get("rising", [])[:10]]
    if not rising:
        return {"trends": 0}
    sheets = build("sheets", "v4", credentials=Credentials(credentials.connection("google", "work")), cache_discovery=False).spreadsheets()
    sheets.values().append(spreadsheetId=SHEET_ID, range="Trends!A:B", valueInputOption="RAW",
                           body={"values": [[date.today().isoformat(), q] for q in rising]}).execute()
    for topic in rising[:3]:
        body = ai.generate(f"Write a helpful 800-word blog post in HTML about '{topic}' for a {NICHE} audience, with H2 headings.", max_output_tokens=1600).text
        wp("POST", "posts", json={"title": topic.capitalize(), "content": body, "status": "draft"})
    return {"trends": len(rising), "drafts": min(3, len(rising))}