Turn sheet briefs into AI drafts reviewed in Teams

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"
TEAM_ID, CHANNEL_ID = "your-team-id", "your-channel-id"
STYLE = "Plain, friendly, specific. No buzzwords. Job ads under 300 words, posts under 60."

@on_trigger
def run(event):
    values = build("sheets", "v4", credentials=Credentials(credentials.connection("google", "work")), cache_discovery=False).spreadsheets().values()
    rows = values.get(spreadsheetId=SHEET_ID, range="Briefs!A2:C").execute().get("values", [])
    new = [(n, r) for n, r in enumerate(rows, start=2) if len(r) >= 2 and r[1].strip() and len(r) < 3]
    report_fetched(len(new))
    if not new:
        return {"new": 0}
    for n, (kind, brief) in new[:10]:
        try:
            draft = ai.generate(f"Write a {kind}.\nBrief: {brief[:2000]}", system=STYLE, max_output_tokens=700).text
        except ai.AIError:
            break
        values.update(spreadsheetId=SHEET_ID, range=f"Briefs!C{n}", valueInputOption="RAW", body={"values": [[draft]]}).execute()
        http.post(f"https://graph.microsoft.com/v1.0/teams/{TEAM_ID}/channels/{CHANNEL_ID}/messages",
                  headers={"Authorization": f"Bearer {credentials.connection('microsoft', 'work')}"},
                  json={"body": {"contentType": "text", "content": f"Draft for review ({kind}, row {n}):\n\n{draft}"}})
    return {"new": len(new)}