Write researched blog drafts for topics marked ready

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

SHEET_ID = "your-spreadsheet-id"

def sonar(prompt):
    r = http.post("https://api.perplexity.ai/chat/completions", headers={"Authorization": f"Bearer {credentials.secret('PERPLEXITY_API_KEY')}"},
                  json={"model": "sonar", "messages": [{"role": "user", "content": prompt}]}, timeout=90).json()
    return r["choices"][0]["message"]["content"], [s["url"] for s in r.get("search_results", [])]

@on_trigger
def run(event):
    sheets = build("sheets", "v4", credentials=Credentials(credentials.connection("google", "work")),
                   cache_discovery=False).spreadsheets().values()
    rows = sheets.get(spreadsheetId=SHEET_ID, range="Blog!A2:E").execute().get("values", [])
    ready = [(i + 2, r) for i, r in enumerate(rows) if len(r) >= 3 and r[2].lower() == "ready"]
    report_fetched(len(ready))
    if not ready:
        return {"ready": 0}
    for n, (topic, keyword, *_) in ready:
        facts, links = sonar(f"Research {topic} for a blog article: key facts, figures, examples and common questions.")
        article = ai.generate(f"Write a 1,000-word blog article about '{topic}' targeting the phrase '{keyword}'. Title, meta "
                              f"description, H2 headings, practical tone. Use only these facts:\n{facts[:4000]}",
                              max_output_tokens=2000).text
        sheets.update(spreadsheetId=SHEET_ID, range=f"Blog!C{n}:E{n}", valueInputOption="RAW",
                      body={"values": [["drafted", article.strip(), "\n".join(links)]]}).execute()
    return {"drafted": len(ready)}