Keep a Google Sheet of your Zendesk tickets

from google.oauth2.credentials import Credentials
from googleapiclient.discovery import build
from clickruntime import on_trigger, report_fetched, http, credentials, state

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)


sheets = lambda: build("sheets", "v4", credentials=Credentials(credentials.connection("google", "work")), cache_discovery=False).spreadsheets()
SHEET_ID = "your-spreadsheet-id"

@on_trigger
def run(event):
    page = zd("GET", "/incremental/tickets/cursor.json", params={"cursor": state.get("cursor")} if state.get("cursor") else {"start_time": 0})
    tickets = page["tickets"]
    report_fetched(len(tickets))
    if not tickets:
        return {"summary": "No changes"}
    s, new_rows, updates = sheets(), [], []
    ids = [r[0] if r else "" for r in s.values().get(spreadsheetId=SHEET_ID, range="Tickets!A2:A").execute().get("values", [])]
    for t in tickets:
        row = [str(t["id"]), t["subject"], t["status"], t["priority"] or "", ", ".join(t["tags"]), t["created_at"], t["updated_at"]]
        (updates.append({"range": f"Tickets!A{ids.index(row[0]) + 2}", "values": [row]}) if row[0] in ids else new_rows.append(row))
    if updates:
        s.values().batchUpdate(spreadsheetId=SHEET_ID, body={"valueInputOption": "RAW", "data": updates}).execute()
    if new_rows:
        s.values().append(spreadsheetId=SHEET_ID, range="Tickets!A:G", valueInputOption="RAW", body={"values": new_rows}).execute()
    state.set("cursor", page["after_cursor"])
    return {"updated": len(updates), "added": len(new_rows)}