List Google Drive folder files in Google Sheets

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

ROOT_FOLDER = "your-folder-id"
SHEET_ID = "your-spreadsheet-id"
FOLDER = "application/vnd.google-apps.folder"

@on_trigger
def run(event):
    creds = Credentials(credentials.connection("google", "work"))
    drive = build("drive", "v3", credentials=creds, cache_discovery=False).files()
    rows, queue = [], [(ROOT_FOLDER, "")]
    while queue:
        folder_id, path = queue.pop()
        token = None
        while True:
            res = drive.list(q=f"'{folder_id}' in parents and trashed = false", pageSize=1000, pageToken=token,
                             fields="nextPageToken, files(id,name,mimeType,modifiedTime,owners(emailAddress),webViewLink)").execute()
            for f in res["files"]:
                if f["mimeType"] == FOLDER:
                    queue.append((f["id"], f"{path} / {f['name']}".strip(" /")))
                else:
                    kind = f["mimeType"].split("/")[-1].replace("vnd.google-apps.", "Google ").upper() if "/" in f["mimeType"] else f["mimeType"]
                    rows.append([path or "(top)", f["name"], kind, (f.get("owners") or [{}])[0].get("emailAddress", ""),
                                 f["modifiedTime"][:10], f["webViewLink"]])
            token = res.get("nextPageToken")
            if not token:
                break
    report_fetched(len(rows))
    rows.sort(key=lambda r: r[4], reverse=True)
    tab = build("sheets", "v4", credentials=creds, cache_discovery=False).spreadsheets().values()
    tab.clear(spreadsheetId=SHEET_ID, range="Index!A:F").execute()
    tab.update(spreadsheetId=SHEET_ID, range="Index!A1", valueInputOption="RAW",
               body={"values": [["Folder", "File", "Type", "Owner", "Modified", "Link"]] + rows}).execute()
    return {"files": len(rows)}