Sheets Macro for Challonge API

I maintain all of our tournament rosters inside a Google Sheet and want to connect that sheet directly to Challonge through a Google Apps Script macro. The script should do three things on command: pull my current list of tournaments from Challonge, spin up a brand-new tournament when I supply the parameters, and push the players already stored in the sheet straight into that event.

When I pull information back from Challonge, the macro must place the results as a clean, standard table in a designated range of the active sheet—no new tabs or pop-ups. I’m fine with using native Apps Script services (UrlFetchApp, SpreadsheetApp) and the official Challonge REST endpoints.

Deliverables
• An installable Apps Script bound to my spreadsheet
• Clear functions for 1) getTournaments(), 2) createTournament(), and 3) uploadPlayers()
• Inline comments so I can tweak API keys or ranges later
• A short walkthrough of how to authorize and trigger each function (custom menu or buttons are OK)

Acceptance criteria: running each function returns no errors, writes data exactly where expected, and reflects immediately on my Challonge dashboard.