Find people asking for tools like yours and list them 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"
SUPABASE = "https://your-project.supabase.co/rest/v1"

def sb(method, path, **kw):
    key = credentials.secret("SUPABASE_KEY")
    r = http.request(method, f"{SUPABASE}/{path}", **kw, headers={"apikey": key, "Authorization": f"Bearer {key}", "Prefer": "return=representation,resolution=merge-duplicates"})
    return r.raise_for_status() or (r.json() if r.content else None)

@on_trigger
def run(event):
    posts = [c["data"] for c in http.get("https://www.reddit.com/search.json", params={"q": '"looking for" invoicing tool', "sort": "new", "t": "day"},
             headers={"User-Agent": "northwind-leads/1.0"}).json()["data"]["children"]]
    known = {r["id"] for r in sb("GET", "leads?select=id&id=in.(" + ",".join(p["id"] for p in posts) + ")")} if posts else set()
    new = [p for p in posts if p["id"] not in known]
    report_fetched(len(new))
    if not new:
        return {"summary": "Nothing new"}
    listing = "\n".join(f"{i}. {p['title']} — {p['selftext'][:300]}" for i, p in enumerate(new))
    scores = ai.generate(f"Score each post 1-10 for needing an invoicing tool. One integer per line.\n{listing}", max_output_tokens=10 * len(new)).text.split()
    rows = [{"id": p["id"], "title": p["title"], "url": "https://reddit.com" + p["permalink"], "score": int(s)} for p, s in zip(new, scores)]
    sb("POST", "leads", json=rows)
    good = [[r["score"], r["title"], r["url"]] for r in rows if r["score"] >= 6]
    if good:
        build("sheets", "v4", credentials=Credentials(credentials.connection("google", "work")), cache_discovery=False).spreadsheets().values().append(spreadsheetId=SHEET_ID, range="Leads!A:C", valueInputOption="RAW", body={"values": good}).execute()
    return {"new": len(rows), "listed": len(good)}