Adding some osu api functionality to your google spreadsheets.
Run this in terminal after replacing values in <>
git clone --depth 1 https://github.com/EnergoStalin/GoogleSpreadsheetOsuUtils.git && cd GoogleSpreadsheetOsuUtils
pnpm i
pnpm exec clasp login
pnpm run add <your spreadsheetId>
pnpm run push
Reload page and see Peppy console appears in the spreadsheet navbar.
Next set api v1 key in Peppy console tab and we're ready to use functions.
Ps. maybe i need publish this as google workspace app but look at how crazy their approval flow. So maybe sometime but definetely not now.
- Support of most common user and beatmap queries needed
If something not present you still can get it by using functions with Property or Properties suffix which extra argument is needed raw json property
- Configurable caching on document side
- Configurable refresh trigger through checkbox see
Using like this =if(RefreshToggle!$A$1=true, FetchOsuUserPP(cell),). Then just add custom trigger to refreshToggle function in script trigger section and it should recalculate all formulas writed as mentioned above
Warning Untested on large amount of data but in theory should perform well