Export Asana project tasks to Google Sheets

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

PROJECT_GID = "1200000000000000"
SHEET_ID = "your-spreadsheet-id"
FIELDS = "name,completed,due_on,assignee.name,memberships.section.name,permalink_url"

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):
    tasks, offset = [], None
    while True:
        page = asana(f"projects/{PROJECT_GID}/tasks", opt_fields=FIELDS, limit=100, **({"offset": offset} if offset else {}))
        tasks += page["data"]
        offset = (page.get("next_page") or {}).get("offset")
        if not offset:
            break
    report_fetched(len(tasks))
    rows = [["Section", "Task", "Assignee", "Due", "Done", "Link"]]
    for t in tasks:
        section = next((m["section"]["name"] for m in t.get("memberships", []) if m.get("section")), "")
        rows.append([section, t["name"], (t.get("assignee") or {}).get("name", ""), t.get("due_on") or "",
                     "Yes" if t["completed"] else "No", t["permalink_url"]])
    tab = build("sheets", "v4", credentials=Credentials(credentials.connection("google", "work")), cache_discovery=False).spreadsheets().values()
    tab.clear(spreadsheetId=SHEET_ID, range="Tasks!A:F").execute()
    tab.update(spreadsheetId=SHEET_ID, range="Tasks!A1", valueInputOption="RAW", body={"values": rows}).execute()
    return {"tasks": len(tasks)}