Write a weekly report Doc from your numbers and post it to Slack

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

SHEET_ID = "your-spreadsheet-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="Metrics!A1:Z").execute().get("values", [])
    header, prev, last = rows[0], rows[-2], rows[-1]
    table = "\n".join(f"{h}: {p} -> {l}" for h, p, l in zip(header, prev, last))
    try:
        report = ai.generate(table, system="Write a short weekly report: summary, what changed and possible reasons, next steps.", max_output_tokens=900).text
        points = ai.generate(report, system="Give 3 one-line key points.", max_output_tokens=150).text
    except ai.AIError:
        report = points = table
    docs = build("docs", "v1", credentials=creds, cache_discovery=False).documents()
    doc = docs.create(body={"title": f"Weekly report - week of {last[0]}"}).execute()
    docs.batchUpdate(documentId=doc["documentId"], body={"requests": [{"insertText": {"location": {"index": 1}, "text": report}}]}).execute()
    notify.slack(f"📊 Week of {last[0]}\n{points}\nhttps://docs.google.com/document/d/{doc['documentId']}", channel="#marketing")
    return {"doc": doc["documentId"]}