Check each week whether AI search answers mention your brand

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

SHEET_ID, BRAND = "your-spreadsheet-id", "Northwind"

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()
    questions = [r[0] for r in sheets.get(spreadsheetId=SHEET_ID, range="Questions!A2:A").execute().get("values", []) if r]
    rows = []
    for q in questions:
        answer, links = sonar(q)
        mentioned = BRAND.lower() in answer.lower()
        mood = ai.generate(f"How does this answer describe {BRAND}? One word: positive, neutral or negative.\n{answer[:3000]}",
                           max_output_tokens=5).text.strip().lower() if mentioned else "not mentioned"
        rows.append([date.today().isoformat(), q, "yes" if mentioned else "no", mood, "\n".join(links[:5])])
    sheets.append(spreadsheetId=SHEET_ID, range="Visibility!A:E", valueInputOption="RAW", body={"values": rows}).execute()
    hits = sum(r[2] == "yes" for r in rows)
    notify.email_me(f"{BRAND} mentioned in {hits} of {len(rows)} answers", "\n".join(f"{r[2]:>3} · {r[3]} · {r[1]}" for r in rows))
    return {"mentioned": hits, "questions": len(rows)}