GoogleSpreadsheetOsuUtils

Adding some osu api functionality to your google spreadsheets.

Installing

Install nodejs preferrably using volta and pnpm.

Run this in terminal after replacing values in <>

set -e

git clone --depth 1 https://github.com/EnergoStalin/GoogleSpreadsheetOsuUtils.git
cd GoogleSpreadsheetOsuUtils
pnpm install
pnpm exec clasp login
pnpm run add <your spreadsheet id>
pnpm exec clasp push --force

Reload page and inside extensions navbar should appear GoogleSpreadsheetOsuUtils.

Next set api v1 key in here 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.

😳 Features

• 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

• Global mode setting i.e.(0 - STD, 1 - Taiko, 2 - CtB, 3 - Mania)

📝 Functions

Example spreadsheet

Warning Untested on large amount of data but in theory should perform well.