Create a Discord channel for each new project in your sheet

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

SHEET_ID = "your-spreadsheet-id"
GUILD_ID = "your-discord-server-id"
CATEGORY_ID = "your-category-id"

@on_trigger
def run(event):
    sheets = build("sheets", "v4", credentials=Credentials(credentials.connection("google", "work")), cache_discovery=False)
    rows = sheets.spreadsheets().values().get(spreadsheetId=SHEET_ID, range="Projects!A2:C").execute().get("values", [])
    new = [(i + 2, r) for i, r in enumerate(rows) if r and r[0] and (len(r) < 3 or not r[2])]
    report_fetched(len(new))
    if not new:
        return {"summary": "Nothing new"}
    bot = {"Authorization": f"Bot {credentials.secret('DISCORD_BOT_TOKEN')}"}
    for row, r in new:
        name = re.sub(r"[^a-z0-9]+", "-", r[0].lower()).strip("-")[:90]
        ch = http.post(f"https://discord.com/api/v10/guilds/{GUILD_ID}/channels", headers=bot,
                       json={"name": name, "type": 0, "parent_id": CATEGORY_ID}).json()
        mentions = " ".join(f"<@{m.strip()}>" for m in (r[1] if len(r) > 1 else "").split(",") if m.strip())
        http.post(f"https://discord.com/api/v10/channels/{ch['id']}/messages", headers=bot,
                  json={"content": f"Welcome to **{r[0]}** {mentions}"})
        sheets.spreadsheets().values().update(spreadsheetId=SHEET_ID, range=f"Projects!C{row}",
                                              valueInputOption="RAW", body={"values": [[ch["id"]]]}).execute()
    return {"summary": f"{len(new)} channels created"}