Turn event feedback into a report doc and Slack highlights

from google.oauth2.credentials import Credentials
from googleapiclient.discovery import build
from clickruntime import on_trigger, credentials, state, ai, notify

SHEET_ID = "your-responses-sheet-id"

@on_trigger
def run(event):
    creds = Credentials(credentials.connection("google", "work"))
    rows = build("sheets", "v4", credentials=creds, cache_discovery=False).spreadsheets().values().get(
        spreadsheetId=SHEET_ID, range="Form Responses 1!A2:Z").execute().get("values", [])
    done = state.get("done") or 0
    new = rows[done:]
    if not new:
        return {"responses": 0}
    lines = "\n".join(" | ".join(r[1:])[:400] for r in new[:300])
    report = ai.generate(f"Analyse this event feedback. Write a report with themes, what worked, what to fix and quotes without names:\n{lines}", max_output_tokens=1500).text
    top = ai.generate(f"Give the 3 most important insights from this report as 3 short bullet lines:\n{report}", max_output_tokens=150).text
    docs = build("docs", "v1", credentials=creds, cache_discovery=False).documents()
    doc = docs.create(body={"title": "Event feedback report"}).execute()
    docs.batchUpdate(documentId=doc["documentId"], body={"requests": [{"insertText": {"location": {"index": 1}, "text": report}}]}).execute()
    notify.slack(f"Feedback from {len(new)} responses:\n{top}\nhttps://docs.google.com/document/d/{doc['documentId']}", channel="#events")
    state.set("done", len(rows))
    return {"responses": len(new)}