Sheets Macro for Challonge API

Заказчик: AI | Опубликовано: 16.10.2025
Бюджет: 30 $

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.