Export Discord members with a role to Google Sheets

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

GUILD_ID = "your-server-id"
ROLE_NAME = "Subscriber"
SHEET_ID = "your-spreadsheet-id"

@on_trigger
def run(event):
    api = "https://discord.com/api/v10"
    h = {"Authorization": f"Bot {credentials.secret('DISCORD_BOT_TOKEN')}"}
    try:
        role = next(r["id"] for r in http.get(f"{api}/guilds/{GUILD_ID}/roles", headers=h).json() if r["name"] == ROLE_NAME)
        rows, after = [], "0"
        while True:
            page = http.get(f"{api}/guilds/{GUILD_ID}/members", headers=h, params={"limit": 1000, "after": after}).json()
            rows += [[m["user"]["id"], m["user"]["username"], m.get("nick") or m["user"].get("global_name") or "", m["joined_at"][:10]] for m in page if role in m["roles"]]
            if len(page) < 1000:
                break
            after = page[-1]["user"]["id"]
    except Exception as e:
        notify.email_me("Discord member export failed", str(e))
        raise
    sheets = build("sheets", "v4", credentials=Credentials(credentials.connection("google", "work")), cache_discovery=False)
    sheets.spreadsheets().values().clear(spreadsheetId=SHEET_ID, range="Members!A2:D").execute()
    sheets.spreadsheets().values().update(spreadsheetId=SHEET_ID, range="Members!A2", valueInputOption="RAW", body={"values": rows}).execute()
    return {"members": len(rows)}