Write SEO content briefs for new keywords in a sheet

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"

@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: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 {"briefs": 0}
    for row, keyword in todo:
        res = http.get("https://serpapi.com/search", params={"engine": "google", "q": keyword, "num": 10, "gl": "us",
                                                             "api_key": credentials.secret("SERPAPI_API_KEY")}).json()
        top = "\n".join(f"{r['position']}. {r['title']} - {r.get('snippet', '')}" for r in res.get("organic_results", [])[:10])
        paa = "\n".join(q["question"] for q in res.get("related_questions", []))
        brief = ai.generate(f"Keyword: {keyword}\nTop results:\n{top}\nPeople also ask:\n{paa}",
                            system="Write a content brief: search intent, suggested title, H2 outline, questions to answer, what top pages share.", max_output_tokens=700).text
        sheets.values().update(spreadsheetId=SHEET_ID, range=f"SEO!B{row}", valueInputOption="RAW", body={"values": [[brief]]}).execute()
    return {"briefs": len(todo)}