Create a Drive folder for each new hire in your roster

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

SHEET_ID, TEMPLATE, PARENT = "your-spreadsheet-id", "template-folder-id", "onboarding-folder-id"

@on_trigger
def run(event):
    creds = Credentials(credentials.connection("google", "work"))
    values = build("sheets", "v4", credentials=creds, cache_discovery=False).spreadsheets().values()
    rows = values.get(spreadsheetId=SHEET_ID, range="Onboarding!A2:C").execute().get("values", [])
    new = [(i + 2, r) for i, r in enumerate(rows) if len(r) >= 2 and len(r) < 3]
    report_fetched(len(new))
    if not new:
        return {"summary": "No new hires"}
    drive = build("drive", "v3", credentials=creds, cache_discovery=False).files()
    perms = build("drive", "v3", credentials=creds, cache_discovery=False).permissions()
    templates = drive.list(q=f"'{TEMPLATE}' in parents and trashed=false", fields="files(id,name)").execute()["files"]
    for row, (name, email) in new:
        folder = drive.create(body={"name": f"Onboarding - {name}", "mimeType": "application/vnd.google-apps.folder",
                                    "parents": [PARENT]}, fields="id,webViewLink").execute()
        for t in templates:
            drive.copy(fileId=t["id"], body={"name": t["name"], "parents": [folder["id"]]}).execute()
        perms.create(fileId=folder["id"], body={"type": "user", "role": "writer", "emailAddress": email}).execute()
        values.update(spreadsheetId=SHEET_ID, range=f"Onboarding!C{row}", valueInputOption="RAW",
                      body={"values": [[folder["webViewLink"]]]}).execute()
    return {"created": len(new)}