Log completed Asana tasks to Google Sheets

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

PROJECTS = {"1200000000000001": "Client A", "1200000000000002": "Client B"}
SHEET_ID = "your-spreadsheet-id"

def asana(path, **params):
    r = http.get(f"https://app.asana.com/api/1.0/{path}", params=params,
                 headers={"Authorization": f"Bearer {credentials.secret('ASANA_TOKEN')}"})
    r.raise_for_status()
    return r.json()

@on_trigger
def run(event):
    since = state.get("since") or (datetime.now(timezone.utc) - timedelta(hours=1)).isoformat()
    now = datetime.now(timezone.utc).isoformat()
    rows = []
    for gid, name in PROJECTS.items():
        tasks = asana(f"projects/{gid}/tasks", completed_since=since, limit=100,
                      opt_fields="name,completed,completed_at,assignee.name,permalink_url")["data"]
        for t in tasks:
            if t["completed"] and t.get("completed_at") and t["completed_at"] > since:
                rows.append([t["completed_at"][:16].replace("T", " "), t["name"],
                             (t.get("assignee") or {}).get("name", ""), name, t["permalink_url"]])
    report_fetched(len(rows))
    if rows:
        build("sheets", "v4", credentials=Credentials(credentials.connection("google", "work")), cache_discovery=False) \
            .spreadsheets().values().append(spreadsheetId=SHEET_ID, range="Done!A:E", valueInputOption="USER_ENTERED",
                                            body={"values": sorted(rows)}).execute()
    state.set("since", now)
    return {"logged": len(rows)}