Get a weekly email summarising your Zendesk tickets

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

ZD, AGENT = "https://yourcompany.zendesk.com/api/v2", "you@yourcompany.com"

def zd(method, path, **kw):
    r = http.request(method, ZD + path, auth=(f"{AGENT}/token", credentials.secret("ZENDESK_API_TOKEN")), **kw)
    return r.raise_for_status() or (r.json() if r.content else None)


def send_gmail(to, subject, text):
    raw = base64.urlsafe_b64encode(f"To: {to}\r\nSubject: {subject}\r\nContent-Type: text/plain; charset=utf-8\r\n\r\n{text}".encode()).decode()
    build("gmail", "v1", credentials=Credentials(credentials.connection("google", "work")), cache_discovery=False).users().messages().send(userId="me", body={"raw": raw}).execute()

@on_trigger
def run(event):
    since = (date.today() - timedelta(days=7)).isoformat()
    tickets = zd("GET", "/search.json", params={"query": f"type:ticket created>={since}"})["results"]
    if not tickets:
        return {"tickets": 0}
    lines = "\n".join(f"#{t['id']} {t['subject']}: {t['description'][:250]}" for t in tickets[:300])
    summary = ai.generate(lines, system="Summarise these support tickets for a founder: top themes with counts, overall sentiment, "
                          "and up to 3 unusual tickets by number. Plain text, under 250 words.", max_output_tokens=700).text
    send_gmail("you@yourcompany.com", f"Support this week: {len(tickets)} tickets", summary)
    return {"tickets": len(tickets)}